Globally Distributed Azure Cosmos DB
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing this, why would you ? what are the benefits? Regional based. By this I mean...
2019-06-18
61 reads
Arun Sirpal
Azure Cosmos DB Local Emulator
Technically you do not have to create a cosmos DB and incur costs to test cosmos DB based applications, you could use the local emulator. This means that you...
2019-06-11
88 reads
Azure Cosmos DB Intro
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
207 reads
Using Azure Data Factory to Migrate Data
Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF). Overview Before I begin, what exactly is...
2019-05-22
193 reads
Azure SQL Database Serverless
Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...
2019-05-14
329 reads
Pausing / Resuming Azure SQL DW
Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
2019-05-07
114 reads
Video – Creating Azure SQL Database
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
41 reads
Scaling SQL Elastic Pools
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
63 reads
Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
157 reads
SQL Server 2019 Suspend/Resume TDE
Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in...
2019-04-02
161 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