SQL Mirroring, Preserving the Log Chain During Database Migrations

This is a reblog of a post that I originally wrote back in January.  After using this technique again last...

Haunted SQL

I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...

How to reset the password of Microsoft Azure virtual machine using PowerShell

Hello friends, Please find the link of my article here – https://social.technet.microsoft.com/wiki/contents/articles/40112.microsoft-azure-how-to-reset-the-password-of-azure-virtual-machine-using-powershell.aspx

Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Power BI Custom Visuals Class (Module 71 – Timeline Storyteller)

In this module you will learn how to use the Timeline Storyteller.  The Timeline Storyteller is a great way to...

How to configure Always Encrypted in SQL Server 2016 using SSMS, PowerShell and T-SQL

In an era of remote storage and retrieval of data, including the cloud, data security plays a vital role, especially...

Test Your SQL Memory Setting with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...

SQL Homework – October 2017 – Sample/Test Database(s)

Last month your homework was to set up your own lab. Now it’s time to put a sample database or...

SQL Server – Pause VS Stop

You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...

Monday Coffee: Long hours worked

Last week I asked the following question on twitter: –

I had a load of responses from a lot of DBAs...