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…

ApexSQL’s Response to the Community

The end of last year I did a review on ApexSQL Restore, a tool used to attach SQL Server native backup files to a database instance. Check out the full review here if you missed it. Just last month (Aug 12th),…

Query Cached Execution Plans

Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics…