Content in the Cloud
Steve Jones has some concerns over new options in SQL Server 2014 that might lead some customers to experiment in a way that causes them unexpected pain.
2013-11-25
81 reads
Editorial
Core T-SQL
Steve Jones thinks there is a list of core skills that any database developer or DBA needs. This week he asks you for a list of those things you think should be included.
2017-11-03 (first published: 2013-11-22)
791 reads
What is SQL Server not good at?
Today Steve Jones talks about some of the problems in SQL Server. Should we be documenting the situations in which features don't work well?
2013-11-21
374 reads
It Starts with Version Control
Steve Jones knows that good development practices require lots of skill and practice, but the basis for stability with your code is version control. He talks about some reasons why you might want to implement it.
2013-11-20
427 reads
Who Inspires You?
Today we have a guest editorial from Chris Shaw. After the recent PASS Summit, Chris talks about the value of getting inspired by people he listens to talking about SQL Server.
2013-11-18
136 reads
What Counts for a DBA: Deduction
Like Sherlock Holmes, a DBA needs the sound deductive reasoning to pinpoint the root cause of a crime, in amongst a thousand interesting but irrelevant details.
2013-11-18
142 reads
Dream Jobs
Today we have a guest editorial from Andy Warren. Andy asks today if you've thought about a dream job, and if so, what would it be?
2013-11-15
180 reads
Time for Learning
Today Steve Jones talks about the time required to increase your skills and debates about what time you need to invest each year to gain knowledge.
2013-11-14
256 reads
Runtime Code
Do you test your code? What about code that is generated by applications and executed at runtime. Is that tested well? Steve Jones wonders.
2013-11-13
136 reads
Test Coverage
We don't test software well enough. Obviously we don't write high enough quality software, but testing should catch more issues. Steve Jones talks about how you can perform better T-SQL testing.
2016-12-20 (first published: 2013-11-12)
270 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