SSMS

Using the TSQL CHOOSE Function

by SteveStedman
March 21, 2015March 20, 2015
70-461 Training

Here is a short video tutorial that shows how to use the CHOOSE function in T-SQL on SQL Server 2012, SQL Server 2014 or Newer. This… Read More »Using the TSQL CHOOSE Function

Executing a TSQL batch multiple times using GO

by SteveStedman
March 9, 2015
SQL 2014, TSQL

Using the GO commend in TSQL to run a batch of code multiple times is something that I commonly do in demo’s and training’s. What amazes… Read More »Executing a TSQL batch multiple times using GO

A great day at SQL In The City by Redgate

by SteveStedman
September 29, 2013September 29, 2013
SQL Server

Friday I had a great day at Redgate’s SQL In The City presentation by Steve Jones (@way0utwest). There were three sessions presented which are summarized below.… Read More »A great day at SQL In The City by Redgate

SSMS Results In A Separate Tab

by SteveStedman
September 28, 2013September 28, 2013
SSMS

At the end of my SQL Saturday presentation today on Advanced Common Table Expressions, which is about the 12th time I have presented on CTEs,… Read More »SSMS Results In A Separate Tab

Common Table Expressions – Terminating the Previous Statement

by SteveStedman
June 4, 2013June 1, 2013
1 Comment
CTE

Day 4 of Common Table Expression Month (June) at SteveStedman.com, today I will cover the topic of terminating the previous T-SQL statement. These queries will… Read More »Common Table Expressions – Terminating the Previous Statement

Sample Database for Common Table Expressions

by SteveStedman
June 1, 2013May 31, 2013
CTE

As I have presented my Common Table Expressions presentation many times, and as part of writing the Common Table Expressions Book I have created some sample database… Read More »Sample Database for Common Table Expressions

DBCC FreeProcCache

by SteveStedman
May 12, 2013May 11, 2013
2 Comments
DBCC Commands

Being day 12 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREEPROCCACHE. Description: DBCC FREEPROCCACHE is used for purge all… Read More »DBCC FreeProcCache

Installing Sample Databases for SQL Server 2008R2

by SteveStedman
April 17, 2013
SQL 2008

As I work on testing the Database Health Reports project, I have configured several test servers running as virtual machines using Hyper-V. Part of setting… Read More »Installing Sample Databases for SQL Server 2008R2

Select Favorite SQL Server 2012 Articles

by SteveStedman
April 9, 2013March 30, 2013
SQL 2012

The following articles are a collection of my favorite SQL Server related posts over the last 6 months. 3 Steps to Work More Efficiently in… Read More »Select Favorite SQL Server 2012 Articles

What twitter hash tags do you follow for SQL Server?

by SteveStedman
April 4, 2013April 4, 2013
2 Comments
SQL 2012, SQL Saturday, SSMS, SSRS, TSQL

# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are… Read More »What twitter hash tags do you follow for SQL Server?