Just One More Reason to Love SSIS

Alternate title for this post: "Is Sarah Palin BI?" But I didn't want to go there, and I'm sure you appreciate that.

But here in the US, the presidential election season is nearly over (just a few more days to go) and many people are getting sick and tired of listening to the candidates talk. But for the last few months (or years) they have been talking a lot, and people have been transcribing what they say for the press and for prosperity.

And someone (sadly I do not know who[1]) has taken those words, particularly the words of vice presidential candidate Sarah Palin, and run them through the text mining features of SQL Server Integration Services. And the UK IT news web site The Register has the scoop.

What's not to love? Politics, plus killer BI tools, plus dry British humor[2] is a surefire recipe for holiday laughs.

Happy Halloween!

[1] Although if the author of the SSIS package reads this and wants to share the DTSX with me, I would love to have it ;-)

[2] Or does that need to be "humour?"

Join Me in Prague!

Earlier this week the MCT team here at Microsoft Learning went live with the MCT Summit 2009 web site. There's information about the two currently scheduled summits:

• Prague, Czech Republic - Jan 6, 2009 - Jan 9, 2009
• Redmond, Washington, US - Jan 20, 2009 - Jan 23, 2009

We're also going to be announcing a 3rd Asia-Pacific region event soon, but the dates and location aren't yet finalized.

But the excitement here[1] today is that I will be attending the Prague event. I wasn't sure until today if I would be able to make it to Prague, but everything has come together and I will be there representing Microsoft Learning in my new Quality Architect role.

And for my own personal pleasure, I'm hoping to do a repeat performance of my "SSIS deep dive" session from February's MCT Summit event in Redmond, and present an "Everything you ever wanted to know about SSIS but were afraid your students would ask" technical session in addition to my Microsoft Learning presentations. The Summit schedule is still up in the air, but even if I can't get on the official schedule I will still do the session if I can find a room and an audience.[2] If you're interested, let me know early, ok?

I'll see you there!

[1] "Here" in this case is my office in New York - I'm sure that everyone at Microsoft Learning in Redmond is probably saying "Oh no, not that guy again!" ;-)

[2] This is what happened in Redmond at the 2008 MCT Summit. Everything came together at the last minute, so there was no way to get on the real schedule, but we ended up with a few dozen MCTs who stuck around for almost four hours of SSIS goodness, even though Microsoft was supplying MCTs with free drinks and food on the other side of town, How's that for commitment?

Certification Offers at PASS

Are you going to be at the PASS Community Summit 2008 conference next month in Seattle? I am, and you should be too. Why? Well, if the opportunity to attend amazing sessions and rub shoulders with members of the SQL Server product group and SQL Server MVPs wasn't enough, Microsoft Learning is offering a variety of certification-related offers to help PASS attendees get certified on SQL Server 2005 or SQL Server 2008.

First of all, there are two discounts offers available.

1. If you're among the first 100 to register for an exam, you get the exam for free. This offer has been published for a while, so act now for a chance to get this 100% discount.
2. If you're not among the first 100, you still get a 25% discount on any exams you want to take during the conference - just register and go.

Next, Microsoft Learning is also offering a set of exam prep sessions for PASS attendees who want an extra edge when taking a certification exam. Here's the tentative schedule (it's really unlikely that this is going to change, but you know how conferences are - you should always check the schedule on site once the event begins) for the exam prep sessions:

• Tuesday, November 18                           
• 10:15am - 70 432 TS: Microsoft SQL Server 2008, Installation and Maintenance
• 1:00pm - 70 431 TS: Microsoft SQL Server 2005 - Implementation and Maintenance
• 2:45pm - 70-447  UPGRADE: MCDBA Skills to MCITP DBA by Using Microsoft SQL Server 2005
• Wednesday, November 19
• 10:15am - 70 448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• 1:30pm - 70 445 TS: Microsoft SQL Server 2005 - Business Intelligence
• 3:00pm - 70 455  Upgrade: Transition your MCITP Business Intelligence Developer Skills to MCITP Business Intelligence Developer 2008
• 4:30pm - Cert 101
• Thursday, November 20
• 10:15am - 70 432 TS: Microsoft SQL Server 2008, Installation and Maintenance  (repeat)
• 1:30pm - 70 450 PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008          
• 3:00pm - 70 453 Upgrade: Transition your MCITP Database Administrator Skills to MCITP Database Administrator 2008

As you can probably guess, I'm going to be presenting the three BI exam sessions on Wednesday. They asked me "can you do two?" and I said "no, but I can do three!" The other exam prep sessions are going to be delivered by veteran MCTs Telmo Sampaio and Rob Boek, and the Cert 101 session is going to be delivered by none other than Microsoft Learning's own Gerry O'Brien. What's not to love?

So - if you're going to be at PASS and are thinking about getting certified on SQL Sever, don't miss these offers. And be sure to look me up during the conference. I'll be in the certification area on Wednesday, and will probably be hanging out in the Ask The Experts Lounge at least some of the time (I have so many questions! ;-) and who knows where else I'll be the rest of the time - just keep your eyes open and be sure to say hello.

SQL Server 2008 - Free with Classroom Training

Talk about synchronicity - the old and the new have come together with a great big bonus for SQL Server professionals who are seeking training on SQL Server 2008. Microsoft Learning[1] is teaming up with the SQL Server[2] team to give away free copies of SQL Server 2008 Standard Edition to people who attend instructor-led classroom training at a Microsoft Certified Partner for Learning Solutions (CPLS). Here's the deal:

1) Attend one of these classes at a participating CPLS between December 10, 2008 (when the courses start to become available) and June 30, 2009:

• 2778 - Writing Queries Using Microsoft® SQL Server™ 2008 Transact-SQL
• 6158 - Updating Your SQL 2005 Skills to SQL Server 2008
• 6231 - Maintaining a Microsoft® SQL Server™ 2008 Database
• 6232 - Implementing a Microsoft® SQL Server™ 2008 Database
• 6234 - Implementing and Maintaining Microsoft® SQL Server™ 2008 Analysis Services
• 6235 - Implementing and Maintaining Microsoft® SQL Server™ 2008 Integration Services
• 6236 - Implementing and Maintaining Microsoft® SQL Server™ 2008 Reporting Services
• 6317 - Upgrading Your SQL Server 2000 Skills to SQL Server 2008

2) Get SQL Server 2008:

• SQL Server 2008 Standard Edition – Full software
• 1 Client Access License (CAL)
• 32 bit, 64 bit and IA64 versions included
• Software will be English only at this point

Pretty simple, right? There are a few minor gotchas, but please don't let these stand in your way:

• Each CPLS will decide whether or not they participate in this promotion campaign, so talk to your local CPLS and make sure they know about it and that they are participating.
• This offer is only good while supplies last. Plan your training early!

And that's that. Call your local CPLS today and ask about SQL Server 2008 training. Tell them Matthew sent you. [3]

[1] This is the "new" part - I joined Microsoft Learning as a Senior Program Manager earlier this month, although I cannot take any credit for this cool promotion.

[2] This is the "old" part - I've loved SQL Server since forever.

[3] And no, I don't get any kickbacks. How unfair is that? ;-)

Holy VHDs Batman!

Ok, color me impressed. I'm watching today's PDC keynote and just saw that Windows 7 can natively:

• Mount VHD files as disks
• Create fixed size or dynamic VHDs
• Boot from Windows 7 VHDs

Holy crap. That last one totally blows me away - the ability to natively boot from a VHD file to test a virtual machine (and the software it runs) without a host OS sucking down resources. Oh yeah!

Now if they just expand the mounting support to also include standard ISO images, I'll be the happiest geek on the block.

it's not BI, but I'm darned excited!

A Free Font of Wisdom

One of my Facebook friends (hi Julie!) posted this morning asking for advice on where to find good free fonts. I replied pointing her to one site where I have found many good fonts, and another friend responded with three more. Here's the list:

• http://www.dafont.com/
• http://www.1001freefonts.com/
• http://www.1001fonts.com/
• http://betterfonts.com/

I know that this isn't BI-related, but I'll bet I'm not the only person who looks for cool and interesting fonts from time to time. And even if I am, now I know where to find a list of links. ;-)

Teaser from PDC: SQL Services

The core of the PDC keynote has been about Windows Azure, the newly announced "Cloud OS" that Microsoft is showing off. Although this is neat and all, I tend to think of myself as a "data guy" so I've just been nodding and smiling.

Until a few minutes ago, when Bob Muglia presented this slide:

You're probably aware already of SQL Server Data Services. This is a new announcement about the evolution of SSDS, named simply SQL Services. This is a cloud-based service that includes core RDBMS functionality but also analysis, data mining, reporting and ETL. Now that made me sit up and pay attention. (And start typing ;-)

One thing that caught my ear, however, is that while SQL Server Analysis Services and SQL Server Reporting Services were both mentioned by name, SQL Server Integration Services was not. Instead Bob Muglia simply talked about ETL, not SSIS.

What does this mean? Who knows. I could just be focusing on a trivial oversight (I often forget to mention things when I'm on stage, so I know how this works) but I think it will be interesting to see how this plays out. Stay tuned!