If you take log backups and you changed from summer time the last Sunday of October, your backup log chain might be broken The last weekend of October is a common date for…
Divide and Conquer Date Search Hack
Divide and Conquer Date Search Hack (because binary search sounds boring) Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have…
Steve Stedman’s DBCC Challenge, Week-7 Winning Solution
Week 7 of the Database Corruption Challenge (DBCC), winning solution by @SQLDoubleG *First published @ Steve Stedman’s blog (2015/06/07) The seventh week of ten in the Database Corruption Challenge went well. There were a…
Steve Stedman’s DBCC Challenge, Week-6 Winning Solution
Week 6 of the Database Corruption Challenge (DBCC), winning solution by @SQLDoubleG *First published @ Steve Stedman’s blog (2015/05/27) If you are looking for more info on the corrupt database with Week 6…
Steve Stedman’s DBCC Challenge, Week-4 Second Alternate Solution
Week 4 of the Database Corruption Challenge (DBCC), alternate solution by @SQLDoubleG *First published @ Steve Stedman’s blog (2015/05/06) The following is a solution to Corruption Challenge #4 that uses DBCC WritePage to…
Day 1 @ AdventureWorks, some basics about SELECT, JOINS and more
Day 1 of exercises using the AdventureWorks sample database, the SELECT statement The first day of this journey we’ll work on the most basic statement I can think of, the SELECT statement. Exercises are…
Day 0 @ AdventureWorks, setting up AdventureWorks sample database
Guide to explain how get AdventureWorks sample database and install it in your environment I wasn’t planning writing this post, because there are tons of resources available on the internet, but since I…
Database ownership and TRUSTWORTHY
Revisiting the old topic of database ownership to highlight how can compromise the security of the whole instance *First Published @ sqlservercentral.com (2015/01/29) Recently I have come across to an old topic relating to…
Writing my first SQL Post
See how I configured my blog to display TSQL code like SSMS Before I start writing my first SQL Server post, I had to get one of those plugins where you can see…
Welcome to your new office!
First post of a comprehensive series of exercises based on the sample database AdventureWorks Hi there! Welcome on board, you’re the candidate we have chosen to cover the junior DBA opening. Does it…