Guidance
When you are looking to help someone improve performance on a system, there isn't a single set of steps you provide. The advice and guidance you provide will vary, depending on the situation.
2013-08-20
119 reads
Editorial
Opinions and Votes
When we look to improve software, we are often expressing our opinion on which items need to be handled first. It's helpful to keep in mind that it's an opinion being expressed, and not a vote, no matter how much it is solicited by a company.
2017-08-17 (first published: 2013-08-19)
133 reads
Lossy data and incorrect data
Your copier could change data when creating an image. Phil Factor has some words of caution.
2013-08-14
204 reads
Patch Problems
A few recent Patch problems have Steve Jones concerned about the directions we are going with software.
2013-08-13
162 reads
Review Your Code
Steve Jones notes that SQL Injection is still a problem, and while it might be for some time to come, we should not be adding to the issues. Learn how to write secure code.
2013-08-12
539 reads
2013-08-12
121 reads
Would You Choose SQL Server?
This Friday Steve Jones has a poll asking how you feel about SQL Server for your own projects, or even your company's projects. Is it a given you'd use SQL Server?
2013-08-09
269 reads
2017-05-09 (first published: 2013-08-08)
300 reads
The Standard Limitation
SQL Server Standard Edition only supports 64GB of RAM and it's our fault. Or is it, and is this a reasonable number? Steve Jones has a few thoughts today.
2013-08-07
407 reads
Separation of Duty
We want to ensure that the data we gather accurately reflects the state of some system or event. The analysis should decide how we interpret the data gathered. Neither should influence the other.
2013-08-06
133 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