The New CU Schedule

Is my math right? The new CU servicing schedule for SQL Server 2017 is:
1 CU per month for the first...

SQL Server Tracking Tempdb Size

Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...

3 Tips You Need To Know When Using PowerShell with SQL Server

Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...

3 Tips You Need To Know When Using PowerShell with SQL Server

Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...

Deploy SSAS Cubes With PowerShell

Hello!
Recently someone got in touch with me about one of my earliest posts on my old blog. I realised I...

SQL Server 2017 — change the tag for your docker images

Firstly:

SQL Server 2017 is now officially released!
I have been using SQL Server 2017 running on Linux for a while now...

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