SQL Server

I’ve been looking in the past couple of weeks for posts testing large insert speeds in SQL Server between different scenarios, and was unable to find anything more recent that …

In this post I’ll go over a possible cause for SQL Server connection errors 64 233, variations, and how to fix them. In the past couple of weeks I’ve ran …

Since SQL Server Management Studio 19 has just been released last week, I’ve figured I’d take this opportunity to go through my configuration preferences. Update note 2024-06-17:These are my personal …

In this post I’ll demo how to use PowerShell to retrieve execution plan files from a SQL Server instance. It’s pretty much the same method I’ve used in PSBlitz to …

I figured I might get ChatGPT to write T-SQL, test out the results, and see how it compares to T-SQL written by a human. Warning: Do not run any of …

In this post I’ll go over the relationship between unique constraints and NULLs in SQL Server, and how you can have multiple NULLs in a unique constraint. What is a …

Version 2.1.0 of the PSBlitz SQL Server diagnostics collection and output tool brings bug fixes, quality of life enhancements, and added diagnostics data. Enhancements Additional diagnostics data The following sheets …

In SQL Server, members of a database’s db_owner role can end up getting membership in the sysadmin server level role if the database is set as trustworthy and it’s owned …

In this post I’ll outline the process of setting up an Ubuntu Server VM in Oracle VirtualBox for running SQL Server on Linux. If you want to do this via …

This post aims to clarify what dbo is in SQL Server, since it tends to be a source of confusion, especially for those coming from Oralce. So, what exactly is …