T-SQL

In this post I demo and explain a few variations of basic SQL injection using PowerShell and SQL Server, while also showing how to address it. What is SQL injection? …

In 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 …

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

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