Query Store for Everyone

Query Store for Everyone

SQL Server 2016’s Query Store feature is, without a doubt, one of the most exciting new features for this version. The Query Store will keep track of current and past query execution plans which grants you deeper insights into the performance…

Heap tables in SQL Server

Heap tables in SQL Server

In the last post of this blog series, I discussed what a B-Tree index was and briefly explained its history. Before we dive into the indexes which SQL Server uses, it is important to set the foundation of data structures. The…

Favorite SQL Server Feature – #TSQL2SDAY #77

Favorite SQL Server Feature – #TSQL2SDAY #77

Today is the 77th T-SQL2SDAY! If you’re not familiar, T-SQL Tuesday is a blogging party hosted by a different person each month. It’s a creation of Adam Machanic (b|l|t), and it’s been going on for ages now! Basically the host…

The ‘B’ in B-Tree – Indexing in SQL Server

The ‘B’ in B-Tree – Indexing in SQL Server

Some people advocate we should count by twelve rather than ten. This is because you can easily count the twelve segments of your fingers by using your thumb as a pointer. With that method, you can count the number of…

Everything has a cost

Everything has a cost

Too often we end up in a conflict while trying to explain how a minimally impacting function has no true business impact. If you are too detailed, no one wants to listen to you and you are wasting their time. If…

SQL Server 2016 Release Date

SQL Server 2016 Release Date

tl;dr No release date was announced at Data Driven but it was announced on SQL Server Blog. SQL Server 2016 will be released for general availability on June 1st, 2016! Take a look at the feature breakdown by edition here….

Availability Group Architecture – DR on the Cheap

Availability Group Architecture – DR on the Cheap

Last time, I discussed how to limit data duplication between data centers as a cost-effective option with an Availability Group. In this post I will take cost reduction one step further by short-changing the disaster recovery site. Disaster recovery on the…

Availability Group Architecture – FCI hybrid

Availability Group Architecture – FCI hybrid

Last time, I discussed how to meet high-availability (HA) and disaster recovery (DR) using four stand-alone SQL Server instances in an Availability Group. In this post, I will add SQL Server Failover Cluster Instances to the mix and cut the…

Availability Group Architecture – Adding a Second Site

Availability Group Architecture – Adding a Second Site

Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture, adding in a second site to achieve more than just high-availability. Cross sub-net availability group In…

Availability Group Architecture – High-Availability Only

Availability Group Architecture – High-Availability Only

Availability groups offer us a variety of features. They offer high-availability (HA), they can give disaster recovery (DR), and they have connectivity and off-loading features but we have to decide how to use them. This is the first of a four-part…