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.

Mathematical Auditing Of Email Broadcasts

by R Glen Cooper

SQLServerCentral.com

Database Mail

In a sequel to his previous article on referential integrity, Glen Cooper looks at some ways to analyze who is getting emails based on a database system.

Time Off

by Steve Jones

SQLServerCentral.com

Editorial

It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.

How to find out how long a SQL Server backup took

by Additional Articles

MSSQLTips.com

Backup and restore

Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken.

Overview of the Analysis Services Development and Management Environments

by Additional Articles

TDAN

Analysis Services (SSAS)

SQL Server 2005 introduces a rich set of tools supporting the development and management of Business Intelligence applications. This includes applications using Analysis Services (OLAP and Data Mining), as well as Reporting Services and Data Transformation Services (DTS).

The Pros and Cons of Stored Procedures

by Steve Jones

SQLServerCentral.com

Blogs

I saw this mentioned on Twitter, and watched it while doing some light editing and scheduling. It’s from TechEd 2009 in LA, and includes a number of MVPs and consultants and even a Microsoft SQL Server program manager. It’s a video, running about 55 minutes...

Do You Have a Problem?

by Steve Jones

SQLServerCentral.com

Editorial

Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.

Introduction to Bitmasking in SQL Server, Part 2

by Lee Everest

SQLServerCentral.com

Bit Masking

In part 2 of his series, Lee Everest expands upon bitmasking and integrates this with the SQL CLR.

Mastering SQL Server Profiler - Part 6: Creating Custom Traces

by Brad McGehee

SQLServerCentral.com

Video

The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.

Attribute Discretization: Using the “Equal Areas” Method

by Additional Articles

Database Journal

Analysis Services (SSAS)

Get hands-on exposure to the use of the "Equal Areas" discretization method in Analysis Services. Join BI Architect Bill Pearson as he continues to explore Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.

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

Mathematical Auditing Of Email Broadcasts

Time Off

How to find out how long a SQL Server backup took

Overview of the Analysis Services Development and Management Environments

The Pros and Cons of Stored Procedures

Do You Have a Problem?

Introduction to Bitmasking in SQL Server, Part 2

Mastering SQL Server Profiler - Part 6: Creating Custom Traces

Attribute Discretization: Using the “Equal Areas” Method

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener