Additional Articles

Usage-Based Optimization in Analysis Services 2005

by Additional Articles

Database Journal

Analysis Services (SSAS)

In this lesson, we revisit usage-based optimization, a subject that we undertook in my article MSAS Administration and Optimization: Simple Cube Usage Analysis, in September of 2003, and MSAS Administration and Optimization: Toward More Sophisticated Analysis in October of 2003. In the earlier articles, we discovered that, among several tools that Microsoft SQL Server 2000 Analysis Services offered us to assist in the maintenance and optimization of our cubes, two of these tools, the Usage Analysis Wizard and the Usage-Based Optimization Wizard, leveraged the usage-based optimization features of Analysis Services.

2006-01-10

1,810 reads

Discuss

PART 8: ESTIMATION

by Additional Articles

TDAN

Advanced

Data modeling is no doubt one of the most important and challenging aspects of developing, maintaining, augmenting and integrating typical enterprise systems. More than 90% of functionality of enterprise systems is centered round creating, manipulating and querying data. It therefore stands to reason that individuals managing enterprise projects should leverage on data modeling to execute their projects successfully and deliver not only capable and cost effective but also maintainable and extendable systems

2006-01-09

2,421 reads

Discuss

SQL Writer in SQL Server 2005

by Additional Articles

TechNet Blogs

Administration

Definitely written for backup ISVs, but this is an interesting architectural article as to how the backup systems will work in SQL Server 2005.

2006-01-06

2,193 reads

Discuss

THE ROLE OF DATA DICTIONARY

by Additional Articles

TDAN

Design and Theory

IT leaders from enterprises around the world have realized that acquiring and implementing commercial off-the-shelf (COTS) application packages is a smarter thing to do, than the traditional approach of developing home-grown applications. This may not be the fit-for-all solution, but it makes sense from a cost, time to market and resource standpoint. Selection and acquisition of the software package is just the first step. How the software package brings value through successful implementation, is critical to the business. Internal groups as well as industry analysts will closely watch COTS package implementation in the organization.

2006-01-05

2,981 reads

Discuss

Clustered Indexes in SQL Server: Things You Need to Know

by Additional Articles

SQL Server Performance

Indexing

This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I'll also give you some tips on how to use them in a not so obvious context.

2006-01-04

5,922 reads

Discuss

Cursors and embedded SQL

by Additional Articles

Redgate

Advanced Querying

In the days when I contentedly cut procedural code, I was puzzled by the visceral rages of the database specialists; they were like the ship’s cook occasionally going berserk with a meat-cleaver. After I switched to database work, I realized why.”

2006-01-02

3,504 reads

Discuss

Interview with Brian Knight

by Additional Articles

PASS

Interviews

Our very own Brian Knight interviewed by PASS.

2005-12-30

2,121 reads

Discuss

Using ITWIZ.EXE to Automate Index Analysis

by Additional Articles

PASS

Performance Tuning

This process uses ITWIZ.EXE the command line version of the Index Tuning Wizard. SQL trace file information is stored in a table on production then transferred to a non-production server. ITWIZ is then run against the transferred trace data resulting in a UNICODE SQL script. This script has index creation and deletion information as well as script parameters in a remarks section.

2005-12-29

1,973 reads

Discuss

How to Set Up a SQL Server Stress Test Environment in 8 Steps: Lessons

by Additional Articles

SQL Server Performance

Performance Tuning

This article is the third in a series of four where I share my findings on baselining, monitoring, stress testing and performance tuning. It builds on the foundations of my previous articles on baselining and monitoring.

2005-12-28

3,845 reads

Discuss

SQL Server 2005 Integration Services, Part 2: Developing Custom Compon

by Additional Articles

MSDN Communities

Integration Services (SSIS)

The first phase of Project REAL included the migration of existing SQL Server 2000 DTS packages to SQL Server 2005 Integration Services (SSIS) for a large electronic retailer. One source of information for the data warehouse was from TLog files, which contained data from point-of-sale cash registers in stores. TLog files store data in packed decimal format. To extract and transform this data into a format suitable for loading into the relational data warehouse tables, it was necessary to unpack and parse the files. To achieve this, custom pipeline components were implemented to read and transform the data by extending the SSIS object model. This paper discusses what we learned while implementing the pipeline components for extracting and parsing data from the TLog parser

2005-12-27

2,067 reads

Discuss

All authors

Additional Articles

Usage-Based Optimization in Analysis Services 2005

PART 8: ESTIMATION

SQL Writer in SQL Server 2005

THE ROLE OF DATA DICTIONARY

Clustered Indexes in SQL Server: Things You Need to Know

Cursors and embedded SQL

Interview with Brian Knight

Using ITWIZ.EXE to Automate Index Analysis

How to Set Up a SQL Server Stress Test Environment in 8 Steps: Lessons

SQL Server 2005 Integration Services, Part 2: Developing Custom Compon

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

BCA KCP Pasar Minggu Telpon/WA:08137887595

BCA KCP Kas Pondok Labu Telpon/WA:08137887595

BCA KCP Pluit Kencana Tlpn/Wa 0853.7373.7551

Question of the Day

Increase Deadlock Detection