Daily Coping 3 Feb 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-02-03
27 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 1)
Welcome back to my ongoing series about how we perform regular server reviews here at Dallas DBAs, and the tips and tricks I’ve picked up in my first 1.5...
2021-02-03
32 reads
Added another 3 new PowerShell functions for reports on Power BI Report Server
I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve...
2021-02-03
35 reads
Added another 3 new PowerShell functions for reports on Power BI Report Server
I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve...
2021-02-11 (first published: 2021-02-03)
595 reads
Mastering TempDB: The Basics
I regularly deliver a presentation called “Mastering TempDB”. I wrote it based on what I wish I knew about TempDB “growing up” in my career as a SQL Server...
2021-02-03
72 reads
Launching On-Demand Training Platform SQLibrium
I am thrilled to announce the launch of a new education initiative called SQLibrium. For years, I’ve traveled the world educating technical audiences on deep-dive topics around how data and...
2021-02-10 (first published: 2021-02-02)
264 reads
Daily Coping 2 Feb 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-02-02
11 reads
Azure SQL Database and Long-Term Backups
There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server. As...
2021-02-02
101 reads
Daily Coping 1 Feb 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-02-02
23 reads
What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2021-03-24 (first published: 2021-02-01)
403 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
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
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