Fixing CREATE TABLE
Steve Jones has a problem with the inconsistency of the CREATE TABLE statement in SQL Server and has an idea on what to do.
2014-02-27
261 reads
Editorial
Caching
A SQL Server database can easily be seen as a bottleneck as all data must be retrieved from a single machine. However a caching strategy in your application and alleviate load and improve performance.
2014-02-26
250 reads
Lawsuits and Data Breaches
Steve Jones notes that a data breach resulted in a lawsuit. How long before that's a common practice, and should we be preparing as data professionals.
2014-02-25
142 reads
2014-02-24
103 reads
Auditing Matters
We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.
2014-02-24
166 reads
The SQLCLR Impact
Has the SQLCLR system impacted your SQL Server environment? Steve Jones wants to know if it has or has not today.
2014-02-21
219 reads
The Remote Balance
Telecommuting and remote work are growing in many fields, but especially technology. However the practice needs to be balanced with the notion that you still have a life outside of work.
2017-10-20 (first published: 2014-02-20)
195 reads
2014-02-19
822 reads
The Security of Interconnected Systems
We are interconnecting more and more computer systems and applications all the time. Security becomes a problem when one of these systems hasn't been properly configured, secured, or coded. Steve Jones notes this is becoming a real problem.
2014-02-18
141 reads
2014-02-17
185 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