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

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

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

Point In Time Restore for Azure SQL Database

Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...

T-SQL Tuesday #110 – Automate All the Things

Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...