SSIS Data Flow Plus!
In my previous blog post I talked about BIML, and how it might revolutionise my approach to creating ETL processes. It’s pretty cool, and very powerful, but there is a bit of a learning curve, …
script
BIML, where have you been all my life?
I’ve used the BIDS Helper Visual Studio add-on for years now, and I’ve seen and heard of BIML, but it’s one of those things I’ve never needed to look into any further than that. Until …
Keeping track of your SQL Server index “inventory”
Something’s always bugged me when it comes to managing indexes in SQL Server; keeping track of when I created or dropped them. You can already check just about everything you could want to know about …
Keeping track of your SQL Server index “inventory” Read More »
PowerShell script to update Azure firewall rule
*Updated 2017-06-28 I’ve recently moved house, and as a result had to change my broadband plan from cable to ADSL (sad face). This also means I’ve gone from having a fixed IP address to a dynamically …
SQL Server version information from build numbers
Just a quick post in case anyone else finds this useful; for a report I’ve created, I wanted to have SQL Server versions displayed in a nice, readable form, rather than the usual build number …
SQL Server version information from build numbers Read More »
Customising SQL Management Studio 2012
I’m setting up my new work laptop, and decided to have a look around the net for what the cool kids were doing these days as far as customising SQL Management Studio 2012. Surprisingly not a …