Additional Articles

Use SQLIOSIM to simulate SQL Server disk activity

by Additional Articles

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-03-30

2,768 reads

Discuss

Black Belt Administration: Performance Dashboard for Microsoft SQL Ser

by Additional Articles

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

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

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-03-26

1,438 reads

Discuss

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

by Additional Articles

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-03-22

2,943 reads

Discuss

Introduction to Data Warehousing Part 1

by Additional Articles

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-03-21

3,746 reads

Discuss

Mastering Enterprise BI: Time Intelligence Pt. II

by Additional Articles

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-03-20

2,669 reads

Discuss

Designing A Data Warehouse: Part 1 Dimension Types

by Additional Articles

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-03-19

4,753 reads

Discuss

Different forms of CrossJoin

by Additional Articles

SQLServerCentral

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.