(Muthusamy Anantha Kumar) One of the many command line utilities that came with SQL Server 2005 is the TableDiff utility. Although this utility is primarily designed for comparing replicated tables, we can take advantage of its functionality to compare tables. The objective of this article is to dem
Other News
Customizing Oracle 10g Installation Options
(John Kanagaraj, Arun Kumar and Richard Stroupe) Oracle Database 10g can handle data types such as relational data, object-relational data, XML, text, audio, images, video, and spatial data. These data types are stored as native types in the database, making the data searchable using SQL, even when
Optimizing Oracle 10g on Linux using Automated Storage Management
(Bert Scalzo) I often react to new Oracle releases like Steve Martin acted in the movie “The Jerk” when the new phone books arrive. I cannot help but to get excited about all the new technology that Oracle routinely delivers. But with the release of Oracle 10g, that enthusiasm cannot be overstated.
Quick XML Formatting with Microsoft Excel
(Scott Manning) You have a long list that you want to put in an XML format. This tutorial will show you a quick way to do it with Microsoft Excel.
What’s new with SAML?
(Ed Tittel) In previous XML tips we’ve looked at (and around) the Security Assertion Markup Language, aka SAML. But in the wake of increasing adoptions and use—as for example, its adoption as a cornerstone of the US Federal E-Authentication Initiative—another look seems warranted and is bound to pro
The MaxDB series on PlanetMySQL
MySQL has started a MaxDB series on its corporate blog aggregator. Since the beginning of Februar the MaxDB team tries to write one MaxDB article per week for you. The articles get published on our english language web site http://www.planetmysql.org. All articles together will make a complete MaxDB
MSXML, concluded
(Jim Keogh and Ken Davidson) So far in this chapter, you’ve learned how to insert one XML document into another. In addition to this, you’ll need to select, extract, delete, and validate information contained in an XML document.
Displaying the Sizes of Your SQL Server’s Database’s Tables
(Scott Mitchell) In my day-to-day work as a writer, trainer, and consultant, I usually wear the ASP.NET developer hat, focusing on designing the middle-tier and front-end portions of ASP.NET applications with my exposure to the database usually being limited to data modeling and writing queries/stor
Pitfalls of using T-SQL cursors
(Hilary Cotter) Conventional wisdom states that cursors are evil! A cursor is a memory resident set of pointers that reference data in your result set or, more accurately, the data in the base tables. Cursors have a bad reputation because they are typically the favorite hammer of every junior SQL de
Access Active Directory data via .NET
(Tony Patton) If you’re working within a Windows Server-based network, you are probably using Microsoft’s Active Directory. Active Directory’s purpose is to reduce the number of directories and namespaces within a network and provide a unified view of a complex network.