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…

SQL Saturday #320 Raleigh in Review

This past Saturday, September 6th, I had the privilege of attending SQL Saturday #320, in Raleigh, NC. It was a great day. The highlight of the event was the #sqlfamily. I had several rewarding conversations with members of our community and the…

Ramping up for SQLSaturday #320 – Raleigh, NC

In just a couple of hours I will be driving down to Raleigh for tomorrow’s SQLSaturday #320. It looks like a great line up with far too many great sessions scheduled to attend them all. Just a few minutes ago…