Painful or Helpful? No SSMS Multiserver Results if One Instance Errors
I've been going back and forth with this question for a few days now.
If one instance in a multiserver query presents an...
2014-09-01 (first published: 2014-08-26)
6,268 reads
I've been going back and forth with this question for a few days now.
If one instance in a multiserver query presents an...
2014-09-01 (first published: 2014-08-26)
6,268 reads
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
39 reads
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...
2014-08-25
1,125 reads
Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to...
2014-08-28 (first published: 2014-08-25)
7,625 reads
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
685 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,575 reads
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
626 reads
I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to...
2014-08-29 (first published: 2014-08-25)
6,951 reads
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
394 reads
This is the second post in my series on parameterization. In the first post I wrote about plan caching and...
2014-08-28 (first published: 2014-08-25)
9,149 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers