Today Microsoft Release Service Pack of of SQL Server 2012. My preference is to never run a new version of SQL Server in a production environment until it gets to SP1, so now its time to start looking at …
SQL Server 2012 SP1 Now Available From Microsoft Read more »
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …