Query memory grants part 2: Varchars and sorting

Why the heck did we make all our columns varchar? That’s a hypothetical question, please.
But now we have to pay...

A shell for working with Kubernetes

I’m always a fan of tools that can make my life easier.
One tool that I’ve recently come across is...

Waiter Waiter There's an Index in my Index

I’ve done a few posts on Clustered and Non-Clustered indexes before, what I’ve not however covered and something that is...

Store sensitive information with Azure Key Vault

Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.One of my Code Project article on SQL Trigger has been selected as entry in this contest. I...

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

One of my Code Project article on SQL Trigger has...

BIOS and OS Power Settings to enhance SQL Server Performance

Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive...

A Monumental Migration to SQL Server 2016 - Part 2

In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...

Automating like an Enterprise DBA

One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....

Automating like an Enterprise DBA

TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...