TICK TOCK…6 MONTHS UNTIL SQL SERVER 2008/2008 R2 SUPPORT EXPIRES UNLESS YOU TAKE ACTION

If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9,...

Back to the future

It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...

Source Control using Azure Data Studio and GitHub

You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...

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