SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source variables. Once again in my quest for performance,...
2010-11-12
819 reads
Free SQL Server Training for the Week of November 15, 2010
Tuesday
SQL Lunch - Get a Lever and Pick Any Turtle: Lifting with Metadata - Cade Roux
Pragmatic Works - SSIS Dataflow - Designing for Performance...
2010-11-12
799 reads
SQL Rally Precon Vote Results
The votes have all been tabulated and during PASS this week the top pre conference seminars were announced for SQL Rally.Thankfully...
2010-11-12
509 reads
How I like to work
This is a great sign. I see if every time I go to Brother’s BBQ in Denver and it never...
2010-11-12
770 reads
Defensive Db Programming Chapter 08
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this series by looking here. We are now discussing chapter 8...
2010-11-11
4 reads
Defensive Db Programming Chapter 08
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this...
2010-11-11
550 reads
PASS Summit 2010, Day 3 Key Note
Today is Dr. Dewitt.
The ballroom, where the keynotes are held, is filled with extra chairs. The Summit organizers expect extra...
2010-11-11
792 reads
PASS Day 3: Keynote Live Blog
I’m live blogging the PASS keynote…it’s 8:44 local time.
Me: Tuesday is #SQLSat shirt day, Wednesday is #sqlkilt day, Thursday is...
2010-11-11
685 reads
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS...
2010-11-11
647 reads
SQL PASS Summit 2010 – Keynote Day 3
Today is the last official day of the SQL PASS 2010 summit, which also means the last day for live...
2010-11-11
750 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
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...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
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
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