2024-03-29
3,037 reads
Azure SQL
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).
2024-02-02
1,804 reads
Optimized locking in Azure SQL Database
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In its early days, it was missing several important features (like data compression). While that hole has been plugged, there are still other limitations and differences you should be aware o
2024-02-02
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
2023-10-30
2,581 reads
The SQL Developer Experience: Beyond RDBMS
Microsoft has built an amazing platform with Azure SQL Database and has recently announced an offer to use this for free. Read about the capabilities and options with this cloud database platform.
2023-10-13
2,718 reads
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.
2023-07-21
2,851 reads
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,338 reads
Database Deployment with Terraform - The Basics
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
13,428 reads
2022-02-28
10,074 reads
Azure SQL Migrations using Azure Data Studio
This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.
2021-09-20
6,235 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
I have never seen an insert statement with -= tablename in place of values
We have a third part software and looking at some of their SQL we...
Automate reports for when the SQL database was last used
Hi, I'm working on cleanup activity of deleting databases that aren't in use or...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers