What’s in my backup file?
Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...
2017-02-22
946 reads
SQLStudies
Penny wise, pound stupid
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...
2017-02-20
420 reads
Deadlock on ALTER DATABASE
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...
2017-02-16
1,422 reads
Server level database permissions
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...
2017-02-14
732 reads
Deadlock priority
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who...
2017-02-17 (first published: 2017-02-08)
2,911 reads
SQL Connectivity issues: A guided walk through
The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.
Announcement
Walk Through
If you look...
2017-02-06
423 reads
Changing what SSMS opens on startup
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...
2017-02-01
785 reads
Azure quick start
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
684 reads
My SQL logins don’t work. Again.
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...
2017-02-02 (first published: 2017-01-25)
2,389 reads
Creating a connect entry.
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,125 reads
Blogs
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers