ISO week numbers can belong to a different year from the calendar date. A Thursday-based calculation keeps the ISO year and week together across December and January.
CDC Capture Lag: Read sys.dm_cdc_log_scan_sessions
CDC capture lag measures work committed at the source that the capture process has not yet exposed. Compare known markers, scan sessions and captured LSNs, and distinguish capture progress from a downstream consumer reading the changes.
SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines
sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.
SQL SERVER – Location of Resource Database in SQL Server Editions
The Resource database contains SQL Server system objects. I use version-specific guidance to locate its files and plan recovery.
Getting Started in the SQL Server Community
Join the SQL Server community through user groups, online events, helpful answers, and a first short talk built from real practice.
SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010
SQL Server 2008 R2 has a release date in May 2010. Here is what is new, from Master Data Services to StreamInsight, and why it matters to you.
The First Hour on a Server Nobody Can Explain
Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.