Background When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over…
The other day I set out to performance tune a database deployment. The company was getting ready to implement almost a year’s worth of database schema drift where major restructuring had occurred. One of the first things that I noticed…
Me, as a #sqlfirsttimer Just one year ago I didn’t know what the PASS Summit was. What came after has been a series of serendipitous events. I went to Charlotte, NC to Red-Gate’s SQL in the City event because it was within driving…
All production or operational DBAs need to maintain a server / instance list. SQL Server’s Central Management Server (CMS) is a great means of managing that list with auxiliary benefits such as group queries, a central location for managing policies and SQL…
This week I’m excited to announce the reboot of the Hampton Roads SQL Server User Group (HRSSUG). We will be coming back online this Novemeber, holding meetings every third Wednesday of the month. Check out our announcement below and be…
This week I released a two part blog series on SQLShack.com. The series covers automated testing for your backup files and reporting on the results. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your…
Have you ever executed a command with a result set but you didn’t know the exact schema being returned? Have you ever wanted to create a temporary table from a query but don’t want to look up all of the…
There are some operations that we execute in SQL Server which need exclusive access to the database. For everyone who has ever attempted this, I’m sure they’ve seen an error like this at least once. There are a couple of ways to…
SQL Server Management Studio has a decent interface for viewing object dependencies, check out TechNet for those procedures. But, we all know the value of being able to run queries for the information that we need. There are two methods…
A few nights ago my wife and I were talking over dinner. We were discussing her co-worker’s behaviors regarding stress and deadlines. For the sake of this post let us call this person Jill. Jill is responsible for a work…