SQL Server

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 …

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 …

This brief post contains a script that can help switch a whole SQL Server instance, model and all user databases, to SIMPLE recovery. The script is useful in case of …

This post demos a PowerShell script that I’ve put together to automate the configuration of the static TCP port, and the addition of firewall rules, for a SQL Server instance. …

This is a brief post containing the steps needed to reset the sa login’s password in SQL Server running on Linux. Intro This is pretty useful if you’ve inherited a …

This post covers a few ways to fix the SSL certificate error 1416F086 returned by sqlcmd on Linux when connecting to SQL Server. If you’re looking for ways to fix …

This is a brief post containing a script you can use to delete extra tempdb data files and avoid the “file not empty” (Msg 5042) error. I’ve occasionally ran into …