(Allan Mitchell) Performing a LEFT OUTER JOIN in TSQL is easy. The same logic in StreamInsight requires a little more work. In this presentation I show exactly how you can perform a LEFT OUTER JOIN on your event streams.

(Kalen Delaney) When SQL Server first introduced table and index partitioning in SQL 2005, it was the same version that all the metadata changed. So I decided that I could learn a lot about metadata and a lot about the organization and storage of partitions if I tried to write a query, and then a vi

(Ashish Kumar Mehta) I have installed a new instance of SQL Server 2008 Reporting Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How do I manage the Reporting Services features in SQL Server 2008?

(Dinesh Asanka) According to the “Data Quality and the Bottom Line: Achieving Business Success through a Commitment to High Quality Data.” The Data Warehousing Institute. Report Series 2002, data quality problems cost U.S. businesses more than $600 billion per year.

“Foreign key constraint” is one of the most useful database features. Every developer should know about this if they need to link data from one table to another. It is useful if you are establishing relationships between tables.

(Ken Lassesen) This is the first part of a series of posts about the data collector in SQL Server 2008. The data collector captures key Windows Performance Monitor counters and internal SQL Server counters every minute in a SQL Server database. In this post, I’ll show you how to use the data collect

(Marcin Policht) A database administrator can create ad-hoc packages to implement ETL via SSIS or use a method based on software programming principles. Ad-hoc packages may seem advantageous but can lead to duplication of effort. Learn how to implement the second of these options by taking advantage

(Tim Chapman) Windows PowerShell functionality is embedded in SQL Server 2008. PowerShell can be invoked from SQL Server Management Studio so that you can easily take advantage of its SQL Server functionality.

(K. Brian Kelley) I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don’t want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what’s the best way to extrac

This articles explores how you can work with filtered models, a powerful new feature introduced in SQL Server 2008 that allows you build models on slices of a mining structure.