(Vinod Kumar) SQL Server 2000 does a good job in optimizing using the present hardware setup. But more often than not it becomes important for DBA’s to analyze how healthy SQL Server is from time to time. No wonder DBAs get paid really good all around the world. In this article I would list some
Other News
Speeding up DB2 UDB Using Sampling
(Peter J. Haas) The vast amount of data in warehouses and on the web poses a major challenge for users who want to run BI or OLAP queries, execute advanced analytical, mining, and statistical algorithms, or interactively explore their data. Most of these tasks simply do not scale to the hundreds of
Troubleshooting: When the database instance locks up
(Brian Cryer) The apparent complete lock-up of the database. It is still possible to connect to the database, but any attempt to query it results in the application (or Oracle tool) locking up.
Accessing DB2 Universal Database Tables with Delphi for .NET
(Bob Swart) In this article, I will demonstrate how you can use Borland Delphi 8 for the Microsoft .NET Framework (abbreviated to “Delphi for .NET” from now on) to build native .NET applications that connect to IBM DB2 Universal Database (UDB) tables, display the data in a DataGrid, and edit, apply,
BUG: Synchronization Is Not Performed on DataSet and XmlDataDocument When You Set InnerXml on a Text Node
Synchronization between DataSet(System.Data) and XmlDataDocument(System.Xml) is not performed when you use InnerXml on a node that has a text node only. The text appears to disappear from the output that is generated.
High Volume OLTP Database Cluster for the Financial Industry with IBM® DB2® for Linux
(Boris Bialek) A typical project report starts with a simple statement of the target objective and then moves forward towards the implementation. The project described in this report is different as it not only describes the aspects of a solution to a business problem, but it touches on a fundamenta
The Challenge of Web Services Security Inside the Firewall – A true story from the consulting trenches
(K. Scott Morrison) True story from the consulting trenches: the operations staff had left hours ago, shaking their heads and reluctantly leaving the consultants to resolve a problem with their code. It was well past midnight, in the middle of winter, in a town many time zones from home. The project
Clearing the Path to OLAP
(Chris Claterbos) The OLAP option in Oracle9i Database Release 2 introduced analytic workspaces and the true integration of relational and multidimensional datatypes in the same database. Until now, the only way developers and DBAs could use the analytic workspaces was to construct them manually by
Building Web Services Security with WSDK V5.1
(Kyle Gabhart, Paul Visan, Rick Hightower, David Fraser, Peter Schmitz and Jacob Weintraub) This tutorial will provide you with hands-on experience securing Web services with the IBM WebSphere SDK for Web services V5.1 (WSDK). More specifically, you will learn how to secure a WSDK SOAP service using
SQL Server and ADO.NET/CLR
(Mike Gunderloy) In my previous article, I showed you how to write a very simple function in Visual Basic .NET and then call it from T-SQL code in SQL Server “Yukon.” But that’s only part of the CLR integration story for the next version of SQL Server. One important part of the story that I left out