SQL Server

In this post I demo and explain a few variations of basic SQL injection using PowerShell and SQL Server. What is SQL injection? SQL injection, also refereed to as SQLi, …

SQL Server Management Studio 21 Preview 1 was released 2 days ago, so I took it out for a spin and here are my first impressions so far. Download You …

In this blog post I go over my reasons for always recommending SQL Server Developer Edition over Express Edition for beginners learning SQL Server. It’s free for non-production use Just …

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 …

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 …

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