Additional Articles

SQL Server 2008 Failover Clustering

by Additional Articles

SQLCAT

Clustering

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.

2009-10-02

3,698 reads

Explore XML Data Type in SQL Server

by Additional Articles

Database Journal

SQL Server 2005 and 2008 provide native XML data type and provides extensive support for XML data processing. The easy conversion from XML to a relational table provides a way for set-based updates based on user input.

2009-10-01

3,838 reads

Generating SQL Scripts using Windows PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell.

2009-10-01

3,940 reads

Energy Intelligence

by Additional Articles

DMReview

Data Warehousing

Given that companies spend on average between 7 and 12 percent of their annual budgets on energy – a focus on reducing energy consumption can have significant bottom-line impact

2009-09-30

3,575 reads

Setting up Change Data Capture in SQL Server 2008

by Additional Articles

Builder.com

Change Data Capture (CDC)

Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system

2009-09-30

3,222 reads

Auto Generate an Hourly SQL Server Profiler Trace File

by Additional Articles

MSSQLTips.com

SQL Trace

I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005.

2009-09-29

3,975 reads

How to Calculate Data Warehouse Reliability

by Additional Articles

DMReview

Data Warehousing

This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.

2009-09-29

4,823 reads

Architectural Options for Asynchronous Workflow

by Additional Articles

Microsoft MSDN

This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.

2009-09-28

2,417 reads

Introduction to Cube Storage

by Additional Articles

Database Journal

Analysis Services (SSAS)

BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.

2009-09-28

3,549 reads

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

by Additional Articles

SQLCAT

Backup and restore

Database sizes increase constantly, as do requirements for access and availability. At the same time, it is more important than ever to have a fast and reliable backup and recovery plan in place. This document discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs). Using a real-world example, it demonstrates how to make the best use of the backup and restore features of SQL Server 2008 to help create a fast and reliable backup and restore plan for VLDBs over the network.

2009-09-25

2,989 reads

All authors

Additional Articles

SQL Server 2008 Failover Clustering

Explore XML Data Type in SQL Server

Generating SQL Scripts using Windows PowerShell

Energy Intelligence

Setting up Change Data Capture in SQL Server 2008

Auto Generate an Hourly SQL Server Profiler Trace File

How to Calculate Data Warehouse Reliability

Architectural Options for Asynchronous Workflow

Introduction to Cube Storage

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

Blogs

A New Word: the Kinder Surprise

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Future IT Roles – Agentic Architect and AI Boom!!

Forums

There's Too Much to Learn

How to Calculate Distance Between Coordinates in SQL Server

SSoL Support on the OS

Question of the Day

SSoL Support on the OS