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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×