Building Your T-SQL Toolkit: Window Function Fundamentals

Hey folks,

My Wednesday morning PASS Summit session on Window Function Fundamentals was recorded for PASStv. Check out the replay here:

Email your questions to, and I’ll get back to you as quickly as I can.

The scripts for the demos are here. Registered PASS Summit attendees can download the Power Point slides available on the session abstract page.

Hope to hear from you as you watch!

Adding a Grid Component with Studio for LightSwitch HTML

I’ve been doing a lot of work in LightSwitch lately, and one of the things that I’ve found frustrating is that there is no native grid component. Just last month, Component One released Studio for LightSwitch HTML which is based on Wijmo widgets for JQuery UI and JQuery Mobile.

Very excited about this release, I downloaded the trial version, and off I went. After installing the component itself, here’s what I had to do to get it to work in a new LightSwitch HTML project:

  1. Add the Extension according the instructions here:!Documents/creatingacomponentonestudioforlightswitchhtmlproject.htm
  2. Rename the default.htm to default_orig.htm file found under the HTML Client node of Solution Explorer
  3. Install the NuGet Client Package according to these instructions:!Documents/installingthenugetclientpackagerequired.htm

I’m not sure why the default.htm didn’t overwrite during the install process, but my file rename workaround seemed sufficient.

In my test project, I first added a browse screen for SalesOrderHeader. Then I made a screen for SalesOrderDetail with a required parameter. I set up the initial browse screen to pass the SalesOrderID from the selected item when opening the ViewSalesOrderDetail screen. Lastly I added a quick AddEditSalesOrderDetail screen that would open when a particular SalesOrderDetail is selected from the grid.

It seems to work pretty well. Now it’s time to add the test code to my real project and play around with the formatting, etc.

Happy coding!

24 Hours of Pass – Summit Preview

I just finished presenting a little preview of the Window Functions session I will be teaching at the PASS Summit coming up in October of this year.

It was little weird not being able to see my audience, especially since you could see me, but it was still a lot of fun.

If you want to try the demos for yourselves, the scripts and database can be downloaded here:

Please email any questions you might have, and I hope to see you at the full length session in Charlotte!

Thanks for joining me today.

SQL Saturday – Dublin 2013



Who are all those people acting like crazy nut balls? Well, first, they’re not really acting <wink>, but more to the point, they are speakers and sponsors from last year’s SQL Saturday event hosted in Dublin, Ireland. I had so much fun last year, that I was quite keen to return this year whether accepted as a speaker or not.

I’m happy to say that I’ll be presenting a session titled “The Secret Life of APPLY – Helping Developers Work Smarter, Not Harder” on Saturday, June 22. This is a new and improved version of the “Why APPLY?” session you may have seen at Tech Ed Africa or SQL Bits this past spring. The session abstract can be found on the SQL Saturday website.

If you live in a place where you can attend, then RUN, don’t walk, to your computer and register now. Bob Duffy blog|twitter and his crew at Prodata know how to put on one heck of a show.

Make sure to stop and say hello while you’re there!

Register Now!


Hey folks, if you’re interested in obtaining some top-notch SQL Server training without having to travel, then SSWUG’s virtual conference hosted during the second week of July is just for you.

Back in 2008, when I found myself with my first SQL Server to manage, I was able to easily convince my new boss to cover my registration fee for the SSWUG virtual conference taking place that fall. I learned a ton and discovered a SQL Community full of people willing to help me become a better SQL Server professional. Because of this experience, I immediately agreed to contribute to this year’s conference.

I’m presenting two, sixty minute sessions:

  • T-SQL Fundamentals: Logical Processing Order
  • The Secret Life of APPLY: Working Smarter, Not Harder

All the sessions are presented with high-quality video that allows you to easily see the slides and demos. Additionally, all the presenters will be in a live chat room  to answer questions during their sessions. Finally, you’ll have full access to the resources presented, and you’ll even be able to re-watch sessions on-demand for 30 days after the event has completed.

Follow this link to see the other sessions on offer from industry experts like Kalen Delaney blog|twitter, Mark G. Stacey blog|twitter, Denny Cherry blog|twitter, Allen White blog|twitter, Ben Miller blog|twitter, and more.

Click here to register.

I hope to “see” you there!

SQL Bits XI – Nottingham, England

Presentation download links:

May 3, 2013: Why APPLY?

Tech Ed Africa 2013 – Durban, South Africa

Presentation download links:

April 18:  What’s Buried in the Plan Cache?

April 19:  Why APPLY?

A Lesson in Choosing a Name For One’s Computer

In an effort to squeeze at least another year’s use out of my Dell Vostro 3750, I purchased an SSD to replace my existing hard drive. Of course, installing a new drive means you get to spend a good deal of time reinstalling operating systems, applications, etc. Fun, right? Well, the SSD is smoking fast, so that has made the entire process slightly less tedious, and since I needed to start from scratch, I decided I might as well upgrade Windows and Office, thus adding to the fun. Turns out I like Windows 8 more than I thought I would during the first five minutes of using it, and I really like the minimalist color scheme in Office 2013, even though it’s likely I’m in the minority opinion here.

But, I digress . . .

All my installs were going along swimmingly until I got to SQL Server. I kept getting this weird error that made me think I was having permissions issues with the account I set up to run the SQL Services. I ended up spending my day Googling what I thought was the issue and trying several different things all to no avail. Long story short, I finally Googled the *exact* error message I was getting:  [Configuration error description: '' is not a valid login or you do not have permission.]

Turns out, my complete lack of creativity when choosing a name for my computer during Windows setup came back to haunt me. By naming my computer Christina and also setting up my user account as Christina, it caused the SQL install to blow up when I tried to add myself as a SQL Administrator. DOH!

Lessons Learned:

  1. Do yourself a favor, and don’t give your computer the same name as your user account if you expect to be able to add that user as a system administrator when you install SQL Server.
  2. Search for the exact error message text. I’d have solved my problem three installs earlier had I followed troubleshooting 101. 

Now, go play with Windows 8 and Office 2013!

Where in the World is this Idera Ace Next?

How about the Big Apple?! New York City, that is. I’ll be in town for SQL Saturday #158 talking about What’s Buried in the Plan Cache during the last session of the day. I have to say that I am seriously excited about this event. It’s been way too long since my last visit to my dad’s home town, and I’m really looking forward to all the sights, sounds, and gastronomical delights that are always on offer. I’ve managed to wrangle a few extra days in town and expect to fill them chock full of museums, restaurants, and general wandering.

But, first things first! Have you seen the line up of speakers? There’s a little something for everyone, and a good mix of local, national, and international speakers. I’m personally pretty excited about getting to hear from Hilary Cotter, Linchi Shea, and Leonard Lobel, all folks that I’ve not heard speak before.

Finally, I would be remiss if I didn’t give a shout-out to my fellow Idera Ace, Tim Radney, who will be presenting Know Backups and Know Recovery. We are grateful for Idera’s continuing commitment to invest in the SQL Community, and thank them for sponsoring our travel to this event.

So, fellow SQL Server professionals, if you are anywhere close to New York City on August 4th, register now for this day full of SQL goodness! You do not want to miss this amazing, free learning opportunity.

Hope to see you there!

Upcoming Speaking Engagements

February 24, 2012

March 10, 2012

March 24, 2012

MARCH 31, 2012

APRIL 14, 2012