Advanced SQL Server 2008 Extended Events with Examples

In the previous article we learned about SQL Server 2008 Extended Events terminology, components and took a look at a simple example. In this article we'll take a deeper look with some more complex examples.

Introduction to SQL Server 2008 Extended Events

SQL Server 2008 Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events.

Streaming Data Into SQL Server 2008 From an Application

Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.

Using SQL Server to Build a Hub-and-Spoke Enterprise Data Warehouse Architecture

Scalable, cost-effective EDW implementation is an elusive goal for many large organizations. Three common approaches include centralized EDW the “monolithic” approach, decentralized collections of data marts, and attempts at hub-and-spoke architectures that combine the previous two. With the acquisition of DATAllegro and the pending release of Project codename “Madison,” Microsoft is poised to deliver a unique and compelling Massively Parallel Processing (MPP) data warehouse solution that combines the best features of both EDW and decentralized data marts.

Connectivity Options for Microsoft SQL Server 2008 Integration Services

This white paper provides an overview of the connectivity options that are available for SQL Server 2008 Integration Services.

Maximum instances supported by SQL Server 2008

Database Encryption in SQL Server 2008

Inside the new replication features for SQL Server 2008

SQL Server 2008 features several replication improvements, and some are more compelling than others. Learn what's new with peer-to-peer topologies, merge replication and more.

Performance Testing SQL 2008’s Transparent Data Encryption

The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?

Auditing in SQL Server 2008

This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.