Setting up an Ubuntu VM for SQL Server 2019 and 2022
In this post I’ll outline the process of setting up an Ubuntu Server VM in Oracle VirtualBox for…
What is dbo, anyway?
The dbo schema and user pair tend to be a source of confusion, especially for people who come…
Cracking SQL Server login passwords online
In a previous post we’ve looked at offline methods of cracking SQL Server login passwords as a means…
“Access denied” when attaching a database via SSMS
A few ways of fixing the access denied error you’re attaching a database to an instance, either as…
Cracking SQL Server login passwords offline
Have you ever wanted to do a password audit on the SQL logins that applications and developers use…
PSBlitz – Easily outputs SQL Server diagnostics data
PSBlitz is a PowerShell script that outputs SQL Server health and performance diagnostics data to Excel and saves…
Recovering master database with corrupted t-log and no backups
You get a call about a database server that went down due to a power outage and now…
T-SQL script to kill multiple sessions in one go
Ever needed a script to kill multiple sessions on your SQL Server instance, but still required some level of control over what was being targeted?
This script might come in handy.
“The parameter is incorrect. [0x80070057]”
Fixing “The parameter is incorrect. [0x80070057]” error when changing a SQL Server service account from Local System to anything else
Thank you! Yes, DAC would be a viable alternative to starting the instance in single user mode. The only thing…