Category: SQL Server
29.09.2022
“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…
21.09.2022
Cracking SQL Server login passwords offline
Have you ever wanted to do a password audit on the SQL logins that applications and developers use…
15.09.2022
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…
31.08.2022
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…
02.03.2021
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.
23.02.2021
“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
Latest Posts
Categories
Archives
Latest Comments
Good stuff! Also, I think that accessing the server through DAC , would have worked
Sorry for the late reply. I took a break from the blog for a couple of months. Can you please…
Not sure what I did wrong but when I executed the Powershell .\psblitzl.ps1 wsfpv02342\mstqip05 -checkdb hgxcore I got the following…
Hi Leo, Thank you for your input! Regarding exporting and importing settings: It's doable, and that's why I change the…
Thank you! Yes, DAC would be a viable alternative to starting the instance in single user mode. The only thing…