An Awesome Day at SQL Saturday Redmond

SQLSat393RedmondBadge

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, they probably think to themselves “spend all day on a Saturday in technical presentations”, however SQL Saturday is much more than that. The presentations all all great, don’t get me wrong here, but the biggest value that I see is in the people that you get to know, and the things you can learn from the vendors. There were at least 6 people that I know online through Twitter, Fitbit, LinkedIn and other online sites that I had the opportunity to meet in person for the first time this weekend.

SQLSat393FriendsPicture Credit: Thanks Jimmy May (@aspiringgeek)

Read more ›

Posted in Uncategorized Tagged with: , , , ,

TSQL JOIN Types – SQL Saturday

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.

TSQL JOIN Types

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
  • —SEMI JOIN
  • —ANTI SEMI JOIN
  • —CROSS JOIN
  • —FULL OUTER JOIN
  • —FULL OUTER JOIN with exclusion
  • —CROSS APPLY
  • —OUTER APPLY
  • —Multiple combinations of JOINs.

My favorite slide from the presenation:

CanIJoinYou

 

Related Links

Posted in SQL Saturday Tagged with: ,

SQL Saturday Redmond

I am attending and speaking at SQL Saturday Redmond today.

sqlSatRedmond393

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 with exclusion
  • —CROSS APPLY
  • —OUTER APPLY
  • —Multiple combinations of JOINs.

For those of you following the Database Corruption Challenge, I am stepping away from the challenge until at least late Saturday night, or sometime on Sunday. If you are waiting to hear back if your solution was accepted, I probably won’t get to it until Sunday.

 

If you attended this session and would like to give me feedback, please fill out my feedback form.

Related Links

Posted in Uncategorized Tagged with:

A Query Walks Into A Bar

CanIJoinYou

Posted in Uncategorized

Corruption Presentation

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.

Week4Winner8

I hope that everyone learned something that will help them when one day they end up with a corrupt database.

Here are the slides and the sample scripts from the presentation.

CorruptionPresentation5_13_2015.zip

If you attended this session and would like to give me feedback, please fill out my feedback form.

-Steve Stedman

 

Related Links

Posted in Corruption Tagged with: , , , ,

Week 5 – Corruption Challenge

CorruptionChallengeShirt

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. A mismatched version may prevent the database from being restored. The versions or SQL Server supported in this challenge are the following:

  • Microsoft SQL Server 2014 – 12.0.2000.8
  • Microsoft SQL Server 2012 (SP1) – 11.0.3128.0
  • Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1

It took me a fair amount of time to set up the challenge on each of these versions. As you get into the challenge, you may recognize why the exact version match is so important, but for now, trust me, you will need the right version.

One you get your database ready to start recovering, it should look something like this:

SQL14RecoveryPending

On to week 5, it is difficult for me to judge how long this will take, as I was the one who corrupted the database, and I know exactly what is broken.

To get started, check out the details here, and be sure you read all the details on what you need to submit to be considered a winner.

Don’t forget to take a look at the current standing of the scores.

Enjoy Database Corruption Challenge #5.

 

 

Related Links

 

Database Corruption Challenge Sponsored by
StedmanSolutionsRemoteSkilledDBA

Posted in Corruption Tagged with: , , , , , ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: