Blog

6 min read

Partial Database Availability in SQL Server

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

4 min read

5 Lesser Known Features of SQL Server Management Studio 2016

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.

3 min read

Upgrading Reporting Services for SQL Server 2016

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

7 min read

What is the New Seeding Capability in SQL Server 2016 AlwaysOn AG?

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

5 min read

What is Instant About Instant File Initialization for SQL Server?

Instant File Initialization surfaced in SQL Server 2005. I will show you how to enable this feature and show how it drastically improves performance.

4 min read

Native JSON Support Gets Even Better With SQL Server 2016

Every 5 years we 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.

4 min read

SQL Server In-Memory OLTP – New Index – Hash Index

If we ask any DBA about the types of indexes in SQL Server, most likely they would answer – clustered index and non-clustered index.

4 min read

Four Things To Remember While Planning SQL Partitioning

Before covering what to remember, let’s cover the basics. What is table partitioning in SQL Server?

5 min read

SQL Server In-Memory tables – Where is data stored?

SQL Server 2014 introduced the concept of InMemory OLTP which has been a lesser explored topic for many.

4 min read

SQL Server: In-Memory and Durable. How is That Possible?

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.