2024

In a previous post I’ve covered how to use the new sqlcmd to spin up a SQL Server Developer Edition container, in this post I cover how to achieve that …

This post contains a short SQL Server query to get storage info for the disks hosting your instance’s database files without having to RDP into its host VM. The query …

In this post I’ll demo how to export XML files from SQL Server via PowerShell. It’s pretty much the same method I use in PSBlitz to export execution plans and …

This is a really short post covering the cause and fix for slow/poor VirtualBox VM performance on Windows hosts. So in one of my previous posts I’ve enabled a Windows …

Terminal window showing the output of the above PowerShell code. ping sweep in powershell

In this post I cover a script I’ve been using to automate SQL Server installation with PowerShell in my home lab. As opposed to my previous blog post that demos …

This post covers step-by-step instructions on creating a SQL Server Developer edition container using the new Go-based sqlcmd, as well as getting the default login’s password and connecting via SSMS. …

In a previous post, I’ve covered how to import and query HTML table data in SQL Server, so I figured it makes sense to also show ho to export SQL …

This weekend, while working on a long overdue PSBlitz update, I’ve ran into an interesting issue that ended up truncating an NVARCHAR(MAX) variable to 4000 characters. Intro The code in …