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

I have been using SQL Server Data Tools (SSDT) both at work and on some hobby projects for quite a few weeks now and of all the new features I have to say the one that I am appreciating the most is Publish Profile files. I have been searching around on MSDN for an article that explains Publish Profile files but it seems no such article exists so ...

I have a question for you today: How do you deploy a SQL Server database? Please leave a comment with your answer. This isn't a trap or trick question. I want to know how you go from no database to a database on an instance of SQL Server. Comments are moderated, so they will not appear on the post immediately. :{> Andy