How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

I knew about this, but didn’t know it was public!


Source: http://support.microsoft.com/kb//931975

 … In SQL Server 2005 and in SQL Server 2000, the SQL Server database engine uses the following two forms of timer to generate time information:

  • High-resolution timer
  • Low-resolution timer

In the high-resolution timer, the timer resolution is based on the Read Time-Stamp Counter (RDTSC) instruction of the CPU. In the low-resolution timer, the timer resolution is based on the GetTickCount function in the Microsoft Windows API.

… When you use Transact-SQL statements to perform time calculations that are based on system-provided date and time functions, you must carefully investigate the statements. Specifically, if you have written DST times in hard code in the application logic, the DateDiff and DateAdd system functions are not DST aware.

 

Technorati tags: , ,

Are you Ready For Microsoft® Exchange Server 2007

Quest have a number of half day seminars coming up. 


Check it out: http://www.quest.com/events/listdetails.aspx?ContentID=4907&site=&prod=&technology=&prodfamily=&loc

Is your organisation looking for the right solution to migrate to Microsoft® Exchange Server 2007 —and the tools to effectively manage this new Exchange environment?

Join our experts Joe Baguley – Quest Software’s Global Product Director and Caroline Lawson – Senior Consultant at one of our half day Seminars (09:00 – 13:00)

21st February, Guinness Store House, Dublin
23rd February, Stock Exchange, London
27th February, Hilton Hotel, Leeds
1st March, Microsoft Office, Edinburgh

*27th March, Microsoft TVP, Reading, NEW DATE ADDED due to demand

The seminar will discuss and include:

– Assessing your Exchange 2007 readiness
– Options for migrating to Microsoft® Exchange Server 2007 (from 5.5, 2000, 2003, Notes or Groupwise)
– Managing your new Exchange 2007 environment
– Open lunch/questions

Quest Software has migrated more than 10 million mailboxes to Exchange and is committed to securely and reliably migrating users to the new Exchange 2007 platform. Quest’s expertise in migration and management, combined with Exchange 2007, ensure that your organisation will have a stable, secure and manageable e-mail platform.

Quest’s migration and management solutions cover the entire messaging lifecycle—from planning and analysis, through migration and ongoing management. These solutions can help your organisation control costs, decrease complexity and reduce the risk of compliance in its corporate messaging infrastructure.

 

Are you Ready For Microsoft® Exchange Server 2007

Quest have a number of half day seminars coming up. 


Check it out: http://www.quest.com/events/listdetails.aspx?ContentID=4907&site=&prod=&technology=&prodfamily=&loc

Is your organisation looking for the right solution to migrate to Microsoft® Exchange Server 2007 —and the tools to effectively manage this new Exchange environment?

Join our experts Joe Baguley – Quest Software’s Global Product Director and Caroline Lawson – Senior Consultant at one of our half day Seminars (09:00 – 13:00)

21st February, Guinness Store House, Dublin
23rd February, Stock Exchange, London
27th February, Hilton Hotel, Leeds
1st March, Microsoft Office, Edinburgh

*27th March, Microsoft TVP, Reading, NEW DATE ADDED due to demand

The seminar will discuss and include:

– Assessing your Exchange 2007 readiness
– Options for migrating to Microsoft® Exchange Server 2007 (from 5.5, 2000, 2003, Notes or Groupwise)
– Managing your new Exchange 2007 environment
– Open lunch/questions

Quest Software has migrated more than 10 million mailboxes to Exchange and is committed to securely and reliably migrating users to the new Exchange 2007 platform. Quest’s expertise in migration and management, combined with Exchange 2007, ensure that your organisation will have a stable, secure and manageable e-mail platform.

Quest’s migration and management solutions cover the entire messaging lifecycle—from planning and analysis, through migration and ongoing management. These solutions can help your organisation control costs, decrease complexity and reduce the risk of compliance in its corporate messaging infrastructure.

 

Exchange Archiving, Compliance and Journaling

Been looking for some stuff on this and came across a few links I wanted to share.

First of all my buddy Doug posted a blog up on MsExchangeTeam (well done m8) and that gives you the reasons why you should (http://msexchangeteam.com/archive/2006/10/18/429216.aspx)

He also links out to the Exchange Partners page (http://www.microsoft.com/exchange/partners/default.mspx).  If you drill down under compliance (http://www.microsoft.com/exchange/partners/2007/compliance.mspx) you get a list of potential products that you can use (didn’t know about this!).

This is quite a good PPT from Kieran McCorry (http://h71028.www7.hp.com/enterprise/downloads/Journaling_Archiving_and_Regulatory_Compliance_with_Exchange_2003.ppt)

What also seems interesting is that instead of having your servers, you can actually outsource this another company.  Check out Microsoft Exchange Hosted Archive (http://www.microsoft.com/exchange/services/archive.mspx)

These would be good article, but you have to register and subscribe to see the whole thing :-(
An Exchange 2003 Journaling Primer: http://www.windowsitpro.com/MicrosoftExchangeOutlook/Article/ArticleID/45348/45348.html
Develop an Exchange Compliance StrategyDevelop an Exchange Compliance Strategy: http://www.windowsitpro.com/Windows/Articles/ArticleID/94390/pg/3/3.html

As they say, every day is a school day!

Support WebCast: The impact of daylight saving time within the Enterprise

Another webcast, which I suppose is good! I looks like the it will focus on the impact of DST on Exchange and Outlook! as it’s by Elizabeth & Aime


Source: http://msevents.microsoft.com/cui/webcasteventdetails.aspx?culture=en-US&eventid=1032327824

This Support WebCast will help you understand how products within the Enterprise are approaching this transition.

Elizabeth Scott is the product unit manager in the Exchange Sustained Engineering team.

Aime Mitchell is the principal program manager in the Outlook team.

 

Microsoft Cluster Configuration Validation Wizard

Found this on the download site today … looks interesting.  Source: http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9eb3a7-fb91-4691-9c16-553604265c31&DisplayLang=en

The Microsoft Cluster Configuration Validation Wizard, a.k.a. “ClusPrep”, is a validation tool that does a complete system inventory and runs focused tests on servers that are configured and ready for Microsoft Server Cluster installation (in other words, before the servers are a cluster). ClusPrep will also run the inventory and many of these same tests after clustering is installed, however, because of their potentially disruptive nature, most storage tests are not run if the servers are already a cluster.

ClusPrep will validate that your system is configured properly by taking inventory of your system configuration and highlighting discrepancies in service pack levels, driver versions, etc.; evaluating and testing your network and storage configuration.
If the results of your ClusPrep execution do not show errors (viewable in detail from the XML report) then you can have a high level of confidence that your subsequent cluster installation and/or operation will be successful.

ClusPrep is a “client/server” tool: you install it on one machine (must be installed on a 32-bit architecture machine), and it drives tests on a collection of server machines (can be any architecture). All drivers and test agents are automatically installed on the servers as part of ClusPrep operation. In other words, the only install you do is on the machine from which you initiate the testing.

 

Technorati tags: , ,