Monthly Archives: January 2017

Easy Database Space with dbatools

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is one of the most common questions posted on SQLServerCentral by newbies that are trying to manage their instances and ensure … Continue reading

Posted in Blog | Tagged , , , | 7 Comments

Your 2017 Goals

Last week I wrote some predictions for 2017, and plenty of you added your own thoughts. Overall, security is a concern for most people, with little hope things will improve. I certainly hope they do, but like most of you, … Continue reading

Posted in Editorial | Tagged | Comments Off on Your 2017 Goals

Watch the Manual DBA v Automated Deployment Challenge

At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those from development to test, staging, and production environments. Actually, I don’t think we went to production because I didn’t have … Continue reading

Posted in Blog | Tagged , , | 3 Comments

Quick Prompt Tips–Custom Procedure Templates

One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Quick Prompt Tips–Custom Procedure Templates