(Itzik Ben-Gan)Secrets are always intriguing, and programming back doors—secret entrances into application code—are no different. I’m covering T-SQL back doors lately for several reasons. First, programmers frequently use undocumented features, which you need to be familiar with in case you need to
Other News
Performance Tuning SQL Server Joins
One of the best ways to boost JOIN performance is to limit how many rows need to be JOINed. This is especially beneficial for the outer table in a JOIN. Only return absolutely only those rows needed to be JOINed, and no more.
ASP.NET Whidbey Overview
(Steven Smith) ASP.NET was first previewed at PDC in July of 2000. The first beta followed about a year later and the actual RTM of ASP.NET 1.0 came in February of 2002. ASP.NET 1.1 and Visual Studio 2003 came about a year after that, but did not include many feature updates.
DB2 SQL Procedural Language: Using Flow of Control Statements
(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) In this chapter, you will learn: –how to use the compound statement; –how to use labels in both compound statements and loops; –how to use the two conditional statements (IF and CASE); –h
Fundamentals of Programming in PL/SQL
(Benjamin Rosenzweig and Elena Silvestrova) In most languages, you have only two sets of characters: numbers and letters. Some languages, such as Hebrew or Tibetan, have specific characters for vowels that are not placed in line with consonants. Additionally, other languages, such as Japanese, have
MSSQL Server 2000 Reporting Services: The Authoring Phase: Overview Part II
(William Pearson) In our last article, The Authoring Phase: Overview Part I, we began an overview of the first of the main phases of the enterprise reporting life cycle. We introduced the article with observations surrounding the objectives of the MSSQL Server 2000 Reporting Services series, as well
Replication Between Adaptive Server Enterprise and Microsoft SQL Server
This document describes the steps required to configure replication from Adaptive Server Enterprise (ASE) to Microsoft SQL Server (MS SQL Server), and from MS SQL Server to ASE. These steps involve configuring the following products: a) ASE b) Replication Server c) DirectConnect for MS S
Five XSLT 2.0 Features that Simplify XML Document Transformations
(Jinyu Wang) XSLT is a powerful language that has been widely used to transform XML documents. However, XSLT in its current 1.0 version has limitations that can make writing stylesheets difficult and complex. In this Technical Article, I will describe five new features in XSLT 2.0 that will help ove
Learn how to write DB2 JDBC tools in Jython
(Victor Yang) DB2 Universal Database (UDB) JDBC driver has been a solid and proven technology supported by IBM. Jython is the 100% pure Java implementation of Python programming language. First we will tell you why Jython is powerful, handy and fun in writing DB2 JDBC tools. Then we will show yo
Null Functions (Arent those Meetings?)
(Dinesh Priyankara) Definitely you must have read the article by James Travis’s called =NULL AND IS NULL that is very informative. After reading the article, I really wanted to gather more related information that are used in day-to-day operation and ended up with a couple of things. Then, as usual,