In this video we cover how the correct use of Indexes can help elimintae CPU bottlenecks , we cover how to identify CPU issues and a few different […]
Which is better Delayed Durability or Optimistic Concurrency
A brand new video covering the performance impact of delayed Durability vs Optimistic Concurrency. Which is better? While both have different behavior and purpose; when it comes down […]
Using MS SQL Server to work with assemblies (CLR)
A brand new video uploaded on YouTube on how to use CLR assemblies in MS SQL Server. Please share and like and we look forward to comments. https://www.youtube.com/watch?v=5sOlIIC-UXg […]
Which is better Count (*) or Count (id)?
While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so […]
Storing the MDF and LDF files of SQL Server on Azure Storage Part 2
In this second part on the series of how to add mdf and ldf files to Azure Storage we need to create a credential in the database in […]
Storing the MDF and LDF files of SQL Server on Azure Storage Part 1
One of the new features of SQL Server 2014 that have been introduced allow users to create mdf and ldf files in the Azure BLOB Storage containers and […]
Installing SQL 2014
Installing SQL 2014, if you have ever installed SQL you shouldn’t find anything surprising here.
Part 2 Buffer pool extension SQL 2014
In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it […]
Part 1 Buffer pool extension SQL 2014
In this series I am going to cover the feature Buffer pool extension in MS SQL Server. Now before we can discuss this feature it might be a […]
Indexes – F1 Crash Course
There are a million articles, blogs post etc. about indexes out there, I am guilty too of contributing to it. Here is my attempt at correcting the vast […]