(Ashley van Gerven) This little ASP.NET utility lets you run SQL queries against databases accessible to the webserver. Initially this started as a script to run queries against an Access database running a website without having to download it. Every now and then you might need to do maintenance ch
Author: SSWUG Research
Invoke UDFs that accept tables with SQL Server 2005’s APPLY operator
(Tim Chapman) A user-defined function (UDF) is a database object introduced in SQL Server 2000. It comes in two flavors: scalar-valued UDFs and table valued UDFs. A scalar-valued function returns a single value for each function call, while a table valued UDF returns a table recordset that can be jo
SQL Server 2005 Integration Services – Message Queue Task – Part 32
(Marcin Policht) After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, ranging from its innovative architecture, through main package design principles, along with debugging and deployment techniques, to security and performance consideration, we will focus no
SAN considerations for your SQL Server environment
(Hilary Cotter) SANs (Storage Area Networks) are playing an increasingly important role in SQL Server environments for several reasons. They include: –The increasing size of the average database –The increasing prevalence of clustered environments –Performance advantages of SANs –Storag
DB2 Content Manager V8.3 certification preparation series for Exam 443
(Kerensa Jablonka, Mary Desisto and Michael Lowe) This series of articles is designed to prepare you for taking the IBM DB2 Content Manager V8.3 certification exam 443. In addition, it provides a strong foundation for educating yourself on DB2 Content Manager, from understanding how to gather requir
Kewl DB2 for z/OS Version 8 Feature Part 6: Sequence Objects
(Willie Favero) Tonight I am offering up an opinion. I would like to hear your opinions on mine. Opinion on: Sequence objects, delivered in V8, are a better choice than identity columns from back in V7. Opinion off
The Baker’s Dozen: 26 Productivity Tips for Managing Data (Part 1 of 2)
(Kevin S. Goff) Developers frequently must work with data at different levels, with different tools, and in different forms. This article is the first in a two-part series on some of the more common data challenges that developers face. In Part 1 of this article, I’ll cover some capabilities in ADO.
Data Warehousing, Part 1: Building the Virtual Organization
(Andrew K. Burger) Since the technology of data warehousing has risen to become common currency, it has been at the epicenter of leading-edge advances in database, data analysis and decision support systems theory and practice — and for good reason.
Handle DOM streaming protocols with the Remote Events for XML (REX) 1.0 specification
(Peter V. Mikhalenko) The Remote Events for XML (REX) specification defines an XML syntax for the transmission of Document Object Model(DOM) events in such a way as to be compatible with streaming protocols. It enables one endpoint to interact remotely with another endpoint holding a DOM representat
The Ins and Outs of XML and DB2 for i5/OS
(Hernando Bedoya) The next version of non-iSeries DB2 Products from IBM are planning to announce new enhancements forXML integration. DB2 UDB for iSeries will not be part of this announcement, at least for the time being. However, there are many other ways to integration DB2 UDB for iSeries with XML