In this article, we are continuing coverage of Foreach Loop container functionality, by discussing different types of loop enumerators. So far, we have presented methods for working with files in a folder as well as records in a recordset (using Foreach File and Foreach ADO enumerators, respectively). Our next enumerator is based on the SQL Server Management Objects technology (hence it is referred to as the SMO enumerator), which is the SQL Server 2005, .NET-based management framework providing replacement for COM-based DMO (Distributed Management Objects) that served an equivalent role in earlier versions of SQL Server.

Business Intelligence with SQL Server Reporting Services - Part 3

by Additional Articles

Other

Development

Reporting Services exposes web methods via XML web services to facilitate cross platform reports management and delivery. It's a simple SOAP based API makes it very easy to add full functionality of reporting services in your application. It provides a set of rendering and viewing functions as well as complete set of management routines. Reporting services web service is the one stop shop for subscription, management, publishing, scheduling and rendering reports.

How do you spell S-Q-L?

by Sean McCown

SQLServerCentral.com

Miscellaneous

We've spent quite some time investigating career issues for SQL Server DBAs lately. I've received quite a few emails from friends on their adventures in interviewing and now Sean McCown shares an experience he had interviewing a few prospective DBAs.

Powerchute 6.x User's Alert

by Steve Jones

SQLServerCentral.com

Rants

If you run PowerChute 6.x on any of your servers, be very careful of patching and rebooting them. You might end up with more downtime and problems than you expected.

Business Intelligence with SQL Server Reporting Services - Part 2

by Additional Articles

Other

Development

A look at Parameterized reports, stored procedures to retrieve data and the Report Viewer.

Jacksonville - 2005 Code Camp

by Press Release

SQLServerCentral.com

SQLServerCentral

If you are near the Jacksonville, FL area on Saturday, August 27th, check out this code camp with our own Brian Knight. Get the chance to learn some great development from Brian and a few other experts.

The Basics of Cryptography Part 2

by Michael Coles

SQLServerCentral.com

Miscellaneous

Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.

Performance Monitoring by Internal Fragmentation Measurement

by Koby Biller

SQLServerCentral.com

Performance Tuning

It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.

Enabling Drillthrough in Analysis Services 2005

by Additional Articles

MSDN Communities

Analysis Services (SSAS)

Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.

Single Point of Administration

by Jonathan Stokes

SQLServerCentral.com

Miscellaneous

Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.

SQL Server 2005 - SQL Server Integration Services - Part 6

Business Intelligence with SQL Server Reporting Services - Part 3

How do you spell S-Q-L?

Powerchute 6.x User's Alert

Business Intelligence with SQL Server Reporting Services - Part 2

Jacksonville - 2005 Code Camp

The Basics of Cryptography Part 2

Performance Monitoring by Internal Fragmentation Measurement

Enabling Drillthrough in Analysis Services 2005

Single Point of Administration

Blogs

Flyway Tips: AI Generating Migration Script Names

The Book of Redgate: Get the right stuff done

Runing tSQLt Tests with Claude

Forums

No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

The Long Name

Question of the Day

The Long Name