Calendar Reminders for SQL in the City Streamed Free Training Sessions
SQL in the City Streamed is coming up this week! This is an awesome FREE online event, and it’s all about learning new things and getting inspired. Join us...
2018-09-03
10 reads
Employee Agreements & Contracts: Best Practices (23 minute video)
So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand...
2018-08-29
18 reads
How to cause a simple spill to tempdb
Sometimes it’s useful to know how to cause a problem. Maybe you’ve never encountered the problem, and want to get hands-on experience. Maybe you’re testing a monitoring tool, and...
2018-08-22
22 reads
SQL in the City, Fall 2018 – Join Us!
SQL in the City is coming up, and it's a huge opportunity to learn. Register now to attend the free online streamed event, and join the Redgate team in...
2018-08-22
12 reads
Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
16 reads
I’m Joining Redgate Software!
I’m excited to announce that I’m joining the evangelist team at Redgate. Starting next Monday, I’ll be working with Steve Jones, Grant Fritchey, and Kathi Kellenberger — plus the whole...
2018-08-15
13 reads
Employee Agreements & Contracts: Anti-Patterns (31 minute video)
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
15 reads
Table Value Constructors in TSQL
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
35 reads
Upcoming Live Podcast Recording Sessions: Employee Agreements and Contracts for DBAs and Devs
I’ve just scheduled two new podcast recording sessions! These are live, half hour sessions – you can join in listen, or share comments. Here’s what we’ll be talking about…....
2018-08-03
12 reads
Dear SQL DBA: Remembering Robert Davis, DBA Hero
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
27 reads
Blogs
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
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...
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