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.

SSIS Usage of Checkpoint File

In this article Dinesh Priyankara explains how Checkpoint files can be used in a SSIS package so that the package can be restarted from the point of failure.

Developing Report Navigation and Drilldown

This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services for Dummies, by Mark Robinson. Learn how to produce interesting navigation and drill down reporting using the basic tools provided within SQL Server 2005 Reporting Services.

New Data Types in SQL Server 2008 Part 3

This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.

Storing Images and BLOB files in SQL Server Part 2

Part two of this article focuses on using the SQL Server Binary data type to store small image files.

The Stewardship Approach to Data Governance: Ch. 6

This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.