x002548's Blog

Not Just a Number - Brett Kaiser
posts - 89, comments - 586, trackbacks - 39

December 2004 Blog Posts

Real World SQL Server Disaster Recovery

Just got an email from http://www.sql-server-performance.com/default.asp And they had a great link to an article from Brian Knight that discusses Disaster recovery and is “A Survival Toolkit for the DBA“.  It even comes with a bunch of scripts already written.  I always liked reading Brian's stuff, and he continues his engaging style in this document. AND, I did not know that Brian was a co-founder of http://www.sqlservercentral.com/ Here's the link to the Article. http://www.lumigent.com/go/sd19/  

posted @ Tuesday, December 21, 2004 12:36 PM | Feedback (3) | Filed Under [ SQL Server ]

Weekend and Holidaze

Wow...it's been 2 months... It seems there's a common question discussiong how to eliminate holidays (and weekends) from date ranges.  And since I'm sick of doing a search to find it, I'd thought I'd post it.  Also, people ask about daylight savings time.  This is the same type of thing, but since it's regional, there the added twist of having to know where you are.  Anyway, here's the code:   CREATE TABLE WeekEndsAndHolidays (DayOfWeekDate datetime, DayName char(3))GOSET NOCOUNT ONDECLARE @FirstSat datetime, @x intSELECT @FirstSat = '1/3/2004', @x = 1 --Add WeekEndsWHILE @x < 52BEGIN INSERT INTO WeekEndsAndHolidays(DayOfWeekDate, DayName) SELECT DATEADD(ww,@x,@FirstSat),   'SAT' UNION ALL SELECT DATEADD(ww,@x,@FirstSat+1), 'SUN' SELECT...

posted @ Monday, December 20, 2004 1:17 PM | Feedback (0) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET