SQL Server 2012 Integration Services Design Patterns has been released! The book is done and available thanks to the hard work and dedication of a great crew: Michelle Ufford (Blog | @sqlfool) – co-author Jessica M. Moss (Blog | @jessicammoss) – co-author Tim Mitchell (Blog | @tim_mitchell) – co-author Matt Masson (Blog | ...

For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...

What's Going on at SQLServerPedia.com?Since the news broke that I was leaving Quest, I've gotten a lot of questions about the future of SQLServerPedia.com (SSP).  For those of you who don't know, SSP is a very popular community wiki and blog aggregator with nearly one hundred bloggers actively syndicating their content on the ...

  Introducing the Microsoft Broadcaster: A self-service technical content repository that provides you with rich content for your blogs/sites. On behalf of Microsoft, I would like to take the opportunity to invite you to dive into Microsoft Broadcaster. It's a site that unleashes a torrent of technical content like Videos, Webcasts, ...

In this last kind of “creative” chapter, I will look at some of the ways you implement common problems in your relational database, and some of the ways you probably shouldn’t. The “should” sections will deal with: Uniqueness – Beyond the simple uniqueness we have covered in the first chapters of the book, looking at some very realistic ...

As the book progresses, I find myself veering from the original stated outline quite a bit, because as I teach about this more (and I am teaching a daylong db design class in August at http://www.sqlsolstice.com/… shameless plug, but it is on topic :) I start to find that a given order works better. Originally I had slated myself to talk more ...

A while back, I was working on a short article about Normalization for a book that never got published (admittedly I wasn’t getting paid for the article, and it wasn’t for charity, so I wasn’t that broken up over it.)  The task at hand was to, in 2 pages or less, describe the process of normalization and help you to know when you have ...

My latest Stairway to SSIS article - The SSIS Data Pump - Step 2 of the Stairway to Integration Services - is featured today at SQL Server Central! :{>

I am trying to blog all of the chapters of the book, but due to deadlines and a lot of shuffling about, I never got around it for these three chapters, two of which I have added since I wrote the original table of contents. All of these contain mostly material from previous editions of the book, updated a good amount, but nothing tremendously ...

Brent Ozar (blog | twitter) and I did an interview with TechTarget’s Brendan Cournoyer at last summer's Tech-Ed, which as turned into a podcast titled “Cloud efforts advance, SQL Server evolves.” The podcast covers all the major trends at the conference (like BI), virtualization features in Quest’s products (like Spotlight), Brent’s new book ...