Introduction to SQL Server replication

This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...

VS Code: PowerShell and focusConsoleOnExecute

If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your...

Always update your views

I last posted about changing a table without changing a view that represents the table and how this may affect...

Book Review: High Performance SQL Server

As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...

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