Additional Articles

SQL Server 2005 Integration Services - Transaction Support - Part 25

by Additional Articles

Database Journal

Integration Services (SSIS)

The latest article in our series discusses improvements in the transactional support implemented in SQL Server 2005 Integration Services. The more granular scope of transactions, which now can be assigned to arbitrarily designated Control Flow tasks and containers, makes it is possible to limit their impact or execute several of them in parallel. However, even with this improved functionality, you need to keep the blocking issues they might potentially introduce in mind.

2006-06-01

2,138 reads

Discuss

Talking Technical

by Additional Articles

Redgate

Miscellaneous

Should IT managers understand technical issues, or is a full appreciation of the technology somehow unworthy and unnecessary for senior staff? In such a rapidly changing industry where fortunes are made and lost by attempting to exploit gaps in the market too thin to see with the naked eye, the answer would seem obvious. However, I have repeatedly come across amazing gaps in the technical knowledge of managers.

2006-05-31

2,425 reads

Discuss

Load 1TB in less than 1 hour

by Additional Articles

Other

Development

This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-H tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput.

2006-05-30

2,290 reads

Discuss

Don't use stored procedures yet? Must be suffering from NIHS

by Additional Articles

Other

Advanced

At just about every talk I give I always try to make several consistent statements. One of which is: ‘Whenever possible use stored procedures to access your data’.

2006-05-29

3,437 reads

Discuss

Integrating Electronic Payment Processing into

by Additional Articles

Other

Miscellaneous

This is a good explanation on how to acctually bill a customer for your service over a credit card in your web application.

2006-05-26

2,841 reads

Discuss

SQL Server 2005 Integration Services - Package Execution - Part 24

by Additional Articles

Database Journal

Integration Services (SSIS)

Continuing our coverage of topics dealing with various aspects of managing SQL Server 2005 Integration Services packages, which we started with an overview of their storage and deployment, we now turn our focus to their execution.

2006-05-25

1,816 reads

Discuss

Building Data Mining Solutions with OLE DB for DM and XML for Analysis

by Additional Articles

Other

Data Mining

This article, published in the June 2005 issue of SIGMOD Record, provides an overview of SQL Server Data Mining from a standards perspective.

2006-05-24

2,097 reads

Discuss

Creating a Simple SQL Server 2005 Notification Application: Stock Quot

by Additional Articles

InformIT

SQL Server 2005

In this chapter, you'll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross the price targets they specify.

2006-05-23

3,059 reads

Discuss

Betting on Promotion

by Additional Articles

Redgate

Miscellaneous

Phil Factor on why he is happy to gamble on your career…

2006-05-22

2,852 reads

Discuss

Using SQL Server 2005 to document Sarbanes-Oxley compliance

by Additional Articles

Builder.com

Advanced

My CIO and I have looked at a number of commercial solutions for documenting Sarbanes-Oxley compliance. However, we decided to use SQL Server 2005's built-in tools to create our own "home-grown" auditing system.

2006-05-19

3,877 reads

Discuss

All authors

Additional Articles

SQL Server 2005 Integration Services - Transaction Support - Part 25

Talking Technical

Load 1TB in less than 1 hour

Don't use stored procedures yet? Must be suffering from NIHS

Integrating Electronic Payment Processing into

SQL Server 2005 Integration Services - Package Execution - Part 24

Building Data Mining Solutions with OLE DB for DM and XML for Analysis

Creating a Simple SQL Server 2005 Notification Application: Stock Quot

Betting on Promotion

Using SQL Server 2005 to document Sarbanes-Oxley compliance

Blogs

A New Word: Lilo

Learning Database Design and Power BI Performance

Free SQL Training: Dive into Databases This December!

Forums

Database Archive missing FK

SQL Server 2005 service fails to start

How to Repair Corrupt MySQL Tables

Question of the Day

The Funny Dynamic SQL