SQL Server

This post demos a script I put together to help move SQL Server database files to another drive and folder by generating PowerShell and T-SQL commands. I’ve decided to make …

In this post I clarify some misconceptions that I’ve seen regarding how SQL Server accesses files and potential file access denied errors. Intro This is one of those things that’s …

This is a brief post about fixing the “msoledbsql.msi feature resource unavailable” error when repairing or reinstalling SQL Server. The error I’ve recently had to do a repair of the …

In this post I’ll go over the steps to repair a SQL Server instance, via both GUI and PowerShell, and when you might need to do it. I’d also like …

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

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