Posts

  • ,
    Interesting times

    Well, we are certainly living in interesting times. The world seems to have gone to hell in a hand-basket over the last few weeks, doesn’t it? As the world is struggling to cope with finding a “new normal” amidst COVID-19 chaos, I thought I’d jot down a few rambling thoughts from my neck of the […] Read more…

  • ,
    Cloud Engineers – I want you!

    I’ve been wanting to resurrect this blog for a while, so what better way to do so than advertising the fact that I need some help at work? 🙂 Here at Timely I head up the Platform team. We’re currently a team of 5 (including myself) covering areas such as internal support, reporting, data and […] Read more…

  • 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, so I decided to look for a different way to achieve the same thing, but that required less upskill-time, and preferably […] Read more…

  • 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 I discovered that it’s something that would’ve saved me hours of tedious SSIS work! What is it? BIML (Business Intelligence […] Read more…

  • ,
    Azure SQL to Azure Data Warehouse ETL

    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? I’ll assume if you’ve read this far, you know what a SQL database is. But an Azure Data Warehouse is […] Read more…

  • ,
    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 indexes, via handy DMV’s.  Need to figure out how much your indexes are being used? Take a look at sys.dm_db_index_usage_stats.  Or […] 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 assigned one. Usually, this wouldn’t be a problem, except when it comes to connecting to the several Azure servers that I […] Read more…

  • ,
    SQL Server 2016 & Azure Query Store

    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 that it looks like SSMS will finally be getting some much needed love). 🙂 We’ve been having some frustrating intermittent […] Read more…

  • ,
    Red Gate Azure backup failures

    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 failures in a short time period I opened a ticket with Red Gate. The errors we got weren’t always the […] Read more…

  • Head in the clouds

    Wow – 2 years and 4 days with no posts.  What a slacker… Anyway… I’ve been busy doing a few things in that time.  The most relevant probably being that I moved on from Trade Me near the end of 2014, and now work for Timely.  This is a small company started a couple of years […] Read more…