One of the concepts in Snowflake that I find many struggle with is how constraints are handled. If you come from a traditional database platform such as Microsoft SQL...
2020-07-21 (first published: 2020-07-08)
641 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I needed to write this post because I...
2020-07-20 (first published: 2020-07-08)
217 reads
A short post this week, to let you know that I’ll be presenting a brand new session to the Edmonton PASS user group (EDMPASS) next Thursday. It will be...
2020-07-08
15 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-08
16 reads
How many times have you been afraid to hear “No”? We have all been there because we have been trained over the years to perceive “No” as a rejection,...
2020-07-17 (first published: 2020-07-08)
499 reads
Last Updated: 2020-10-18
NOTE: What you read here was before .NET for Apache Spark 1.0 which includes everything we need to do this purely in .NET - in this post...
2020-07-07
35 reads
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine learning (ML) is awesome, so what could be better than using .NET to write ML...
2020-07-07
22 reads
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine learning (ML) is awesome, so what could be better than using .NET to write ML...
2020-07-07
51 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-07
13 reads
Continuing on my recent trend of Management Studio tips, here is another that could save you a few minutes. In today’s scenario, we need to write a select statement...
2020-07-07
15 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