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 by Dan Sawyer
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.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups 1

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws 1

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×