What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I attended was Accelerating your Development Workflow presentation by Ian Davis. What a great presentation, it touched …
I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward to the day. I am looking forward to attending the Accelerating your Development Workflow presentation …
WOW, what a great day at SQL Saturday 108 in Redmond. I started out with a keynote presentation from Buck Woody. Then I delivered my presentation on Common Table Expressions. Which I think went well. There were some great questions …
I had a great time presenting at SQL Saturday 108 in Redmond. Below is the presentation and sample code from the presentation. CTE_Redmond.zip The thing that I love about a presentation like this is the people who ask questions at …
I just checked the schedule and one of the sessions that I submitted for SQL Saturday 108 in Redmond WA on February 25th has been accepted. I will be presenting Unleashing Common Table Expressions in SQL Server. If you are going to …
Session Accepted For SQL Saturday 108 in Redmond Read more »
Finding Serializable QueriesDecember 3, 2019 Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I needed to find queries that were being run against a SQL Server that … Latest …
We will be visiting SQL Saturday in Victoria Canada on March 16th. After the last SQL Saturday that I tried to attend was snowed out in Redmond a few weeks ago, I am ready for Victoria. I will be presenting …
One of my favorite queries this week is the following query that creates a text based bar chart to quickly help visualize the VLF files on any database log file. In the last month I have given the “TempDB Do …
Today I am presenting my “TempDB – Do This and Don’t Do That” session at SQL Saturday Redmond. Here is the download of the presentation and samples. StedmanTempDbPresentation.zip Some of the sample code from the session: I hope …
Friday morning at 8:00am at PASS Summit 15 in Seattle, I will be presenting my Advanced Common Table Expressions and Recursive Query Technique session. Advanced Common Table Expressions Here is the abstract: You might have been introduced to Common Table Expressions …
Advanced Common Table Expressions and Recursive Query Technique Read more »