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 Basic SELECT INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN LEFT OUTER JOIN with exclusion RIGHT OUTER JOIN with exclusion …
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 with exclusion RIGHT OUTER JOIN with exclusion SEMI JOIN ANTI SEMI JOIN CROSS JOIN FULL OUTER JOIN FULL 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 ways to fix the corrupt database. I hope that everyone learned something that will help them when one day they …
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 the 10 week challenge. This challenge requires that you use the exact matching version of SQL Server for the challenge. …
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 – INNER, OUTER, and much more… (SQL Saturday Redmond) June 9th – When Corruption Strikes 2 (HADR Virtual Pass Chapter) June …
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 Abstract: You are working along month after month with no problems in your database. Suddenly someone reports that their query …
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 – Brent Ozar Week 2 – Rob Farley Week 3 – Randolph West Week 4 – Randolph West If you …
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 database. It may invalidate your ability to get support from Microsoft on issues that arise with that database going forward. …
Corruption Challenge 4 – Second Alternate Solution. Read more »
Today is the release of Database Health Monitor Beta 10.1. If you haven’t see the Database Health Monitor before, its a free application that I have been building over last 4 years. It has been a while since the last release, so I thought I would just walk through and show a few of the features. One thing that changed right …
Database Health Monitor -Beta Version 10.1 Released Today Read more »