Monthly Archives: April 2012

3 Sessions submitted to SQL Saturday in Salt Lake City

I am planning on visiting Salt Lake City for SQL Saturday in October. Exploring the TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server Using SSRS reports to analyze SQL Server health

Posted in SQL Saturday Tagged with:

Using a CTE in a Function to Split Up a Query String

The question came up as to how do I parse a query string using TSQL.  So here you go, using a common table expression, and basing this on a similar function to what I put together yesterday for split. which

Posted in CTE Tagged with: , , , , ,

Using a CTE to Split a String Into Rows

One of the common questions that comes up in my CTE class/presentation asks can you use the CTE inside of a function or stored procedure. The answer is yes, but today I came across another question, how can I split

Posted in CTE Tagged with: , , ,

Finished my Draft Copy of my Chapter for SQL Tribal Knowledge book

I finished my draft copy of my chapter titled “Minimal Downtime and Minimal Risk SQL Server Upgrades” for the SQL Tribal Knowledge book. I am sure there will be some editing and cleanup to do, but for now I am

Posted in TribalSQL

TSQL 2012 – OFFSET and FETCH

Its about time, MySQL has had a feature LIMIT which is similar to the  usage of OFFSET and FETCH for years.  Now in SQL Server 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve

Posted in CTE, SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

My Top 10 TSQL Enhancements in SQL Server 2012

So far after playing around with SQL Server 2012 there are many new features to SQL.  Overall I think my favorites are in the Analytic Functions category.  Here is my breakdown of the top 10 transact SQL enhancements to SQL

Posted in SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

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

Common Table Expressions Book

Paperback:

Kindle: