Tag: azure

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 […]

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 […]

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 […]