Tomorrow (4/30/2011) is SQL Saturday #74 in Jacksonville Florida and once again, I am giving a talk with other well known SQL Server Guru’s. Register for the event right now…Pack up your computer tomorrow morning and head over to UNF Campus at 8:00 AM tomorrow. You will get some awesome… Read more

Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps organizations with migrating packages from DTS to SSIS. We also have some pretty wicked software that saves time documenting packages, cubes and databases. Furthermore, we have components and tasks… Read more

  If you're on twitter, follow the #SQLPass hash tag and @briankmcdonald for up-to-date information.

  You may have heard that PASS is introducing a new, regional conference this spring. It’s called PASS SQLRally, and it’s taking place May 11-13 in Orlando. I’m excited to be speaking, and I encourage you to… Read more

Problem

A post was recently added to one of the forums that I monitor so that I can help users in the SQL Server community with their issues. In this problem/solution blog post I am referencing a user trying aggregate Category and Subcategory Sales values. Not to tricky so far…