Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Author: Pinal Dave
Browse Blog Categories
Partial Database Availability

Partial Database Availability in SQL Server

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

Pinal Dave | November 1, 2016
SQL Server Management Studio Features

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.

Pinal Dave | October 11, 2016

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

Pinal Dave | October 5, 2016

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.

Pinal Dave | September 6, 2016
Instant File

What is Instant About Instant File Initialization for SQL Server?

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.

Pinal Dave | August 3, 2016

Native JSON Support Gets Even Better With SQL Server 2016

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.

Pinal Dave | November 24, 2015

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. This is no longer valid from SQL Server 2014 onwards, in which Microsoft introduced new types of tables called in-memory tables. The storage of these tables is not a traditional MDF […]

Pinal Dave | March 27, 2015

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? In SQL Server a partitioned table is one that is referred to as one table but is subdivided into multiple partitions in which data is partitioned horizontally. A partitioned table has the following properties: Partition Scheme: This defines which […]

Pinal Dave | March 23, 2015

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

Pinal Dave | February 20, 2015

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. Well, as we mentioned – it is a myth. In reality, SQL Server guarantees changes made to durable tables are permanent and can survive a database or SQL […]

Pinal Dave | February 10, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS