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, […]
SSIS Data Flow Plus! Read More »
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
BIML, where have you been all my life? Read More »
I’ve recently needed to move data from our transactional database (an Azure SQL database), into an Azure SQL Data Warehouse. A definite case of “harder than it needed to be”… What’s an Azure Data Warehouse?
Azure SQL to Azure Data Warehouse ETL Read More »
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 »
I hadn’t been following the news much regarding SQL Server 2016, so when I did some reading the other day I was quite pleasantly surprised by some of the new features announced (not to mention
SQL Server 2016 & Azure Query Store Read More »
We use Red Gate Cloud Services to backup our Azure database, as well as some storage accounts to Amazon EC2 storage, etc. It all works really well 99% of the time, but after a few
Red Gate Azure backup failures Read More »