(Raghu Donepudi) Every new enterprise system built today has to integrate with and support existing systems. Since the earliest days of programming, passing data between systems via flat files has been a common operation—and developers get to write the code to transfer the data from one format to an
Other News
Linked Severs on MS SQL Part 3
(Don Schlichting) In Parts 1 and 2, we introduced the Linked Server. Starting with what a Linked Server is, the benefits to using them, as well as when to avoid them. The Distributed Transaction Coordinator, DTC, was touched on. In addition, our first examples were to create links to an Excel spread
Configuring Disks and Managing Space in SQL Server Part 1
(Andrew Novick) Something like fifty percent of system outages are caused by “Out of space” conditions. I kid you not. I run into them all the time. Combine this problem with the need to maintain high availability and peak performance and the consequence is that disk configuration and space allocati
Taming the VLDB with BMC Software
There’s a new animal in the database kingdom. No longer are the beasts of availability and performance the only dominators for the time and attention of the overwhelmed database administrator. Add phenomenal size to the mix, and you have a DBA’s worst data management nightmare. The care and feeding
SQuirreL SQL Client: A Single, Open Source Front End to Interact with Your Heterogeneous Database Environment
(Kulvir Singh Bhogal) This article describes an open source application called SQuirreL SQL Client that provides an easy-to-use interface to DB2 UDB as well as a number of other vendor databases like Oracle and SQL Server. If your job requires you to interface with many different databases in the co
Version 8 Dynamic Scrollable Cursors: Better Usability and Performance
Cursor scrolling has always presented problems in the past. For both for the application programmer and for proper application performance. Scrolling forward was performed by walking an index or walking through a result set which was not too hard. However, scrolling backwards proved to be a bit more
The Future of XML
(Michael Champion) The end of the year is here again, a time when we traditionally take a long look at the progress we’ve already made and then turn our eyes toward the future, attempting to forecast the year to come. With this in mind, Hitesh Seth sought input from industry leaders on their end-of-
Binding XML To a Datagrid
(Saravana Kumar) During web development, you might come across many situations where you need to bind XML to a DataGrid. There are many ways to do this, for example we can load the XML into a dataset and then bind the dataset to datagrid. You might think that for just binding XML, why I need to crea
The XML Files–A Survey of Publicly Available Web Services at Microsoft
(Aaron Skonnard) Now that the dust has settled on the XML Web Services front, it seems like the right time to survey some of the mainstream Web Services available, with a focus on those offered by Microsoft. Microsoft offers several Web Services to the general public including the Microsoft.com
A Deeper Look at Drillthrough
(Russ Whitney) One of the most common reader questions I receive is, “How can I use the PivotTable and PivotChart components in Microsoft Excel?” These components, which enable simple analysis in Microsoft Excel or a custom application, work with either OLAP data sources or relational data sources.