Dan Sawyer

Dan
Sawyer

Dan Sawyer is a QA consultant and trainer who helps organizations test their databases and improve their development and administration practices. Dan is based in Tucson, AZ.

Articles
Automate Your Security Audits 1
Start with this stored procedure for tracking 15 commonly monitored checkpoints--and build on it by adding your own checks.
Build Your Own Automated Security Systems 1
Discover the keys to effective database-security testing: a well–thought-out testing plan, consistent reporting and bug-checking, and the use of scripts to automate testing tasks.
Pep Up T-SQL Procedure Testing 2
Wouldn't it be great to cut the time it takes to unit test T-SQL stored procedures? Well, now you can! You can automate your testing by using nothing more than Query Analyzer and a little T-SQL code. Here's the solution in four easy-to-implement parts.
Integration Testing
Piece by piece, then all together, test your application code by following this simple plan.
Unit-Test Your Stored Procedures 6
You're the one on the front lines; who better to drill your code to peak performance? Here's why and how to put stored procedures through their paces.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
detetecitve dressed in black looking at data
Sep 24, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 7: Detecting Primary Replica Ownership

In my mind, there are two logical ways that you might want to have your code check to see if the Primary Replica of a given AG database is currently hosted on a particular server or not...More
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×