How to change the schema of a table

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…

A first timer’s lessons learned at PASS Summit 2014

A first timer’s lessons learned at PASS Summit 2014

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…

Query Central Management Server with PowerShell SMO

Query Central Management Server with PowerShell SMO

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…

Rebooting HRSSUG

Rebooting HRSSUG

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…

Backup testing with PowerShell

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…

Dynamically create table results from non-query

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…

Disconnect Users from Database

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…

Query Object Dependencies

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…

Let your burdens drive you forward

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…