Azure SQL

SQLServerCentral Article

Deploying Azure SQL Database Using an ARM Template

  • Article

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).

5 (1)

You rated this post out of 5. Change rating

2024-02-02

2,480 reads

SQLServerCentral Article

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022

  • Article

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.

You rated this post out of 5. Change rating

2023-07-21

3,932 reads

Blogs

Capturing errors and auditing in Azure SQL DB

By

Logging is a necessity in the database world, well, the entire tech world. You...

Stepping into Event Streaming with Microsoft Fabric

By

(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...

Sabbatical le Troisième: A Recharge Week

By

It’s been a week since I flew home from London and Redgate to begin...

Read the latest Blogs

Forums

The Mindset of a Database Administrator: A Love Letter to Risk Aversion

By dbakevlar

Comments posted to this topic are about the item The Mindset of a Database...

Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You

By Chandan Shukla

Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...

how to move all SP from one db to another db?

By water490

Hi everyone I have two db - one is test and other is archive. ...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers