SQL Server 2012 Integration Services - An Expert Cookbook

I have been asked to review SQL Server 2012 Integration Services - An Expert Cookbook from Packt Publishing.

Please note this review has been over one weekend and is not an exhaustive look at every word and chapter for correctness and completeness.

Name: SQL Server 2012 Integration Services - An Expert Cookbook
Authors: Reza Rad, Pedro Perfeito
Released: May 2012
ISBN: 978-1-84968-524-5
Pages: 564 (eBook pdf)

I first came into contact with Microsoft's ETL tools in Windows Server 2000. This tool was called DTS and well, it did the job. With the release of 2005 Microsoft completely overhauled SQL Server and brought out SSIS. This release is what helped propel SQL server into the Enterprise market. I am currently a Data Warehouse Consultant so will be reviewing this book with a perspective of an Agile Data Warehouse Developer.

The book starts of giving a brief history of the SSIS tool and its heritage. This book's target audience would be those who have used SSIS and are looking for deeper knowledge or more experienced SSIS developers looking for goto manual. As this is a cookbook the chapters then move on relevant subject areas and have recipes based on those areas.

It covers a fair bit of the components available in the toolbox. It tells you what this component is used for and then gives a recipe for using that component. I can see this book being the reference manual when building packages and it answers that, how do I do that again, thought.

The sections on scripting & logging are a little lite. The scripting section could have gone further into depth about what you can do from the .NET environment by offering a little more than just a mail example. However, keeping in mind this is a recipe book, there is enough for you to understand how to setup a basic script and then use the power of .NET to extend this to enable you to do tasks beyond the standard components.

I really liked the recipe for the checkpoint as I have not realised this feature was available and will ensure if I need to build SSIS packages again in the future, I refer to this recipe.

Overall this is a fantastic book at giving you the right information on how to use/do a particular task that you can then start modifying to suit your environment. I would have this book on my shelf and hope that Packt get positive feedback so they can then create an Advance Recipes book that gives you some real world useful recipes for overcoming some of the shortfalls that SSIS may have in specific situations.

I would rate this book 4/5 stars - A worthwhile investment for any SSIS developer.

New Job!

Well I resigned from my current post and am going to work in the Data Warehousing field full-time.

I am looking forward to the challenges of learning this vast topic from incredibly passionate consultants.

My entry into this field starts on the 2nd of April so my blog may even actually change tacts from current development ramblings to a more Agile DW as I write about my struggles and success!

What I Use - March 2012

Not much has changed over 2 years. More investment in photography plugins than anything else.

This is the current software that I use. I have removed the divide between Personal & Work sections. This is in no particular order:

• Resharper 7.0
• Visual Studio 2010
• Visual Studio 2011 Beta
• Office 2010 x64
• RSS Bandit
• Palemoon 9.2 (x64)
• Codesmith 6
• Windows 7 x64 Ultimate
• Windows 8 Consumer Preview
• Window 2008 R2 with HyperV
• GNU/Linux (Fedora/Centos)
• Notepad++ 
• VMWare Workstation 8
• Avast Internet Security
• Malwarebytes
• SQL Server 2008
• NUnit / MbUnit / Gallio Icarus / Visual Studio Test
• Stardock Fences Pro
• Power ISO
• Slysoft Virtual CD
• Lightroom 4
• Nik Software Complete
• Photoshop CS5 Extended
• OnOne Complete 6
• Topaz BW Effects
• Topaz Stars Effects
• Photomatix Pro
• PTGui
• Nero 11
• Xillisoft DVD Ripper
• Xillisoft Video Converter
• Ashampoo Snap 5
• Cygwin Utilities
• AVR Studio 5
• Perfect Disk 12.5 (client & server)
• Display Fusion
• YNAB
• Guitar Pro 6
• VLC
• AnyDVD
• Skype

Lightroom 4

I have upgraded to Lightroom 4 and wished Adobe had made this available in 2 versions:

• Normal - Single Catalog
• Enterprise - Shared Catalog

I am very happy with LR4 and it does perform better than the BETA. The catalog upgrade was seamless and I am finding that re-visiting post-processed photos and switching the updated develop module does seem to bring more detail out of these photos.

Looking forward to testing my plugins and see if they work under LR4 or there is going to be a flurry of software updates from me over the coming weeks.

Windows 8 Consumer Preview - Day 7

So, I took the plunge and decided to see how the web update method of a laptop went.

This laptop has been running Windows 7 x64 for a while now and is cluttered with junk (its not my everyday machine).

The specs are:

• Toshiba P300
•  Dual Core Centrino 
• 4gb RAM
• Dual 720Gb HDD

The upgrade was smoothless with only requiring me to install Avast AntiVirus and Raxco Perfect Disk. After uninstalling these two products and rebooting, the OS continued to install.

There was one glitch where after going 100% through the update it just hung on a black screen on 100% HDD activity. I did the power-cycle and it rebooted and setup the user profile without any issues.

I have used this laptop exclusivly over the last 2 days doing things like watching movies, playing music and will confess it feels like it runs faster and with less disk activity than what Windows 7 was doing. This hardware was designed for Windows Vista (and only just in my opinion!).

I find myself missing the start menu less and less as the metro start enables me to get to the required application in less time. I can see Microsoft's vision for what it is, and look forward to the first bug fixes (if not a Win8 SP1) to get this into version 2.0.

To quote U2 for those complaining about the lack of a start orb/button - Your stuck in a moment, you can't get out off.....

Windows 8 Consumer Preview - Day 1

Well, I have installed my basic software:

• Office 2010
• SP1 won't install at this stage for some reason.....
• Palemoon browser (think Firefox - Windows optimised)
• Nero 11 burning
• VLC for media
• Desktop Fusion
• Lightroom 3
• Avast Internet Security
• AnyDVD HD
• Virtual CloneDrive
• TortoiseSVN
• Visual Studio 11 Beta
• Resharper 7 Early Preview (for VS11)

Overall, this release is much more coherant than the developer preview. I am slowly getting over the missing orb as the new start screen supports typing for the program you wish to run.

Next up will be Photoshop CS 5 and all my plugins and I should have everything that I use daily to continue my daily run of this release.

 There are some UI issues with some programs having artifacts in the chrome and some of my internal SATA drives being detected as removable and just disappearing!

These are minor issues at this stage and I am happy to progress forward with this release

Windows 8 Consumer Preview - Day 0

I have now installed the consumer preview using a VHD as my drive and booting on the bare metal.

My first problem is I never realised how much I used the start button until now!

I am just setting up .NET 3.5/2.0 and installing Visual Studio 2011 Beta as well.

This is going to be my primary OS over the next couple of weeks to give this OS a fair chance rather than just ranting about how I hate the new metro interface.