Notes from SQL Server Classes
Well SQL Server in Redmond at the Microsoft Campus was a bust this year due to the snow storm. Seattle and the east side were hit pretty hard with snow, and Microsoft closed their campus. The snow this year broke the last recent record in 1991 where the greater Seattle area got hit with a ton of snow. I remember …
On February 9, 2019, I have the privileged of presenting at SQL Saturday in Redmond Washington, at the Microsoft campus. SQL Saturday is a free SQL Server event, so if you want to spend a day at Microsoft learning about SQL Server then this is for you. TSQL User Defined Functions – Taboo or not? Track: Enterprise Database Administration & …
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. This event has just been announced, and you can sign up for the pre-con session now. I will be presenting with …
Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters Read more »
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 the 70-461 exam certification. Full Length Free SQL Server Training Videos Some of these are full length at around an …
Here are the slides for my presentation at SQL Saturday, at Las Vegas today. Download the presentation here CorruptionPresentation.pdf
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 & Deployment You are working along month after month with no problems in your database. Suddenly someone reports that their …
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? This course is intended as an Introduction to SQL Server for business persons or other professionals who have never used …
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 the example. First some background when using the delete statement with a CTE you can’t delete if the query inside …
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 Hierarchical Recursive Data Manipulating Data Common Use Cases CTE Performance Considerations Classic Recursive Algorithms The sample code and slides are …
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 going to be fun. Here is the session abstract. You have been introduced to Common Table Expression, you understand …
Advanced Common Table Expressions – 24 Hours of PASS Read more »