Azure SQL Database – Azure Portal Updates
A small but useful change has been made to the Azure Portal for Data Platform objects. Straightaway more meaningful information is exposed (and centralized), such as the service tier...
2019-09-17
38 reads
Arun Sirpal
Azure SQL Database Types
I want to do a quick summary post of the many different types of Azure SQL Database available and I am not talking about elastic pools, VMs etc, more...
2019-09-17
28 reads
Training – Learning Data Science
You should never stop learning, especially within the IT industry. There are many fields to move into nowadays within the data space, you still have your classic / cloud...
2019-09-12
228 reads
Azure – What is a Shared Access Signature?
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
84 reads
Azure Storage Explorer
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
75 reads
DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.
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
29 reads
Azure SQL Database Script for Size
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
25 reads
Microsoft Azure and Oracle Cloud
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
25 reads
Azure SQL Database Clustered Columnstore Index
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
158 reads
SQL Server Management Studio
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
80 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers