Maintain Change Data Capture Configuration when restoring a database
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,350 reads
SQL Saturday #57 (Houston) Call for Speakers and Registration is Open!!
So many people have been waiting for a SQL Saturday in Houston and now it’s finally here. As a native...
2010-10-03
720 reads
The Year of the Phantom
It is amazing how fast time moves the older (and slower) we as humans get. Looking back on time, it...
2010-10-03
626 reads
SQL Saturday #53 review
The KC PASS chapter has successfully executed the latest SQL Saturday. Thanks to all the organizers and volunteers for a...
2010-10-03
2,008 reads
Transactional Replication Setup (by Abi Chapagai)
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
2010-10-03
12,067 reads
Red Pyramid
After having read the Percy Jackson series of books, I wanted to read a few more books by Rick Riordan....
2010-10-02
478 reads
Index Black Ops Part 6 – Fill Factor vs. Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-02
1,609 reads
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-01
1,518 reads
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
593 reads
Create Empty Raw File
I need an empty Raw file for my SQL Server Integration Services (SSIS) package. Over the last summer I’ve discovered...
2010-10-01
735 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
Alamat Kantor BCA KCU Bintaro Telp:08217555651
Hub Via Wa:628217555651 Alamat: Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
Alamat Kantor BCA KCU Alam Sutera Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec....
Alamat Kantor BCA KCU Tangerang Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten...
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