SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Don Halloran

SQL Server, SSIS, SSAS and maybe even SSRS rants and raves (and, on occasion, useful code or designs).

Archives: January 2011

SSMSDeploy 1.5 Available: new configuration form and highly tweaked request list

SSMSDeploy version 1.5 is ready. This one has a LOT of GUI tweaks. No database changes in this one, so to upgrade just uninstall your previous version and run the 1.5 installer. You will have to redo your configurations - but now there's a configuration form for that! If your… Read more

2 comments, 918 reads

Posted in Don Halloran on 22 January 2011

SSMSDeploy 1.1 Now Available

Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and the revision history page for upgrade instructions and the list of changes.

Read more

8 comments, 683 reads

Posted in Don Halloran on 20 January 2011

SSMSDeploy Now Available!

I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet, ready to be downloaded.

You can find the setup files as well as the source code for the addin and the wrapper at my new website: allmhuran.com

There are a… Read more

1 comments, 572 reads

Posted in Don Halloran on 19 January 2011

SSMSDeploy will be available, with source, for donation

After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.

I've also registered a domain and hosting service to keep this and any other projects or articles I might like to make available, but I also intend to keep publishing here…

Read more

4 comments, 547 reads

Posted in Don Halloran on 15 January 2011

SSMSDeploy Demo #2 - new features

I've made some changes to the addin, adding some new features:

  • Comments: You can now add a comment to your request. The comments show up on most of the addin windows, and you can also see the comment as a tooltip in the deployment list. Requests with comments have their…

Read more

0 comments, 575 reads

Posted in Don Halloran on 15 January 2011

Updated SSMSDeploy Demo Video

This is just a quick note before I head off for work that I have made a new demo video for the addin. I don't think I inadvertently called it "SQL Deploy" anywhere in the commentary (at least on the third or fourth try).

More importantly, this one was recorded…

Read more

0 comments, 599 reads

Posted in Don Halloran on 10 January 2011

SSMS Addin Wrapper - Source Code and Usage

Code First, KTHX!

Here, as promised, is the source code for the SSMS wrapper.


My apologies for the brief delay on this. When I started working on this project I had only intended to write the wrapper and release just that. Once I had the idea for my SSMSDeploy…

Read more

1 comments, 2,186 reads

Posted in Don Halloran on 10 January 2011

SSMSDeploy - Demo Video Available!


1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to SSMSDeploy, and am in the process of updating any existing references and making a new demo video. Apologies to the author(s) of the original SQL Deploy.
2) New video…

Read more

0 comments, 560 reads

Posted in Don Halloran on 9 January 2011

SSMS addin (and wrapper)

So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working on a wrapper to make addin creation easier. I actually first looked at this nearly 12 months ago, but so much reading and trial and error was required that I…

Read more

1 comments, 1,353 reads

Posted in Don Halloran on 4 January 2011

Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas


A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database. The key features of this system were the following:
  • the ERP had no built in support for CDC or data warehousing (eg, no inserted/updated datetime columns on tables)

Read more

1 comments, 1,195 reads

Posted in Don Halloran on 1 January 2011