I just found out that two of the sessions that I proposed for SQL Saturday #166 in Olympia next month have been accepted.  These presentations are: Exploring TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server These are both presentations that I have given before and have had lots of fun with.   This should be a good …

2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month. Read more »

In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here are the before and after queries to determine the plan cache size in SQL Server 2012, and prior to SQL Server 2012. SQL 2012 Plan Cache Size Pre-SQL 2012 Plan Cache Size For more details …

TSQL to Determine Plan Cache Size Read more »

Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day. Part of that improvement is to avoid switching to the mouse when you don’t have to.  Here are some shortcut keys that I find very useful in SQL Server Management Studio, some of which I just discovered recently. Window + …

Whats your favorite SSMS time saving hotkey? Read more »

In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options.  Choose is a function that returns the item at a specific index. Syntax: —CHOOSE(index, val_1, val_2, val_3, …) —If the index is greater than the number of values or less than 1 it returns NULL —Easier than using a …

TSQL 2012 CHOOSE Function Read more »

SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to.  I have submitted 2 sessions for this event.   What’s New in TSQL 2012 By November, this with be the fourth or fifth time presenting this one.  Its going to be a lot of fun working with the new features …

Sessions Submitted for SQL Saturday – Olympia Read more »

Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time that I will be presenting this one.  Its going to be a lot of fun working with the new features in TSQL 2012. Unleashing Common Table Expressions in SQL Server This will be about the …

Sessions for Code Camp in 2 weeks Read more »

I learned today that several of the sessions that I pitched for Code Camp 2012 have been accepted. Code Camp will be on Saturday June 16th 2012 in Redmond WA.   I am not sure why the call it Seattle Code Camp if it is going to be in Redmond. Looking forward to it.   Today I am tuning up …

Sessions Accepted for Seattle Code Camp 2012 Read more »

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 data paging server side in TSQL.  Thing of a page like your typical search results where you are shown the …

TSQL 2012 – OFFSET and FETCH Read more »

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 Server 2012. 10.  New SEQUENCE object 9.  CHOOSE function 8.  Analytics – Analytic Functions – PERCENT_RANK 7.  Analytics PERCENTILE_DISC and PERCENTILE_CONT 6. …

My Top 10 TSQL Enhancements in SQL Server 2012 Read more »