Additional Articles

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

Analysis Services 2005 protocol - XMLA over TCP/IP

by Additional Articles

sqljunkies.com

Analysis Services (SSAS)

It has been widely publicized that Analysis Services 2005 uses XML for Analysis 1.1 (XMLA) as its only network protocol for communication between client and server. XMLA is standard public protocol defined by XMLA council and full description can be found at www.xmla.org

2005-12-26

1,771 reads

Discuss

Database Geek of the Week - Peter DeBetta

by Additional Articles

Redgate

Interviews

Peter runs DeBetta Software , a consulting firm that develops data-driven enterprise solutions. He is also a programming instructor for Wintellect, a training and consulting company, and a frequent speaker on SQL Server and other subjects.

2005-12-23

1,475 reads

Discuss

SQL Server 2005 Express Edition User Instances

by Additional Articles

MSDN Communities

compact edition

This paper describes user instances in SQL Server 2005 Express Edition and how you can use them to simplify adding database functionality to your Visual Studio projects.

2005-12-22

3,002 reads

Discuss

All authors

Additional Articles

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

Analysis Services 2005 protocol - XMLA over TCP/IP

Database Geek of the Week - Peter DeBetta

SQL Server 2005 Express Edition User Instances

Blogs

The Benefits of Teaching

Power BI, Excel, OneLake – Dreams Do Come True!

The Book of Redgate: What Our Staff Says

Forums

Deny Connect problem

Website Stability 2025/12/05

403 Forbidden

Question of the Day

Fabric Mirroring