Blog Archives

SQL Sunday Word Scramble

SQL Server – TSQL Analytics Word Search   Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE LAST_VALUE PERCENT_RANK PERCENTILE_DISC PERCENTILE_CONT CUME_DIST PARTITION ROWS PRECEDING FOLLOWING UNBOUNDED   Download the Printable PDF

Posted in Analytic TSQL, SQL Sunday Tagged with: , , , , , , ,

Downloads for this weeks SQL Training

As posted earlier. This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on myYouTube Channel. Aaron

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

This Weeks SQL Server Queries Training

This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on my YouTube Channel. Aaron Buma will

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

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 diagonal. ROWS  RANGE  PRECEDING  FOLLOWING  UNBOUNDED  IIF  CHOOSE  OFFSET  FETCH  FORMAT  CONCAT  SEQUENCE  PARSE  TRYPARSE 

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

Happy Birthday SQL Server 2012

It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary. For instance: and another anniversary query (which doesn’t actually run): 1 year out since SQL

Posted in SQL 2012, TSQL, 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: