Jessica M. Moss

I have a few events coming up that I wanted to let you knew about.  If you attend, be sure to say hi! Extract, Transform, and Load your Data Warehouse The SQLPASS Business Intelligence Virtual Chapter always provides great information for both beginners and more advanced BI developers.  I’ll be presenting at noon EST on 5/14/2010 on Extract, Transform, and Load your Data Warehouse .  We’ll talk about why ETL is different/important for data warehousing and give examples of more advanced dimensional load scenarios you may face. Adding SSRS Report Bells and Whistles I’m traveling down to Raleigh, NC to speak for the Triangle SQL Server User Group on 5/18/2010 at 6:30pm EST.  I’ve really enjoyed giving this presentation, where I speak about best design practices for SSRS 2008.  I hope to get lots of great questions as well! Easier than Ever Report Authoring in SSRS 2008 R2 The second annual 24 Hours of PASS will be held from on May 19th for the entire day.  Yes, that’s right

What an amazing event. Over the past several years, I have been an attendee, volunteer, and speaker for a number of SQLSaturdays and code camps. Not until recently have I understood the amount of work and effort that an event of this type entails. SQLSaturday events are community-driven events that provide free training for SQL Server DBAs, developers, and BI professionals. Started in 2007 as the brain child of Andy Warren, Steve Jones, and Brian Knight, the brand has recently been acquired by PASS , the Professional Association for SQL Server. On April 10, 2010, Richmond, VA put on a SQLSaturday at the local ECPI College of Technology. Thank you so much to the speakers, sponsors, and volunteers who made this event possible. A huge thanks goes to the leadership team of Andy Leonard, Kevin Israel, Ron Deskins, and Steve Fibich who put in many hours of work! As most of these wrap-ups go, I feel there were some things that we could have done better, and I wanted to share my thought

I had an interesting reporting scenario posed to me that I thought I would share!  (The actual business information has been changed to protect the innocent.)  In this scenario, we own multiple stores that sell a dozen or so products.  We would like a report that shows the type of products that each store has sold on a particular day.  Keep in mind that we could start stocking new products at any time, and we would still like our report to work. Here is our existing data for the database: 3/4/2010 Sports-R-Us Virginia Softball Glove 12/15/2009 Sports-R-Us Virginia Tennis Racquet 12/15/2009 Sports-R-Us Virginia Dartboard 6/6/2009 Sports-R-Us Virginia Fishing Pole 6/6/2009 Games And More Virginia Canoe 2/21/2010 Games And More Maryland Pool T