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...
2020-08-06 (first published: 2020-07-28)
526 reads
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....
2020-08-06 (first published: 2020-07-28)
887 reads
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...
2020-07-28
29 reads
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...
2020-07-28
23 reads
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...
2020-07-27
70 reads
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...
2020-07-27
38 reads
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...
2020-07-27
46 reads
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...
2020-07-27
13 reads
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...
2020-07-26
7 reads
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...
2020-07-25
29 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers