(Tibor Karaszi) You might know that we have some new options for backup and especially restore in SQL Server 2005. Below script was inspired by a newsgroup post regarding not being able to restore an old readonly filegroup backup into a new database.
Author: SSWUG Research
MSSQL/MSDE Server Folder Browser
(shandile) I have looked everywhere to get either some direction or help as for how to get lists of folders and drives of computer installed with Microsoft SQL server and/or MSDE from windows based application on remote computer connecting the server. I finally have drawn a solution to accomplish th
Beginning SQL Server Reporting Services Part 4
Here, in part 4, we focus on Report Definition Language (RDL). The definition of RDL provided by MSDN2 is succinct and hard to better, so I’ll use it here: "A report definition contains data retrieval and layout information for a report. Report Definition Language (RDL) is an XML representation o
Installing Tivoli System Automation for High Availability of DB2 UDB BCU on AIX
(David Toussaint) This IBM Redpaper documents an installation and configuration of IBM Tivoli System Automation on IBM AIX to provide high availability for a DB2 Universal Database (UDB) Balanced Configuration Unit (BCU). It provides the information that is needed to enable high availability quickly
XForms tip: Making a read-only control writeable
(Tyler Anderson) At times it is crucial to programmatically control the writability of data in your XForms. For example, if you’re browsing data in read-only mode (so modifications aren’t made by accident), and then you need to update or add new data, the read-only mode of the same controls will nee
DB2 Version 8 does a (re)balancing act with REORG
(Willie Favero) You’ve heard about the rebalance feature in DB2 Version 8 and now you would like more information about how to use it and how it works. Well, your answers can be found in the most recent issue of z/Journal Magazine. In the December/January 2007 issue distributed at SHARE this week i
Comparing strings with and without case sensitivity in VB.NET
(Irina Medvinskaya) Working with strings is a very important functionality in most applications. Your ability to effectively use the existing .NET functionality is vital for building solid applications.
Use PHP on System i, Part 2: Net.Data and PHP
(Margaret Myslinska, Andrew Nere, David Swenson, Gloria Velazquez, Kathryn Lamont and David Peraza) Compare PHP with the Net.Data server-side scripting language, which IBM develops with DB2. Understand the origins of the languages, their syntax differences, usage learning curves, database connection
Documenting the High Availability Environment
(Bob Gast) By deploying high availability (HA) technology, you can shrink disaster-induced system downtime to 20 minutes or less. You can also deliver uninterrupted system access while maintenance activities are being performed.
Database Independent Development using ASP.NET 2.0
(Jagadish Chaterjee) This article shows you how to develop database independent applications using ASP.NET 2.0. I shall also show you how to develop a simple database independent data access layer using ADO.NET 2.0.