Database Fundamentals #28: Creating a Primary Key Using T-SQL

There are actually a couple of ways to create a primary key with T-SQL. You can use the ALTER TABLE script to add a primary key to an existing...

Sending a SQL Agent Job results overview to a Microsoft Teams Channel

Microsoft Teams is fantastic for collaboration. It enables groups of people, teams if you like to be able to communicate, collaborate on documents, hold meetings and much much more....

Management Studio Find & Replace Using Regular Expressions

In my last Management Studio tip, I demonstrated how you can drag and drop column names to a query window. The only part I do not like about that...

Azure Cosmos DB High Availability and Disaster Recovery Architecture

Part 6 in Azure Cosmos DB architecture Series Keep Learning and Spread your Knowledge if you don’t read the previous parts I highly recommend you to take a look...

Building an Azure Architecture Diagram

One of the challenges I have at times is illustrating how I’d set up a particular system. Not the technical details, the visual ones. I can use boxes and...

Daily Coping 27 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...

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