SQL Server Stretch DB to Azure

Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...

Azure Cosmos DB API Architecture

Again, still we have a lot of information we can spread our knowledge on it for Cosmos DB today I will talk about Cosmos DB API options and How...

Recapping SQL Saturday Albany 2020 (virtual)

This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed...

Getting Started with Stream Analytics

Resources

Resources

If you want a schema reference for the json Application Insights produces // [Azure Application Insights Data Model // Microsoft Docs

](http://bit.ly/2S3kFlD)

If you want to visualize last 90 days of...

Saving My Garmin Data

With the Garmin outage, I was a little worried about my data. As a result, I wanted to ensure I could get information off of my device and at...

Calculating Application Availability in the Cloud

When deploying business critical applications in the cloud you want to make sure they are highly available. The good news is that if you plan properly, you can achieve...

Daily Coping 24 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Giving Back to Speakers

It might be hard to think back to 2007, but at that time, there were only a few SQL Server events taking place in the world. SQL Bits held...

Probing Columnstore Indexes

This article was first published on: 2020-03-14.

This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.

We'll cover examples...

Daily Coping 23 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...