Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2....
2014-11-10
4,030 reads
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2....
2014-11-10
4,030 reads
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...
2014-11-10
1,259 reads
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...
2014-11-09
309 reads
Today is the last official day of the PASS Summit. The sessions will wrap up at the end of the...
2014-11-08
853 reads
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,048 reads
On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...
2014-11-07
798 reads
There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...
2014-11-07
1,115 reads
Hello friends,
Many times it happened with me I forgot the instance name of SQL Server.
So here is a small trick...
2014-11-07
313 reads
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has been good so far. It has been very busy...
2014-11-07
15 reads
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has...
2014-11-07
630 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