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… Read More »Corruption Presentation
Related Links
Week 5 – Corruption Challenge
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… Read More »Week 5 – Corruption Challenge
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… Read More »Upcoming Speaking Engagements
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 I was employed as a full time employee at a local company. Now I am a freelance database consultant at my own consulting firm, Stedman Solutions, LLC. The new role gives me more freedom to decide which events I am going to attend, and SQL Saturday Denver is certainly on my list.
Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD
Here is our simple cursor example showing both FAST_FORWARD and FORWARD_ONLY cursors. A FAST_FORWARD cursor in SQL Server is a type of forward-only, read-only cursor… Read More »Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD
T-SQL: A Listing Databases Example Using a Cursor
In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a… Read More »T-SQL: A Listing Databases Example Using a Cursor
SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and… Read More »SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
CTE Data Paging in a Procedure
Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday… Read More »CTE Data Paging in a Procedure
CTE Data Paging
Day 14 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s and how it compares… Read More »CTE Data Paging
Nested CTE’s Gone Wild – The Video
Day 12 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at how to use multiple nested CTEs in a… Read More »Nested CTE’s Gone Wild – The Video