Blog Archives

Notes from SQL Server Classes

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: ,

Upcoming Speaking Engagements

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 –

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

SQL Saturday Redmond

Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks. SQL Saturday

Posted in SQL Saturday Tagged with: , , , ,

SQL Saturday Denver

This year the Denver SQL Saturday is being held on September 19th. I believe it has been 2 years since I attended SQL Saturday in Denver.  Since the last time I was at SQL Saturday Denver, my employment has changed. Previously

Posted in SQL Saturday Tagged with: , ,

Using Cursors, followed by Using String Functions

On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors,

Posted in Classes, Query Certification Tagged with: , , ,

SQL Server Cursors Good or Bad

Next week as part of the free SQL Query training that Aaron Buma and I provide, the topic I will be presenting is cursors. How to use them, what they are, everything you ever wanted to know. My concern in

Posted in Query Certification Tagged with: ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

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