2016 Azure Database 
SQL Performance
AUGUST 11, 2021
One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. DATE_BUCKET. Emulating DATE_BUCKET.
SQL Performance
APRIL 8, 2019
These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. GHz Intel Xeon E5-2673 v3 (Haswell) processors that Microsoft uses for many of their Azure VM series. Azure Lsv2 Details. Table 1: Lsv2 Series Azure VM Specifications.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
JUNE 21, 2019
This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.
SQL Performance
AUGUST 14, 2019
In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. There are two common pitfalls involving window functions, both of which are the result of counterintuitive implicit defaults that are imposed by the SQL standard.
Percona
APRIL 12, 2023
They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2016: The company adds service-loaded MongoDB Professional to its mix.
SQL Server According to Bob
JANUARY 26, 2017
Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. That is to ensure your database is encrypted at the file level.
SQL Server According to Bob
JULY 13, 2016
Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this.
Expert insights. Personalized for you.
139 
Let's personalize your content