(Marcin Policht) 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. While SQL Server 2005 offers a number of different w
Author: SSWUG Research
Visual Studio 2005 Hands-On Tutorial – Part 3
(David Catherman) This is the third part in a series of hands-on tutorials that will take you through all the steps to build a complete application using the new SQL Server 2005 database and Visual Studio 2005 IDE tools. This time you will be working with a Web interface to the application.
ASP.NET Tip: Create a BasePage Class for All Pages to Share
(Eric Smith) Something I’ve been doing with my ASP.NET applications is creating a shared Page class from which all my Web pages inherit. This allows all the pages to share common functions, settings, and so forth without having to do much work. In ASP.NET 1.1, I used the BasePage class to help contr
Dealing with the Dodgy GO Command
(Subramanyam Krishna Murthy) The GO command plays a very important role in Microsoft SQL Server. It signals the end of a batch of SQL statements and executes them as a whole. Seems simple enough. But using GO can be disastrous if you don’t understand its usage in a certain scenario.
FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data
When you copy or transfer Microsoft SQL Server 2000 data, you may experience one of the following problems: • You may receive an error message that resembles the following: 2002-11-07 14:53:06.29 spid52 Error: 1203, Severity: 20, State: 1 2002-11-07 14:53:06.29 spid52 Process ID 52 attempting to
The Viper is coming
(Philip Howard) The next release of IBM’s DB2 (for both z series and distributed systems), which is code-named ‘Viper’, will be generally available in the not too distant future: “mid-summer” for distributed systems, according to IBM. It is therefore appropriate to consider some of the new features
Digits to Charts
(Dmitry Khudorozhkov) This article presents several XSLT stylesheets for visualizing numerical data rows contained, as you may have guessed, within XML files. The article explains the details of stylesheet setup and the template design rationale.
Extend Constraints using Function Based Indexes
Function Based Indexes are a feature virtually every DBA and programmer will be using immediately — the ability to index functions and use these indexes in query. In a nutshell, this capability allows you to have case insenstive searches or sorts, search on complex equations, and extend the SQL lan
User-Defined Database Functionality
(Kuassi Mensah) Beyond the out-of-the-box built-in RDBMS functionality, you often need to extend the capabilities of your database by developing your own database-resident functionality, or data logic.
Parameterize Your Apps Using XML Configuration In The .NET Framework 2.0
(Bryan Porter) Applications are complicated. Even the simplest software invariably contains numerous settings that have to store some sort of value in order to function at even a basic level. Database-driven applications usually have the luxury of storing the lion’s share of their configuration info