(Alexander Kuznetsov) Let us consider a very common situation. A GUI application issues a query, then the first 25 rows from the result set are displayed on screen. If the user presses Page Down, then the next 25 rows will be displayed, and so on. It is well known that FETCH FIRST 25 ROWS and OPTIMI
Other News
Introducing XIP to the Network Edge – XML Intrusion Prevention
With offices in Boston and Salt Lake City, a company called Forum Systems has devised what it calls a “XML-Sentient” suite of content security infrastructure “that actively guards information as it moves between and within enterprises – at the origin, during transmission, and after it reaches its de
MSSQL Server 2000 Reporting Services: The Authoring Phase: Overview Part I
(William Pearson) This is the second article of the series MSSQL Server 2000 Reporting Services. The series is designed to introduce MSSQL Server 2000 Reporting Services (“Reporting Services”), with the objective of giving a preview of its features, as well as sharing my conviction in its role as a
Web Data Administrator
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser: –Create and edit databases in Microsoft SQL S
SQL Injection – Part 1
(Randy Dyess) It seems sometimes that every time you turn around you see a new article concerning SQL Injection. Recently when I was brushing up on my ASP to create www.Database-Security.Info, I found out why SQL Injection seems to be a reoccurring problem within ASP pages. Most of the basic example
For Certain Eyes Only
(Sasirekha Cota) Every business needs to protect its data. But the old practice of controlling access at the table level is coming up short as a solution to data security requirements. Businesses increasingly need more granular access — and they need a manageable way to provide it.
Troubleshooting .NET Applications – Implementing an XslTransform wrapper to trace and profile XSLT transformations Part 1
(Karthik Ravindran) Tests executed and results obtained to verify the execution and performance of XSLT transformations during development and testing are often not fully representative of production use case scenarios encountered in a live environment. Troubleshooting XSLT transformations that perf
Code Generation Templates Using XML and XSL
(Cristian Georgescu) XML is indisputably the long-awaited lingua franca for defining and transmitting structured data. With a little help from XSL, it can also generate C++ code for you.
Overview of DB2’s XML Capabilities: An introduction to SQL/XML functions in DB2 UDB and the DB2 XML Extender
(Cindy Wong) This article will introduce you to the SQL/XML functions available with DB2 UDB version 8 and the DB2 XML Extender.
Managing Exceptional Behavior, Part 1
(Steven Feuerstein) Many programmers don’t take the time to properly bulletproof their programs. Most of us find it hard enough—and more than enough work—to simply write the code that implements the positive aspects of an application: maintaining customers, generating invoices, and so on. You wr