SQL Server 2012 SP1 Now Available From Microsoft
Today Microsoft Release Service Pack of of SQL Server 2012. My preference is to never run a new version of SQL Server in a… Read More »SQL Server 2012 SP1 Now Available From Microsoft
SQL 2012
2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month.
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… Read More »2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month.
TSQL to Determine Plan Cache Size
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… Read More »TSQL to Determine Plan Cache Size
Whats your favorite SSMS time saving hotkey?
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… Read More »Whats your favorite SSMS time saving hotkey?
TSQL 2012 CHOOSE Function
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… Read More »TSQL 2012 CHOOSE Function
Sessions Submitted for SQL Saturday – Olympia
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… Read More »Sessions Submitted for SQL Saturday – Olympia
Sessions for Code Camp in 2 weeks
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… Read More »Sessions for Code Camp in 2 weeks
Sessions Accepted for Seattle Code Camp 2012
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… Read More »Sessions Accepted for Seattle Code Camp 2012
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… Read More »TSQL 2012 – OFFSET and FETCH
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… Read More »My Top 10 TSQL Enhancements in SQL Server 2012