(Marcin Policht) Extensive ETL (Extraction, Transformation, and Loading) capabilities that SQL Server 2005 Integration Services are based on, deliver such essential functionality as the combination and cleanup of data originating from heterogeneous sources or scheduling and coordination of activitie
Author: SSWUG Research
Difference between instance and session
(Brian Peasland) What is the difference between an instance and a session? (R)
Embedded SQL with Pro*C
(Sai Kiran Gummaraj) Embedded SQL is a superset of Sybase’s T-SQL or Oracle’s PL/SQL that lets you place SQL statements in application programs written in languages such as C and COBOL. Pro*C allows the C programmer to write database access code fast and with less of a learning curve. For people who
User Defined Functions in DB2
(Rosmarie Peter) User Defined Functions (UDFs) enable users to write their own functions which can be used in SQL statements. This article describes how this option can be used for DB2 UDB for z/OS and OS/390. The difference between UDFs for DB2 mainframe installations and DB2 in Linux, Unix and th
Forensic Tamper Detection in SQL Server
(Amit Basu) This document presents a method of tamper detection of sensitive data. SQL Server provides many mechanisms to authenticate and authorize users to perform certain activities in the database. These mechanisms ensure that other than those with proper authentication, no one else can view or
Handle distributed transactions with federated two-phase commit in WebSphere Federation Server Version 9.1
(Amy Chang, Simon Harris and Frankie Sun) A federated system is a distributed database management system that enables users to access data in a diverse data source environment, as if all data resides in a single database. A federated transaction is a transaction that includes read or write access to
Debugging ASP.NET AJAX Applications with VS.NET 2005
(Dan Wahlin) Debugging is a key skill that every developer has to learn to become productive. However, how do you debug ASP.NET AJAX applications and client-side JavaScript? In this video tutorial I walk through a few required steps to enable debugging and show how to use tools such as Script Explor
Introduction to Using SQLite with PHP 5
(Alejandro Gervasio) If you use PHP 5 to build web-based applications that access a database, you might want to consider SQLite. A “lighter” option than MySQL, this database may still suit your purposes if you don’t need all of MySQL’s bells and whistles. This three-part series covers many of SQLite
Dealing with ASP.NET’s view state
(Tony Patton) One of the more exciting features of ASP.NET is the view state concept. It allows you to save Web Form properties across different server requests. While this simplifies maintaining data on a Web page, it does have disadvantages. This week, I examine view state, as well as enhancements
Architecting for Data Security
(Don MacVittie) IT pros must understand and address the liability associated with granting unfettered access to sensitive data. We explore methods for safeguarding private information while keeping it usable for applications.