Tracking table changes seamlessly with Change Data Capture (CDC)
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,560 reads
Danny Riebeek
- Interests: SQL Monitoring
- Website: https://www.sqltreeo.com
Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,217 reads
Copying parent-child rows and SQL Dependency Tracker
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
2,122 reads
Denali’s Skeletons in the closet (and workaround), Part II
I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...
2011-07-11
619 reads
Select random records using TABLESAMPLE clause
While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...
2011-07-11
1,388 reads
How to merge (combine) date intervals in T-SQL
On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...
2011-07-08
2,165 reads
Showing slowest parts of SQL query
I’ve received interesting question/requirement few days ago:
“… When viewing a query plan graphically, we usually have to hunt for the...
2011-07-08
1,669 reads
Wife and kids are leaving for holiday (it’s not off-topic)
My wife and kids are leaving for holiday (without me). Bad thing is that I will miss them, good thing...
2011-07-07
1,299 reads
Denali’s Skeletons in the closet, Part I
I’ve started to play little bit with SQL Server 2011 CTP Denali to find out whether some open wounds were...
2011-07-06
464 reads
Less code with rethrowing “exception” in SQL Server 2011
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy...
2011-07-06
1,220 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers