This week I had an application team report the error “SQL Connection Lost”. Fortunately they also reported the exact times of occurrence, which made it much easier to hunt down. I did some digging through the SQL logs and DMVs, but did not find anything that indicated SQL was dropping… Read more
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an event organizer, all 3 automatically went to community vote. I am very excited that my Mirroring session was voted in. Thank you to everyone who voted for me!
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on Mirroring.
Move over Poseidon. I’m hitting the sea with my own trident (assuming I can get it through the TSA). My trident is made from the culmination of my favorite three things. My wife, SQL Server, and cruising. Let me explain.
Back in October of last year, Idera ran a contest… Read more
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant this chapter needed some additional hands on deck. Erin Stellato (Blog|Twitter) valiantly volunteered to take the helm and she put out an SOS for volunteers. The… Read more
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to… Read more
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community. We are excited to announce that event registration opens November 30, 2011.
Make sure to get registered soon… Read more
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. First we need to open SQL Server Management Studio and connect to our server. Then we need to enable Policy Management by expanding the Management node, right clicking on Policy… Read more
Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server. You can also import policies that you have exported from other servers. The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by… Read more
If you need to setup a Central Management Server or just want to check it out, then here is how to do it.
Open SQL Server Management Studio and connect to the SQL instance you want to host your CMS. By default SSMS does not show you the Registered Servers… Read more
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive. Let’s just walk through the basic steps.
The first thing you need to do is… Read more
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple thing to do, but some of the options and locations of the cluster resources itself are a little hidden in Windows 2008. Let’s just walk through the basic steps. Read more
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the physical file on the file system.
First we need to know the name and file location of the TempDB database files. When you change the location, make sure to… Read more
First we need to know the name and file location of the MSDB database files. When you change the location, make sure to keep the same name. Technically we don’t need the current physical path, but it’s just a good idea to have it documented in case things go badly. Read more
First we need to know the name and file location of the Model database files. When you change the location, make sure to keep the same name. Technically we don’t need the current physical path, but it’s just a good idea to have it documented in case things go badly.
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the Resource database must reside in the same location as the Master database. You can see their instructions HERE on how to move the Master database.
However, on my cluster I… Read more
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until SQLSaturday in Houston, where John Sterrett (Blog|Twitter) pointed out that you can use an IP address. I think Microsoft prevents this primarily because you already have… Read more
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is mirroring. Mirroring is easy to setup and fast, if implemented properly. It’s a database level solution that allows you to keep a remote copy of your… Read more