If you’ve been contemplating enrolling in Brent Ozar’s SQL Server classes, I recommend you take advantage of this year’s Black Friday sale. Keep reading to understand why I recommend his …
SQL Server
-
- SQL ServerTroubleshooting
Characters displayed as question marks or squares in SQL Server
by Vlad DrumeaIn this post I’m going over potential reasons for why some special characters end up corrupted and displayed as question marks, squares or something completely different in SQL Server. Note …
-
In this post I cover ways to fix performance problems caused by implicit conversion when the query cannot be modified. What is an implicit conversion? I’ve already covered, in detail, …
-
In this post I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance. Types of conversions in SQL Server If …
- ContainersSQL Server
0A000086 and command not found with latest mssql-tools for Linux
by Vlad DrumeaIn this post I cover the 0A000086 and “command not found” errors that you might encounter with the new version of SQL Server command-line tools, namely sqlcmd and bcp, for …
-
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 …
- Home LabPowerShellScriptsSQL Server
Automate SQL Server installation using PowerShell
by Vlad DrumeaIn 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. …