(graz) A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client’s paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP
Author: SSWUG Research
DLL Hell and Version Policy
(Anuj Sahu) The heading of this article reflects that there are two topics and DLL hell is the problem and Version Policy is the solution to problem. Below is stated the problem with DLL hell is and how a developer can overcome this problem by defining his or her own Version policy.
Forced Parameterization in SQL Server 2005
(Brad M. McGehee) One of the main benefits of using a stored procedure to execute Transact-SQL code is that once a stored procedure is compiled and executed the first time, the query plan is cached by SQL Server. So the next time the same stored procedure is run (assuming the same connection paramet
SQL Server bulk-logged recovery
(Greg Robidoux) SQL Server offers three types of recovery models: simple, full and bulk-logged. These models offer varying levels of recovery for restoring your databases from your backups. Bulk-logged recovery advantages include minimal space requirements for transaction logs and the best performan
IDS locking, Part 2: Understand locking behavior and analyze lock conflicts in IDS
(Eric Herber) This is the second part of a two-part article talking about locking mechanisms in IBM’s strategic data server, Informix Dynamic Server (IDS). IDS is an optimal choice for high-end online transaction processing (OLTP) and embedded solutions. This article helps you to understand locking
XML file/stream processing
(Lymington) This DLL provides routines to manipulate XML files. The set provided is not all-singing-and-dancing, but a useful, small collection. Several co-operating executables living off a common XML file may find their operating parameters and set parameters for others.
Manually creating a Logical Change Record (LCR)
(Lewis Cunningham) I’ve been doing quite a bit recently with Oracle Streams. I recently had the need to create some test data in LCR format. If you have manual control of your LCR, you can test specific data issues a lot easier.
The Role of the DBA Related to Insider Threats and Regulatory Compliance
(Alex Polishchuk and Michael Procopio) We all remember too well the cases of Enron and WorldCom. In light of those cases, the government has created new laws commonly known as the Sarbanes-Oxley (SOX) Act of 2002 to protect investors and insure the accuracy of corporate disclosures. SOX-type regulat
The Geronimo renegade: Web 2.0 report card
(Nicholas Chase) Web 2.0 is still one of the computer industry’s hottest buzzwords, despite widespread disagreement as to what the term actually means. This month, The Geronimo renegade cuts through the hype and looks at the Apache Geronimo project as both an enabler of Web 2.0 applications and as a
How to use an XML data source in ASP.NET 2.0
(Sundar) XML data is a good alternative to relational database, especially for web applications. For example, web services commonly use XML to exchange information. And web feeds, which provide frequently updated information such as news stories or blog updates, almost always use XML. The topic that