Daily Coping 4 Jan 2021
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-04
20 reads
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...
2021-01-11 (first published: 2021-01-04)
696 reads
2020 Year in Review
Yeah, so…that was a hell of a year, wasn’t it?
Short-Form Reviews of Year 2020 Reviewer #1: 👎
Reviewer #2: ★✩✩✩✩, would not recommend
Best Laid Plans… The year started out really...
2021-01-04
7 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
9 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
7 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
11 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
8 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
9 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
7 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
10 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Alamat Kantor BCA KCU Kedoya Permai Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5,...
Alamat Kantor BCA KCU Gajah Mada Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari,...
Alamat Kantor BCA KCU Pluit Telp:08218154374
Hub Via Wa:628218154374 Alamat: Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
Question of the Day
Backing Up a DMK
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