All About SQL

Azure SQL Database Script for Size

• by Arun Sirpal

• All About SQL

Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...

2019-08-12

3 reads

Microsoft Azure and Oracle Cloud

• by Arun Sirpal

• All About SQL

Microsoft and Oracle recently announced a joint cloud partnership (I have seen the word multi/cross-cloud to explain this) which I found very fascinating to read. It is currently in...

2019-08-07

17 reads

Azure SQL Database Clustered Columnstore Index

• by Arun Sirpal

• All About SQL

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...

2019-08-06

6 reads

SQL Server Management Studio

• by Arun Sirpal

• All About SQL

Hopefully you know that SSMS is a separate install from the main SQL Server install. You can find the binaries from Microsoft (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms) Using SSMS version 18.2, whilst playing...

2019-08-01

44 reads

SQL server and Java?

• by Arun Sirpal

• All About SQL

I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to...

2019-07-29

69 reads

Azure SQL Database Connect and Query

• by Arun Sirpal

• All About SQL

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...

2019-07-25

12 reads

Moving Databases into Azure SQL Elastic Pools

• by Arun Sirpal

• All About SQL

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...

2019-07-22

7 reads

Azure SQL Database SLA Updates

• by Arun Sirpal

• All About SQL

I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers  but split between two different high-availability...

2019-07-19

133 reads

SQL Server 2019 Query Store And SSMS

• by Arun Sirpal

• All About SQL

While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...

2019-07-17

19 reads

Azure SQL Elastic Jobs

• by Arun Sirpal

• All About SQL

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...

2019-07-11

154 reads