2024

In this post I’ll go over some examples of how to parse text log files with PowerShell, specifically my blog’s raw access log from cPanel. Access log file structure Each …

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 …

This is a brief post demoing how to benchmark LAN throughput using iPerf3 between a Linux machine and a PC running Windows. What’s iPerf3? iPerf3 is a cross-platform tool for …

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 …