MDM – Master Data Management Some types of data are shared across systems. One of the … Master Data Services – MDS – Introduction and ConceptsRead more
Month: March 2014
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
Logging changes to sys.configurations
Some server wide settings can have major negative impact if they are changed in your SQL … Logging changes to sys.configurationsRead more