Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

Energy Policy Act of 2005 Implications on SQL Server

By: Chad Boyd | Read Comments | Print Chad is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server. Related Tips: More

Problem
In the United States, the Energy Policy Act of 2005 (http://webexhibits.org/daylightsaving/b.html) was approved by President Bush on August 8, 2005. Due to this legislation, the day light savings start and end times in the United States will change in the spring of 2007? As such, what patches will I need to apply to my SQL Servers? Do I need to apply different patches for SQL Server 2000 versus 2005?

Solution
According to Microsoft, Windows will need to be patched in order to support the upcoming day light savings change. SQL Server will not need to be updated directly, because SQL Server receives its date\time information directly from Windows. Nevertheless, time is of the essence because this patch will impact SQL Server and your application, so be sure to work with your team to push out this change before the pending March 2007 date. For more information on the patch, reference http://support.microsoft.com/?kbid=928388.

With some applications, the date\time stamp for the application is very critical. So thorough testing is needed to ensure the application will properly support the time change. From a testing perspective, consider the following testing practices:

• Validate that all of your date related code is originating from SQL Server functions such as GETDATE() or GETUTCDATE() as opposed to multiple sources in your application such as from a client machine or other servers
• Build a control test for the application before the patch is applied to validate the critical date\time usage
• Apply the patch to begin the post patch validation
• Test your application before, during and after the day light savings change
• Validate that the date related data is correct after the patch is applied in your development and test environments prior to pushing out the patch to the production environment

Next Steps

• Since the day light savings time change is inevitable, research this patch and incorporate it into your current patch management process prior to March 2007
• Be sure to test this change as you would with any other Windows or application change
• Be sure to start with development environment and then promote the code to the test environment and then promote to the production environment once the testing is accurately completed
• Here is the link the patch information: http://support.microsoft.com/?kbid=928388
• Special thanks to Chad Boyd from the MSSQLTips community for this tip

Related Tips: More | Become a paid author

Last Update: 1/23/2007

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen." The SQL Developer Bundle - 10 essential tools every database developer needs. Download a free trial. Real solutions for real problems. Get in-depth knowledge of all SQL Server features. Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Are you waiting on SQL Server? Learn about these DMV's.