The SQL UPDATE Statement

It’s Day 2 of the PASS Summit and here we are again live blogging the event.

From the Summit site:

Today Tom Casey will discuss and showcase some of the exciting new and upcoming innovations in Business Intelligence and advances to the data platform, including the expansion into the cloud. Tom will also discuss Microsoft’s progress in the cloud, and the powerful role that SQL Azure and cloud computing will play in enabling the information platform.

Click Here for live blog!

It’s the first day of the PASS Summit 2010 and I”ll be live blogging the first keynote here. Click on the link below to follow along!

From the Summit site:

Ted Kummert will open Day 1 of PASS Summit 2010 by highlighting continued innovation across Microsoft’s business and information platform. Kummert will explore Microsoft’s key technical investments that help solve the toughest issues for various roles across an organization, from IT Professionals to developers. Kummert will explore Mission Critical applications, getting the most out of your datacenter, and the accessibility of Business Intelligence in an effort to deliver on Microsoft’s vision of enabling data platform customers to be more efficient through integrated tools. Some exciting product announcements will also be shared exclusively with PASS attendees so you won’t want to miss out!

On a side note: I REALLY hope we hear announcement for SQL Server 11

Click Here for live blog!

Are You Watching?

I write this as I’m on my way to Seattle for the annual PASS Summit in Seattle, Washington. This is very exciting for me as this is my very first Summit experience and I’ve been looking forward to this for a few years now. So why am I so excited about this event? Well first off this is the largest SQL Server-focused conference in the world! Basically this is the Super Bowl (or for my international friends, the World Cup) of conferences for SQL Server professionals! Being the geek I am, I am going to write a few articles this week that will follow the format of a magic trick: the Presentation, the Turn, and the Prestige. Why this format? Well first off, I’m a fan of the movie the Prestige. Secondly, this event is much like a magic trick in itself.

For those who may not have seen The Prestige, or are familiar with magic tricks in general, there are three major steps to a magic trick. The first is referred to as the Pledge. In this step the magician sets up the audience by telling them they will witness something amazing and setup the situation accordingly. The second step is referred to as the Turn. Here is where the magician’s trick is applied be it making something disappear, or something equally amazing to happen. The audience is held captive as they don’t know how the trick , escape, or illusion will play out. Finally there is the Prestige. This is the final step where the magician finally completes the trick and the audience is left in awe as they witness the seemingly impossible occur right before their eyes. The final result of this process is the audience is left enchanted, thrilled and wanting more. One thing I’ve noticed about the SQL community, and specifically this conference, is it seems to have the same affect hence my choosing this format to share this year’s conference experience.

The last few years for various reasons I haven’t been able to make the cross-country trek for this event . Instead of experiencing the conference first-hand I’ve read accounts on blogs as well as followed along “live” while folks from all over the world Tweeted their experiences from the conference. Not only was there amazing content being presented from top-notch speakers but you could actually follow along and see relationships form as people connected and shared those experiences. Even from a distance I could see how amazing of an experience this was and I wanted to take part. Last year I took part in the conference, virtually, by volunteering my services to the then-community organizer for PASS, Blythe Morrow (Twitter). I had contributed to helping out the organization by putting together a portion of the PowerPoint presentation used by then-President Wayne Snyder in his keynote speech! What made that even cooler was when folks tweeted to me that Wayne had actually acknowledged me by name on-stage for my contribution! In that respect it was very cool feeling connected like I was there even when I wasn’t. It was then that I resolved “even if I have to rob a bank, I’m going to Summit next year!”. Luckily I didn’t have to resort to that and I’m headed there now (the conference, not the bank). I share this last story so as to let you know if you can’t physically make it to the Summit you can still be very much connected and part of the magic. If you’re looking to take part in the magic yourself PASS is always looking for enthusiastic volunteers to help out! If you’re interested feel free to contact the Community Organizer, Nancy Nasso (Email | Twitter) and let her know!

So, my friends, I give you the Presentation. This week is set to be an amazing one. In the next few days the top SQL Server talent from all over the world will converge upon Seattle once again for this amazing experience. The week kicks off with pre-conference sessions given by top industry folks such as Brian Knight (Blog | Twitter), Itzik Ben-Gan (Blog), Kimberly L. Tripp (Blog | Twitter), and more! In addition to those events there will be extra-curricular events going on such as the Photowalk tour or SQLServerCentral’s Casino Night party. From there the conference kicks off with a keynote from Ted Kummert from Microsoft who promises to have some big and exciting news for attendees. Oh, did I mention that all keynotes this week will be streamed live? They will be, so you can witness the magic first-hand with us! Then the next three days are filled with amazing sessions, events, and networking opportunities. This three days portion will be the Turn, as so much will happen and I don’t know how all this magic will happen just yet. Finally, there is the Prestige. Once everything is sais and done, myself and every other attendee will surely be transformed and spellbound by the magic we experienced. In addition to these posts I’ll also be live-blogging the keynotes just so I can share my thoughts on everything that happens so keep an eye out for those posts as well. Ladies and gentlemen, sit back and enjoy the show as we present to you PASS Summit 2010! Enjoy the show!

Not quite Mount Doom but...

As some of you may know, I’ve recently transitioned over from the fabulous life of being a production DBA to joining the ranks of the BI developers with Pragmatic Works. In the years I’ve been a DBA I’ve often took a quick look and learned stuff from the BI stack here and there simply because it was there and quite frankly it’s pretty cool. Now, as a BI developer, it’s time to buck up and ascend the face of the Microsoft BI stack!

Part of my transition from production DBA to BI developer is learning the stack from top to bottom. As I journey through the different challenges of getting familiar with this side of SQL Server I’ll bring you, my handful of readers, along for the ride. While I was a DBA I’ll admit the BI stack always kind of intimidated me so I always shied away from it. Hopefully this series of posts will help future DBA’s turned BI developer (or just DBA’s looking to learn the stack) identify with my challenges and learn along with me.

As with anything, you’ve gotta have the right tools for the job and with this journey we’ll have to pack accordingly. First up we’ll need a guide book to help traverse the mountain. The guidebook of choice for this trip will be Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer). Next there’s basic equipment we’ll be working with. I’ve created a virtual machine and loaded it with Windows 2008 Standard Edition, SQL Server 2008 R2 Enterprise Edition (Database Engine, SSIS, SSAS, SSRS), Sharepoint 2007. Wait did he say Sharepoint 2007? Yes, I’ll be installing the older version for few reasons. One, most companies are still on 2007 so it’s best to learn at the majority target. Two, I’ll be doing an upgrade at some point of the SharePoint instance to 2010 so as to get experience with that part and then playing with more goodies there.

In addition to those tools we’ll need some other supplies, mainly that being data. That’s where you fine folks come in! I’ve created a sample form so as to seed some flat files for some SSIS fun later. Every so often I’ll update the data dump file so that you guys can play along with the same sample data you’re generating! To get to the form simply click here and have fun. Fill it out as many times as you want, the more data the better!

This should be a fun journey to take and I hope you guys enjoy coming along for the ride!

Hate to post this late but just wanted to let everyone know I’ll be presenting for Brazil’s Worldwide Online Tech Day tomorrow, Saturday October 30th. I’ll be presenting on Policy-Based Management and my session runs at 6pm EDT. Listed below is the link schedule of events. This event will have all sorts of cool stuff such as Silverlight, PowerShell, SQL Server, Professional Development, SSIS, SharePoint, Business Intelligence and more!  Hope you can join us!

Schedule of events, with timezone conversion times!