(2021-Jan-12) Small data that is hard to be noticed but in a long run makes the greatest impact, little things that are not well apricated but eventually become those final...
2021-01-20 (first published: 2021-01-12)
449 reads
I’m a couple weeks late, but not nearly as late as 2020. In any case, I’m going to break these down as I did last year, but hopefully with...
2021-01-11
23 reads
I 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...
2021-01-11
18 reads
Query Store is a configuration that is enabled per database, and the plans and stats for queries executed in that database are stored in the database itself. So what...
2021-01-18 (first published: 2021-01-11)
478 reads
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
20 reads
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
34 reads
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
9 reads
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
25 reads
SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint...
2021-01-09
15 reads
SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint...
2021-01-15 (first published: 2021-01-09)
4,539 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