Author: Pinal Dave

Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and have written over 3800 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 14+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

Consultant to Datavail

Pinal Dave

Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and have written over 3800 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 14+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

Articles Written by Pinal Dave

Learn about partial database availability and its applications in SQL Server.

Read More

SQL Server Management Studio (SSMS) is one of the most used tool by SQL Server DBAs around the world. Here are a few lesser-known features.

Read More

SQL Server 2016 is shipped with significant enhancements to Microsoft's reporting generating toolkit — SQL Server Reporting Services (SSRS).

Read More

The new enhancement available in SQL Server 2016 availability group is called as direct seeing or automatic seeding. Learn more about it here.

Read More

Instant File Initialization surfaced for the first time in SQL Server 2005. I will show you how to enable this feature and provide a quick demo that exhibits how it drastically improves performance.

Read More

Every five years we seem to see technology innovations that rock the industry and I am amazed to see how we seem to have to make a fresh start every other year.

Read More

If we ask any DBA about the types of indexes in SQL Server, most likely they would answer – clustered index and non-clustered index. This is no longer valid from SQL Server 2014 onwards, in which Microsoft introduced new types...

Read More

Before covering what to remember, let’s cover the basics. What is table partitioning in SQL Server? In SQL Server a partitioned table is one that is referred to as one table but is subdivided into multiple partitions in which data...

Read More

SQL Server 2014 introduced the concept of InMemory OLTP which has been a lesser explored topic for many. Previously we saw how these InMemory tables can be created and how one can access the same. Once the table is created, the syntax, TSQL construct and access seems to be almost similar to how a normal table is created.

Read More

One of the major myths about SQL Server In-Memory OLTP is that since the data resides in memory, it would be lost once SQL Server is restarted. Well, as we mentioned – it is a myth. In reality, SQL Server...

Read More