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.

Foreign Keys

by Ravi Lobo

SQLServerCentral.com

Advanced

Foreign keys are an important part of a relational database. New author Ravi Lobo takes a look at foreign keys from the perspective of a new DBA with some scripts to help you ensure your database is setup correctly.

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.

Usage Based Optimization in SSAS 2005

by Yaniv Mor

SQLServerCentral.com

Analysis Services (SSAS)

One of the difficult parts of developing anaylsis services cubes is determining which aggregations should be chosen. Yaniv Mor brings us the second part of his series and examines using Usage Based Optimization in SQL Server 2005.

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.

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’.

TheServerSide Debates: Stored Procedures v Parameterized Queries

by Bilal Ahmed

ASPToday

Advanced

Let me start by stating some disclaiming remarks. I'm not against stored procedures in general, I find that the choice why procedures should be used, should be based on proper facts, not on claims without any proof.

Introduction to the ADO Connection Object

by Andy Warren

SQLServerCentral.com

Miscellaneous

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?

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.

Achieving Server Redundancy at Remote Offices

by Mark Cook

SQLServerCentral.com

Disaster Recovery (DR)

Everyone wants a highly available system, but achieving 4 or 5 9s of uptime is hard to do. Especially when you have cost limitations. New author Mark Cook takes a look at how his company analyzed the challenges and which method they chose along with some implementation details.

SQL Server 2005 Integration Services - Transaction Support - Part 25

Foreign Keys

Talking Technical

Usage Based Optimization in SSAS 2005

Load 1TB in less than 1 hour

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

TheServerSide Debates: Stored Procedures v Parameterized Queries

Introduction to the ADO Connection Object

Integrating Electronic Payment Processing into

Achieving Server Redundancy at Remote Offices

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

Get a Range of Sequence Values: #SQLNewBlogger

The Agent Era: When “How do I…?” Replaces “Where do I click?”

Forums

Hiring: Financial SQL Systems Administrator

Job Opening for ERP Systems Administrator - Hybrid

data compare between 2 tables with same structure for any changes after etl run

Question of the Day

Creating a JSON Document II