Remove Witness from 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)...

SQL PASS Summit 2014 Diary – Days 3-5

The last two days have been an absolute blur.  As I first posted this week, I had planned to blog...

Summit 2014 – Next Impressions

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...

Summit 2014 – Next Impressions

As Summit 2014 begins to wind down, it is time for some more impressions from the week.  The week has...

Thoughts on the 2014 PASS Summit From A Non-Attendee

I missed the Summit this year, but tried to follow along remotely via Twitter, PASSTV, and the blog posts I...

Versioning In Your SQL Database

Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...

Another great reason to enable remote admin connections

I recently came cross another great reason to enable the remote admin connections server configuration on SQL server.
If you don’t...

Configuring a Complete Memory Dump

Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...

Drop and Recreate all Synonyms

Had a quick job the other day restoring a pair of databases under different names which is all straight forward...

PASS Summit 2014 Day 2 Keynote Live Blog

We are back in the keynote room with Adam Jorgensen talking to us about the financial state and health of...