All About SQL

Azure – What is a Shared Access Signature?

• by Arun Sirpal

• All About SQL

Using a Shared Access Signature (SAS) is usually the best way to control access rights to Azure storage resources (like a container for backups) without exposing the primary /...

2019-09-08

68 reads

Azure Storage Explorer

• by Arun Sirpal

• All About SQL

I only ever use the storage explorer when managing my blobs, files, queues within storage accounts. It is your single view access point for all your storage needs and...

2019-09-04

70 reads

DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.

• by Arun Sirpal

• All About SQL

Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother. Why? Well I have mentioned...

2019-08-23

11 reads

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

8 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

20 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

23 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

66 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

78 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

13 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

13 reads