I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward to the day. I am looking forward to attending the Accelerating your Development Workflow presentation by Ian Davis. Here is what I am presenting… What’s New in TSQL 2012 This is the first time that …
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 + …
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 …
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 …
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 …
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 …
I just signed up as a SQL Saturday sponsor. Here is the logo that I put together to use for the sponsorship link. Good thing my SQL skills are much stronger than my Photoshop skills.
Today I started the day early with a great presentation for the SQL Lunch UK group on Common Table Expressions. For those who attended the presentation here is the Zip file with the Powerpoint and the SQL code from the demo. Feel free to download it and learn from it. CTE_SQL_LUNCH_UK_May_2012.zip Here are a few links to some of …
On May 8th at 4:30am (Lunchtime UK) I will be presenting my Unleashing Common Table Expressions in an online webcast type presentation. I am looking forward to it. I have tuned it up a bit since the last time I presented it at SQL Saturday in Vancouver Canada.
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