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…

Configuring PowerShell Remoting with Group Policy

Last week I promised a post on enabling PowerShell Remoting when we discussed automating service account password updates. So, let’s break down the two methods. First we have the manual method. For this, all you need to do is remote…

Automate Service Account Password Changes with Powershell

I am a believer that regular rotation of passwords is an important security measure. I worked at an organization that, when they were small, would use the SQL Server database engine service account to run SQL Agent jobs and other…

Scripting Objects with PowerShell

The ability to script out the definitions of objects is valuable to any DBA. Most of us are intimately familiar with SQL Server Management Studio’s capabilities in this regard. Simply right-click on your object and navigate to the “Script object…

You must just have the touch

Over the years, I’ve found my professional maturity to be a growing entity. One piece of evidence of this is how I react to being the most knowledgeable person in the room. Now, understand I’m not being arrogant, I mean, “the room,” literally. I…

Windows Server 2012 R2 Product Key Failure

Today I had an odd experience with installing Windows Server 2012 R2. I downloaded the ISO from the MSDN subscriber’s downloads. Then I got the product key from the same line item on the download page, this makes me assume…