2022

In a previous post I’ve covered the process of setting up a Windows Server 2019 VM in VirtualBox. So I’ve figured that I should add one to cover the creation …

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 go over the process of building both Linux and Windows VMs in Oracle VirtualBox using PowerShell on a Windows host. Prerequisites Building Windows VM via PowerShell …

In this post I’m going through the steps required for setting up a Windows Server 2019 VM in Oracle VirtualBox on a Windows 10 host. In a previous post, I’ve …

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 …

In a previous post we’ve looked at offline methods of cracking SQL Server login passwords as a means of auditing the password strength. But what if, due to security concerns …