Mike Hayner

Mike
Hayner

Mike Hayner, chief technical officer at Pacific Northwest Software, has been in the industry for 19 years. He specializes in high performance, large scale applications with a data layer using Microsoft SQL Server.

Articles
Check SQL Server's Statistics Periodically to Prevent Performance Problems 5
SQL Server uses statistics to determine the type of execution plan it’ll use for a query, so it’s a good idea to make sure the statistics are being accurately calculated. A stored procedure makes it easy to do so.

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
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More
Jan 22, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist 1

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...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) ×