For my last scheduled conference of the year, (I have hopes of doing at least one more in September/October, but that is TBA…based on when that conference is scheduled and if they need someone to talk about SQL!)

This will be my second trip to Raleigh and my second year in a row as well. Like Richmond, Raleigh and the trip to there hold great significance in my life. I grew up in the Winston-Salem area (never took up the habits that are cultivated in that name) and I enjoyed my time there greatly.

If you add to all that, that the host of this event is Kevin Feasel, who if you haven’t followed my long, I greatly admire. Mala Mahadevan is also involved and the whole event last year was great.

My Session

The session for this week goes back to one I did in Raleigh with a lot more time. Here I have an hour, and there two. I did give this last week at a user group in Chattanooga in less than an hour, which really helped. I only really need to insert a few examples where I wasn’t quite sure what to show for window functions. I have some decent slides, but I need to have one for rolling totals, and show a couple of examples.

SQL Techniques You Should Know

Your boss calls you at the end of the day and says, “I need you to create a new TPS report. I will email you the details.” The email arrives seconds later, and as you read the requirements over, you are mildly terrified. Sales figures need to be grouped, aggregated, formatted, and compared to another set of data that had been created previously. 

In this session, I will cover the techniques you need to do to write the T-SQL for this and any other queries you need. We will cover various techniques to filter, transform, aggregate, and generally manipulate data quickly and correctly. By the end of the session, you will leave with techniques to apply immediately so all your reports will be correct and fast and the TPS report users will speak your name using superlatives and not expletives.

See you there?

I hope so, it is a great place to visit and some nice people to hang out with.