An introduction to CDC can be found here. When CDC (Change Data Capture) is enabled on … CDC Capture jobRead more
CDC Cleanup job
An introduction to CDC can be found here. All data modifications in a CDC enabled table … CDC Cleanup jobRead more
SSDT and three part names
Currently, SSDT (SQL Server Data Tools) in Visual Studio doesn’t accept self referencing three part names. … SSDT and three part namesRead more
Master Data Services – MDS – Introduction and Concepts
MDM – Master Data Management Some types of data are shared across systems. One of the … Master Data Services – MDS – Introduction and ConceptsRead more
Can’t shrink log file
On a heavily utilized system with lots of transaction, shrinking the log file may be difficult. … Can’t shrink log fileRead more
SQL Server Change Data Capture (CDC) Basics
Change Data Capture (CDC) was first introduced in SQL Server 2008, and is a tool that … SQL Server Change Data Capture (CDC) BasicsRead more
NULL and aggregates
An aggregate in SQL Server will ignore NULL values. Check out this simple demonstration to learn … NULL and aggregatesRead more
Introduction to Automate BPA Server
If you are using SQL Agent together with SSIS and if you have a batch job … Introduction to Automate BPA ServerRead more
Map users to logins
“Why can’t I login after the database restore?” As a DBA, this is one of the … Map users to loginsRead more
sp_cycle_errorlog
Sometimes the error log files in SQL Server get too large to view and manage in … sp_cycle_errorlogRead more