The SQL UPDATE Statement

We’re 10 short days away from SQLSaturday #62 event and I just wanted to remind everyone about some of the amazing stuff that will be happening that weekend!

First off we have an incredible deal with a pre-con we call Day of Data. We have two all-day training options for you at the incredible price of $99 (after today 1/5, price jumps to $109)! For the DBAs we have Denny Cherry (Blog | Twitter) presenting Storage and Virtualization for the DBA.  For the BI focus We have Stacia Misner (Blog | Twitter) presenting a Day of BI. This price includes coffee, juice and donuts, lunch, and course materials. To register click here and make sure to share this with co-workers and your boss! I guarantee the ROI on this training will be off the charts!

As for the main event we have an AMAZING lineup of speakers for this free (yes, I said FREE) training event. Check out the schedule (time/rooms subject to change):

And I guess it’s worth mentioning I’ll be there presenting my Policy-Based Management in a Nutshell talk so if you come to the event swing by and say hi (even stay for my session if you’d like!). So grab yo kids, grab yo wife, grab yo coworkers and get to SQLSaturday cuz everyone’s learning up in there!*

*I apologize for the horrendous addition to an internet meme to my post

So looks like we have another blog party on our hands, this time courtesy of Jen McCown (Blog | Twitter), one half of the MidnightDBA brand!  This is such a great topic especially coming from a couple who have built up quite a successful brand for themselves in the community and continue to grow it. Check out both their entries (Jen | Sean) on this topic as they both have really interesting views on this stuff.

Branding is a funny thing. It can go one of two ways: you can create a brand that resonates with your target audience, makes you memorable, and any continued associations with your brand and your audience are positive and meaningful. Or you can create a brand very much slanted the other way and any interactions or associations with your brand can bring negative results and damage you personally or professionally.

I’m going to make a quick confession here and tell you that I not only have watched the show “What Not To Wear” on TLC but I thoroughly enjoyed said show. Why confess that? Well on the show the hosts Clinton Kelly and Stacy London often tell their fashion-challenged targets that they need to realize that they’re trying to sell themselves. It’s all about image. This may sound a bit shallow but hear me out folks. You really are the image you project and this includes how you dress, how you act and in the world of blogging and presenting this directly relates to the brand you’re trying to sell: you!

Continue reading ‘Un-SQL Friday: Branding’ »

Watch closely...

I mentioned in my last post that the Turn is the point in the act where the magician executes his illusion, leaving his audience captivated and in wonderment. Sometimes the magician will even make something disappear in to thin air. Funnily enough, this past week I had a little bit of everything I just mentioned!

Continue reading ‘PASS Summit Magic: The Turn’ »

Well, it’s the final day of PASS Summit and the week’s final keynote! Today’s keynote will be delivered by Dr. David Dewitt! His speaking is the result of a user survey sent out by PASS earlier this year.

From Summit site:

You voted, and the results are in: Dr. David DeWitt will be speaking on Query Optimization 101 during the most anticipated keynote of PASS Summit 2010!

“In two short years, giving a keynote at the PASS Summit has become a highlight of my year,” noted Dr. DeWitt, Technical Fellow with Microsoft’s Jim Gray Systems Lab. “This year, I am excited to have the opportunity to talk about SQL query optimization, why it is hard to always produce good plans, and new technologies that offer the promise of better plans in future releases of SQL Server.”

Query optimization is the process of compiling a SQL query into an executable plan that is as efficient as possible. While the basic fundamentals for cost-based query optimization were first described in a seminal paper by Pat Selinger of IBM Research in 1979, optimizing complex queries continues to be very challenging 30 years later. In this talk, David DeWitt will describe the fundamentals of query optimization, why it remains a very hard problem today, and present several recent research results that promise to improve the quality of plans produced in the years to come.

David J. DeWitt is a Technical Fellow in the Microsoft Data and Storage Platform Division. DeWitt’s role is creating and leading the Microsoft Jim Gray Systems Lab, a new advanced development center in Madison, WI, for Microsoft, in association with the University of Wisconsin-Madison Computer Sciences Department. DeWitt came to Microsoft from the Computer Sciences Department at the University of Wisconsin, which he joined in September 1976 after receiving his Ph.D. from the University of Michigan. He served as department chair from July 1999 to July 2004 and held the title of John P. Morgridge Professor of Computer Sciences when he retired from the University of Wisconsin.

Click Here for live blog!

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!