Yesterday was SQL Saturday Redmond. It was a great day, I learned lots, met some great new people, and had a chance to catch up with some old friends. When most people hear about SQL Saturday for the first time, …
Today I am presenting at SQL Saturday in Redmond Wa. My presentation is on SQL JOIN types. If you have seen my JOIN Types Poster, you should check it out. Download the slides and sample TSQL code: JOINs.zip Topics Covered …
I am attending and speaking at SQL Saturday Redmond today. My presentation is at 2:45pm and on SQL JOIN Types, and the following topics will be covered: Basic SELECT INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN LEFT OUTER JOIN …
Today I had the opportunity to present When Corruption Strikes to the PASS DBA Virtual Chapter Meeting. This was a lot of fun to be able to recap the previous 4 weeks of the Database Corruption Challenge, and share some of the …
Welcome to the Week 5 Corruption Challenge. If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look. We are currently at the 5 week midpoint of …
There is a lot happening right now, so I thought I would put together a brief overview of upcoming speaking engagements. May 13th – When Corruption Strikes (PASS DBA Virtual Chapter Meeting) May 16th – Exploring SQL Server Join Types – …
On Wednesday May 13th I will be presenting to the PASS DBA Virtual Chapter Meeting, at Noon Mountain time (convert to your time zone). The session is titled “When Database Corruption Strikes“, and the event has been sponsored by Dell Software …
When Corruption Strikes – Online Presentation Wed May 13th Read more »
Database Corruption Challenge #5 is coming soon. Those who subscribe to my newsletter will know the exact date and time of the next Database Corruption Challenge. Lets take a look back at the winners from the previous challenges. Week 1 …
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 on any production …
Corruption Challenge 4 – Second Alternate Solution. Read more »