Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,528 reads
Blog Posts
How to kill a negative SPID (like SPID -2 or -3) in SQL Server?
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all...
2014-08-25
38 reads
How to kill a negative SPID (like SPID -2 or -3) in SQL Server?
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,559 reads
Last Weeks Top “Reading” Links #98
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-25
682 reads
Refreshing A SQL Mirrored Database Using Powershell
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...
2014-08-25
1,117 reads
The amazing never shrinking heap
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
621 reads
The Good the Bad and the Ugly of my extended job search
Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my...
2014-08-25
392 reads
Speaking at SQLSaturday #336 Holland
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This...
2014-08-23
715 reads
Friday Followup For August 22, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-22
379 reads
Odds and Ends To Think About
Got this in morning email from Khan Academy. Not sure if I agree that we all can learn anything, but...
2014-08-22
585 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers