(Dino Chiesa) One of the nice things you can do with SQL Server 2005 is utilize it as a central federating data server. In this manner of usage, SQL Server acts as the gateway to connect to data that is distributed in different sources across the enterprise.
Other News
DB2/400 Support for Domino 8 is Missing in Action
(Timothy Prickett Morgan) As we reported in our Four Hundred Stuff newsletter last week, IBM is now shipping Version 8 of its Notes/Domino groupware stack. The software, which is a kicker to the Domino 7 software that IBM delivered in September 2005, offers the usual improvements in scalability, rel
Announcing CTP1 of the XML Schema Designer
XML Tools team has released the first CTP of the XML Schema Designer – a graphical tool for working with XML Schemas. You can download it from Microsoft Downloads site. This CTP introduces the Schema Explorer – a tool that helps you navigate, search and work with schema sets. You can view a short v
Ask Ben: Getting XML Values And Aggregates In ColdFusion
(Ben) If you have an XML Doc: .. ….123 .. .. ….456 .. I want a list of empid values. I can use XMLSearch to get an array of empids, and loop over it to listappend the values, but I dont
Using XML with Microsoft Excel
One of the most useful features for a programmer would be Microsoft Excel’s capability to support XML schemas which are user defined. Though it is not a very prominent feature which can be obviously noted it still exists and is very functional tool. In simple English it means that you can add, and m
Oracle Analytic Functions
(Greg Rahn) Recently, I’ve been quite busy with performance projects and haven’t had the spare time I would like to keep up on my blog. Now that those projects are behind me, I wanted to blog about the use of one feature that made a significant difference in performance on a number of queries for th
Blogging about 11g Part 8 – Interval Partitioning
(Yuri van Buren) DBA’s can finally use the Automatic Interval Partitioning option.
Introduction to Linked Objects in Analysis Services 2005
(William Pearson) Among many new capabilities that debut in Analysis Services 2005, our options for bringing together data from different data sources – and extending structures that we have already built elsewhere within our integrated business intelligence solution – is further enhanced with linke
MySQL Backup & Recovery – Part 1
(Ronald) I realized recently from observation that some smaller websites which use MySQL do not have a working backup and recovery strategy. Some may have a backup approach but it will not work in a recovery. As part of a number of discussions on Backup & Recovery here is part 1.
How to troubleshoot Service Broker problems
(Mladen Prajdiæ) In my first and second article about Service Broker I’ve shown how to build a central data repository on one server with one database that stores data (fist article) and across multiple servers with a single server that stores all data (second article). In this one I’ll discuss some