Azure SQL Database Clustered Columnstore Index

Posted on August 6, 2019 by blobeater

You can read about columnstore indexes here (https://azure.microsoft.com/en-gb/blog/transforming-your-data-in-azure-sql-database-to-columnstore-format/). I won’t rehash the material but high level, these index types are optimized for analytical queries and high compression of data (up to 100x). This format is perfect for the large data sets that can be efficiently compressed using this format and analytical queries with complex calculations that use subset of the table columns.

Continue reading →

Azure SQL Database Connect and Query

Posted on July 25, 2019 by blobeater

There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio. You can use the query editor within the Azure portal, that is, if you desire.

Continue reading →

Moving Databases into Azure SQL Elastic Pools

Posted on July 22, 2019 by blobeater

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below.

Continue reading →

Azure SQL Elastic Jobs

Posted on July 11, 2019 by blobeater

The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases. Targets can be in different SQL Database servers, subscriptions, and/or regions. This blog post is quite long and heavy (code wise) so grab a coffee and follow through.

The architecture you could follow is shown below.

Continue reading →