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
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and basing this on a similar function to what I put together yesterday for split. which produces this output. A quick and easy way to parse a query string in TSQL using a CTE.
One of the common questions that comes up in my CTE class/presentation asks can you use the CTE inside of a function or stored procedure. The answer is yes, but today I came across another question, how can I split a string (varchar) into rows. I did some searching but didn’t find quite what I was looking for. I did …
I finished my draft copy of my chapter titled “Minimal Downtime and Minimal Risk SQL Server Upgrades” for the SQL Tribal Knowledge book. I am sure there will be some editing and cleanup to do, but for now I am calling the draft copy complete. What a great experience getting this chapter together. I hope that the other writers had …
Finished my Draft Copy of my Chapter for SQL Tribal Knowledge book 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 …