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

Improving SQL Server Performance and Availability with Accelerated Database Recovery

For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can cause a lot of downtime and have a negative effect on business operations. However, with the introduction of Accelerated Database Recovery (ADR), Microsoft SQL Server has added a potent new feature that greatly enhances database availability and […]

5 (1)

You rated this post out of 5. Change rating

2023-05-02 (first published: )

2,254 reads

Blog Post

Intelligent Query Processing (IQP)

In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...

2023-03-20 (first published: )

474 reads

Blog Post

In Memory OLTP – 1

In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...

2016-12-06

624 reads

Blogs

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics

By

This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how...

Microsoft 365 Security and Compliance for Administrators, a Book Review

By

I was asked to review the following book by the publisher, and I must...

Read the latest Blogs

Forums

Issues adding and updating a column

By richardmgreen1

Hi all   I'm hoping someone will able to say "you're an idiot because....."...

Deadlocks with UPDATE statements using serializable transaction isolation level

By zoggling

We are seeing frequent deadlocks occurring due to a particular stored procedure that is...

Use Polybase with ODBC to create external table

By blom0344

I'm trying to use the installed Polybase service on an  SQL 2019 server to...

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers