(Don Schlichting) Included with SQL Server 2005 is a group of interrelated applications, collectively known as SQL Server Reporting Service (SSRS). SSRS includes all the development and management pieces necessary to publish end user reports in HTML, PDF, Excel, and CSV formats. Originally relea
Author: SSWUG Research
Extend the SSIS Script Task with Your Own .NET Class Library
(Jeffrey Juday) If you’re familiar with SQL Server 2005 Integration Services (SSIS) you’re probably aware that SSIS includes vast improvements over SQL Server 2000 Data Transformation Services (DTS). Among these improvements is extensive .NET support, which comes in many forms. For example, the SSIS
Eliminate Unnecessary Code and Boost Performance with C# 2.0 Iterators
(Mark Strawmyer) A design pattern is a solution that focuses on solving a particular problem or issue that commonly occurs. Design patterns are often associated with object-oriented programming, but they are not exclusive to it. Non-computing disciplines also have concepts similar to the design patt
ISV Touchdown Web Seminar: Unit, Web, and Load Testing with Visual Studio 2005 Team System
During this session, our presenter will cover the breadth and depth of the unit, web, and load testing technologies that are bundled with Visual Studio Team System. First, we will take a look at Unit Testing, how you generate Unit test skeleton classes from existing source code, how you modify the u
What’s In A Name – Naming and Idenifying Oracle Databases and Instances
(James F. Koopmann) Identification of the database you are currently working on can sometimes be somewhat confusing. Take a look at the internal parameters that Oracle keeps and see if you can uniquely identify the database you are currently working on.
Creating XML with Ruby and Builder
(Michael Fitzgerald) Since the advent of Ruby on Rails last year, interest in the Ruby programming language seems to have grown steadily. Rails has helped the masses see what Ruby is: an elegant, easy-to-learn, and fun-to-use language, suitable even for industrial-strength applications. Ruby has bee
Returning Ranked Results with Microsoft SQL Server 2005
(Scott Mitchell) In early November 2005, Microsoft launched three new product lines: Visual Studio 2005, SQL Server 2005, and the .NET Framework version 2.0 (which includes ASP.NET version 2.0). SQL Server 2005 is the newest version of Microsoft’s database platform, with the last major SQL Server re
ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part II
(Muhammad Mosa) In this article we will continue our talking about ADO.Net 2.0 Enhancements. Here we will explore: –Bulk copy –Notifications (not SQL Server Notification Services but something else as we will see)
IBM Recovery Expert for Multiplatform V2 Usage Guide
(Whei-Jen Chen, Hiromichi Shinozaki, Kevin Taylor, Marcia Miskimen and Yasir Warraich) IBM DB2 Recovery Expert for Multiplatforms (RE) provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. Recovery Expert
Crossing Over/Breaking the DB2 Platform Barrier
The popularity of DB2 UDB running on distributed platforms continues to grow. The sudden growth and popularity of DB2 on distributed platforms has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinking staffs. Many DB