Category: SQL Server
“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…