Category: Classes

Notes from SQL Server Classes

Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters

On March 18th I will be attending SQL Saturday 610 in Richmond Virginia and the day before I will be presenting a pre conference session covering half a day on Database Corruption and half a day on Disaster Recovery Planning.

Posted in Corruption, SQL Saturday Tagged with: , , , ,

Free SQL Server Training Videos

Over the last year, I have published many videos to YouTube with Free SQL Server Training. You can find these on my YouTube Channel at the following link: https://www.youtube.com/steveStedman   Most of the focus has been around training people for

Posted in 70-461 Training, Classes Tagged with: , , ,

SQL Saturday – When corruption strikes – downloads

Here are the slides for my presentation at SQL Saturday, at Las Vegas today. Download the presentation here CorruptionPresentation.pdf    

Posted in SQL Saturday Tagged with:

Presenting at SQL Saturday Las Vegas

This Saturday, September 12th, 2015 I will be presenting at SQL Saturday Las Vegas. My presentation is on Database Corruption, here are the details. When Database Corruption Strikes – Will you be ready? Duration: 60 minutes Track: Enterprise Database Administration

Posted in Corruption, SQL Saturday Tagged with: , , , ,

Introduction to SQL Server Class

From September 15th 2015 to October 1st 2015 on Tuesday and Thursday evenings I will be teaching a Introduction to SQL Server class. Interested you can sign up here:  Class Info and Signup Introduction to SQL Server – Why take this course?

Posted in Classes Tagged with: ,

Deleting from a CTE with an EXISTS statement

During my 24 Hours of Pass presentation on Advanced CTE’s today I was asked the question about deleting from a CTE when it uses an EXISTS statement that queries another table. I figured I would create quick blog post to show

Posted in CTE Tagged with: , , ,

24 Hours of PASS – Advanced CTE Presenation

Today I am presenting on Advanced Common Table Expressions as part of the 24 Hours of PASS conference. It is being webcast so check it out if you can. The outline for the presentation will be the following: Recursive Queries

Posted in CTE Tagged with: , , , , , , ,

Advanced Common Table Expressions – 24 Hours of PASS

On Wednesday June 24th at 6:00pm pacific time or( 25 Jun 2015 01:00 GMT ) will be speaking at the 24HOP (24 Hours of Pass) conference which is broadcast online. I will be presenting on Advanced Common Table Expressions, and it is

Posted in CTE, CTE Book Tagged with: , , , , , ,

A Rave from SQL Saturday Redmond

Just sharing a rave from a SQL Saturday attendee this month. I had a lot of fun with this presentation.   He was referring to the SQL JOIN Types presentation. It is just nice to get feedback like that once

Posted in SQL Saturday 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. Download the slides and sample TSQL code: JOINs.zip Topics Covered

Posted in SQL Saturday Tagged with: ,