Additional Articles

Use SQLIOSIM to simulate SQL Server disk activity

by Additional Articles

Microsoft MSDN

Miscellaneous

I regularly use SQLIO.EXE to gauge the maximum throughput a disk subsystem can sustain. Recently Microsoft released SQLIOSIM.EXE to provide better results for this type of test. However they didn't release any documentation on the tool and I could never figure out what it was trying to tell me. It looks like they finally did release a Knowledge Base article on SQLIOSIM. Give it a spin. I'd be curious to hear what you think of the tool.

2007-03-30

2,768 reads

Discuss

Black Belt Administration: Performance Dashboard for Microsoft SQL Ser

by Additional Articles

Database Journal

Administration

Diagnose performance problems in MSSQL Server 2005 with a powerful new administration tool. BI Architect Bill Pearson provides hands-on guidance in installing and using this powerful new dashboard / report pack, freely available to MSSQL Server 2005 users everywhere.

2007-03-29

3,678 reads

Discuss

The SQL Server helper table workbench

by Additional Articles

SimpleTalk

Advanced Querying

Robyn Page and Phil Factor demonstrate some set-based techniques for string manipulation and time interval-based reporting, which use helper tables rather than iterative logic or the dreaded cursor.

2007-03-28

2,039 reads

Discuss

How To Video: Creating a Proxy Account

by Additional Articles

JumpStartTV

Administration

In this session by Brian Knight, he shows you how to create a proxy account for SQL Server Agent to use. Proxy accounts and SQL Server 2005 credentials help you impersonate another Windows account in Agent.

2007-03-26

1,438 reads

Discuss

SQL Server 2005 Integration Services - Part 44 - Bulk Insert Task

by Additional Articles

Database Journal

Integration Services (SSIS)

Recent installments of our series dedicated to SQL Server 2005 Integration Services have discussed individual Control Flow tasks. This installment covers one of the few remaining items in this category, the Bulk Insert task.

2007-03-22

2,943 reads

Discuss

Introduction to Data Warehousing Part 1

by Additional Articles

JumpStartTV

Design and Theory

In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.

2007-03-21

3,746 reads

Discuss

Mastering Enterprise BI: Time Intelligence Pt. II

by Additional Articles

Database Journal

Design and Theory

BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.

2007-03-20

2,669 reads

Discuss

Designing A Data Warehouse: Part 1 Dimension Types

by Additional Articles

JumpStartTV

Design and Theory

In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.

2007-03-19

4,753 reads

Discuss

Different forms of CrossJoin

by Additional Articles

MSDN Communities

This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however.

2007-03-16

3,902 reads