This weeks tip:
The World is Flat – I just started reading that book this weekend, I know I’m a bit behind the times, but it’s still interesting. If you don’t know the book – I would suggest reading it as it contains a lot of topics on outsourcing and specialized work – such as SQL development, hosting, etc. This hits real close to home for me these days.
What does this have to do with the TSQL Tip o’ the Week? Well if you are working on systems that are used in different time zones, consider using GETUTCDATE as the standard for recording the date/time, that way irreguardlessly regardless of what time zone you are in you will always be comparing apples to apples.
Here is a good post from the intraweb showing an example of where this is very helpful:
- From SQL Server ToolKit a good explanation of how it helps: GETUTCDATE vs. GETDATE with timezones and daylight savings
Previous Tips O’ the Week
- TSQL Tip O’ the Week – 7/12/11 – Wildcards
- TSQL Tip O’ the Week – 7/5/11 – Keyboard Shortcuts
- TSQL Tip O’ the Week – 6/28/11 – SP_HELPTEXT
- TSQL Tip O’ the Week – 6/21/11 – Copy a Table Structure
- TSQL Tip O’ the Week – 6/14/11 – The Empty GUID
- TSQL Tip O’ the Week – 6/6/11 – Declare and Assign Variables