DB unit testing has been a cloud for a long Continue reading “Database Unit Testing with SSDT”
Tag: Troubleshooting
Sean’s Famous Backup Tuning class!
Yes, you can tune your SQL Server backups!
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of Continue reading “Sean’s Famous Backup Tuning class!”
What are Orphaned Users?
Here I’ll describe what an orphaned user is and how it happens. I’ll even show you how to produce the condition yourself. Orphaned Continue reading “What are Orphaned Users?”
Troubleshoot DB Connection with Telnet
Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect. Using telnet you can tell pretty clearly Continue reading “Troubleshoot DB Connection with Telnet”
Hack-attak a damaged DB
What do you do if you have a set of data and log files you can’t attach because the log is damaged? Here I show Continue reading “Hack-attak a damaged DB”