prakash karande

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

1,651 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: )

378 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

619 reads

Blogs

Microsoft Announcement: Microsoft Fabric

By

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders

By

A customer asked about how they could organize their migration scripts in different ways...

Read the latest Blogs

Forums

Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?

By Rich Mechaber

I'm trying to create an SSIS package that will query a master control table...

Database copy issue through - COPY DB WIZARD

By Kaushik Parui

I have a production server with SQL server 2016 version (13.0.5026.0) and a database...

Help with a SQL Unpivot

By rogue1009

I am trying to use unpivot to extract some data, however, the results are...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers