The 2013 Tribal Awards
The inaugural 2013 Tribal Awards kick off today and Steve Jones has a few thoughts.
2013-12-09
121 reads
Editorial
Relationally Divided over EAV
A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.
2024-08-07 (first published: 2013-12-09)
3,395 reads
What is a Database Administrator today?
Today we have a guest editorial from Jim Youmans that asks "what does it mean to be a DBA today?"
2013-12-06
410 reads
The Future of Auditing
Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.
2016-12-22 (first published: 2013-12-05)
283 reads
Competition or Cooperation
Would you rather work with people, or compete with them? Steve Jones has comments on the Microsoft Stack Ranking system that seems to encourage the latter.
2013-12-04
165 reads
Data Preservation
Today Steve Jones talks about the challenges of preserving data across long periods of time, decades perhaps.
2016-12-26 (first published: 2013-12-03)
144 reads
Is Your Data Relational?
An RDBMS is a good fit for many database problems, perhaps as Steve Jones thinks, the best fit for most. However NoSQL systems have a place, we're just not sure where.
2013-12-02
236 reads
The Abstract DBA
Today we have a guest editorial from Andy Warren. Today Andy talks about his changing role as a DBA and how many tasks he doesn't need to handle anymore.
2013-11-29
218 reads
2013-11-28
105 reads
Visitor Parking
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
182 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