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 …
SQL Server
-
-
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 …
- SQL ServerTips And Tricks
Dangerous SET options stored procedure inherit from your session
by Vlad DrumeaIn 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 …
- SecuritySQL ServerTroubleshooting
What people get wrong about how SQL Server accesses files
by Vlad DrumeaIn 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 …
- SQL ServerTroubleshooting
Fix for msoledbsql.msi feature resource unavailable when repairing or reinstalling SQL Server
by Vlad DrumeaThis 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? …