The following is an excerpt from SSIS Design Patterns (now available in the UK!) Chapter 7, Flat File Source Patterns. The only planned appearance of all five authors presenting on SSIS Design Patterns is the SSIS Design Patterns day-long pre-conference session at the PASS Summit 2012. Register today. Let’s look at producing a footer row and ...

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 ...

That call to action from Microsoft Leadership struck a chord with many in the SQL Server MVP Community. The response? SQL Server MVP Deep Dives, released at the PASS Summit 2009. Proceeds from the sale of that book continue to go to War Child International. It hasn’t stopped there, though. This year, SQL Server MVPs have completed SQL Server MVP ...

Two years ago, I was involved in a worthwhile project that produced a book called SQL Server MVP Deep Dives - a collection of chapters written by 50 or so fellow MVPs, assembled in a single volume and sold to the masses. The unique component of this project was that no author or editor took a single penny - most of the proceeds went to charity ...

  A friend of mine Benjamin Nevarez has written a book on the inner workings of the Query Optimizer and it was just released. I read a preview and was definitely impressed so I expect the full version to be just as good. More details can be found here and it is available at Amazon here as well. I hope you enjoy it. Andy

Introduction Seth Godin's latest book is called Poke the Box. I'm still reading it, but I have these thoughts to share: Initiate The theme of the book is to start something. Initiate. Engage. Don't wait to be picked - pick yourself. I so identify with this sentiment. It's a driving tenet behind SQLPeople. Seth points out the (dying) ...

I was amazed at the results when I just did a search of SQLBlog, and realized no one had really blogged here about the changes to the Microsoft Certified Master (MCM) program. Greg Low described the MCM program when he decided to pursue the MCM at the end of 2008, but two years later, at the end of 2010, Microsoft completely changed the ...

A while ago, I was offered to have an early look at the book ''SQL Server DMVs in Action'' (by Ian W. Stirk). This morning, I received a copy (in electronic form) from Manning Publications of the book. So I jumped straight into the book, and here are some thoughts from a quick first look: DMVs were introduced in SQL Server 2005, ...

If, for who knows what reason, you haven't yet got your copy of the SQL MVP Deep Dives book, you can't pass it up today. It is the ''Deal of the Day'' at Manning, and you can get it for only $25! Check it out at at: http://www.manning.com/nielsen/ (the main Manning page at http://www.manning.com/ mentions the deal, in the top right corner) Use ...