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
943 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
418 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,420 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
730 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,910 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
782 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,124 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers