Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system
2009-09-30
3,222 reads
This article describes step by step how to create Service Broker objects and set up a basic conversation between the Initiator and Target from new author Jayakumar Krishnan.
2009-09-29
8,773 reads
A few of the reasons why you might want to attend the PASS Summit this November.
2009-09-29 (first published: 2009-05-29)
1,995 reads
I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005.
2009-09-29
3,975 reads
This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.
2009-09-29
4,823 reads
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
739 reads
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
471 reads
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
557 reads
Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!
2009-09-28
3,533 reads
This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.
2009-09-28
2,417 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers