SELECT *
FROM Posts
WHERE Tags IN ('Disaster Recovery')

oct
28
2015

Daylight Savings end affects not only you, but your SQL Server too

The last weekend of October is a common date for the daylight savings (or summer time) to get to its end in the north hemisphere. According to Wikipedia: Daylight saving time (DST) or…

Continue Reading »

oct
10
2015

Steve Stedman’s DBCC Challenge, Week-7 Winning Solution

*First published @ Steve Stedman’s blog (2015/06/07) The seventh week of ten in the Database Corruption Challenge went well. There were a few new participants, and many of those who have competed week over week. The first to submit a correct answer this week was Raul…

Continue Reading »

oct
10
2015

Steve Stedman’s DBCC Challenge, Week-6 Winning Solution

*First published @ Steve Stedman’s blog (2015/05/27) If you are looking for more info on the corrupt database with Week 6 of the Database Corruption Challenge, you can take a look at the original post. Week 6 was won by Raul Gonzalez who submitted his…

Continue Reading »

oct
10
2015

Steve Stedman’s DBCC Challenge, Week-4 Second Alternate Solution

*First published @ Steve Stedman’s blog (2015/05/06) The following is a solution to Corruption Challenge #4 that uses DBCC WritePage to fix the corruption.  Before proceeding, be sure to read this warning. WARNING: DBCC WritePage is a dangerous command, that should never be used…

Continue Reading »