SQL Server

This post outlines a list of feedback items for SSMS 21 that I believe should be addressed before SSMS 21 goes GA. Note: If you see anything that you agree …

In this post I demo a script I put together to count NULLs in all columns of a given table in SQL Server and store the results in a table. …

This is a brief post containing a query that lists object dependencies in SQL Server for either a specific object or for the entire database. Intro Figuring out object dependencies …

In this post I demo a query to get connection information in SQL Server aggregated by database, host, client and login name. Intro I’ve spent some time this week working …

In this post I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created. Intro You might have noticed when scripting out …

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