Patch Management Strategies for SQL Server Deployments
We all have to deal with applying some sort of update to Windows, SQL Server, and/or hardware. Keeping things up to date is crucial for supportability, not to mention other things like security, performance, and stability. Since patching often involves downtime, you need to be careful not only what you apply to avoid problems, but also find ways to minimize the impact to the business and end users. This session will cover topics such as how to approach patching including what changes you should and should not consume, features that may help you automate or script patching, and developing your own long term patch management strategy for SQL Server deployments.
SQLHA founder, Microsoft MVP, and SQL Server mission critical expert Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992 since interning at Sybase in college. Based in the Boston, MA area, he travels all over the world to work with and train clients. Allan is currently working on the book Mission Critical SQL Server.