Prakash K

I am a MS SQL DBA, born and brought up in Mumbai, India. Done my engineering in Electronics And Telecommunications and have been working in this industry as a DBA since 2011

SQLServerCentral Article

Memory Grant Feedback Persistence in SQL Server 2022

By using input from real memory consumption during query execution, Memory Grant input Persistence in SQL Server 2022 is a potent feature that helps optimize query performance. In order to improve the accuracy of memory grant calculations for subsequent executions of the same or comparable queries, SQL Server gathers and stores this information.

5 (3)

You rated this post out of 5. Change rating

2024-06-12

1,000 reads

SQLServerCentral Article

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

You rated this post out of 5. Change rating

2024-02-02

1,600 reads

SQLServerCentral Article

Creating a Hyperscale Database in Azure Using the Azure Portal

One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.

5 (1)

You rated this post out of 5. Change rating

2023-12-22

1,134 reads

SQLServerCentral Article

Backup and Restore SQL Database to Azure Blob Storage

SQL databases are crucial for businesses, so it's critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let's examine the advantages, the steps involved in backing up to and restoring from a device, recommended practices, and more.

5 (3)

You rated this post out of 5. Change rating

2023-09-15

5,317 reads

SQLServerCentral Article

Optimized Plan Forcing with Query Store in SQL Server 2022

In this Article ,  We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.

5 (1)

You rated this post out of 5. Change rating

2023-09-04

3,321 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2023-07-21

2,595 reads

Blogs

The Annual SQL Saturday in Baton Rouge

By

I’ve been to quite a few of the SQL Saturday Baton Rouge events. There...

25 Years of Redgate

By

I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company...

Read the latest Blogs

Forums

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Notebook Jobs in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Notebook Jobs in Azure Data...

Behaviour since moving to Azure

By Barry G Freeman

Hello, all, Recently we have migrated a few AGs up to Azure.  These are...

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers