Microsoft SQL Server 2008 - Change Data Capture – Part 2

Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.

The Stewardship Approach to Data Governance: Ch 7

This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.

New Isolation Levels Available in SQL Server 2005

One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.

RTM

SQL Server 2008 - Table Valued Parameters

In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.

Writing Outer Joins in T-SQL

Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.

Featured Blog: iFTS Transparency – dm_fts_parser

In this post on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser.

Measures

Featured Blog: SQL Server 2008 – iFTS Introduction

This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008 from MVP Simon Sabin. We'll continue this series on with an in depth look at this feature.

MDX Numeric Functions: The Min() Function

Business Intelligence Architect Bill Pearson introduces the numeric Min() function, and leads hands-on practice examples of its use.