(Keith Brown) In the previous MySQL Virtual Workshops we have looked at logging into MySQL, creating tables, adding and selecting data using SQL statements. In this Workshop we will continue to look at other SQL commands, specifically updating and deleting, and revisit the SELECT command to examine
Other News
The New Cloudscape View
(Grant Hutchison) Visitors to Developer.com recently selected IBM Cloudscape as their favorite DBMS or Related Technology product of the year for 2005 — a choice that reflects the growing interest in open-source databases.
An XML Guru’s Guide to BizTalk Server 2004, Part I
(Aaron Skonnard) Who would have believed that XML, such a seemingly trivial technology, could revolutionize an industry? It may have seemed like a long shot in the beginning, but the XML aficionados saw something special and pragmatic right away—a sort of duct tape for the world’s information sy
An introduction to XQuery
(Howard Katz) After six long years moving along the W3C’s Recommendation track, the XQuery specification is taking on much of the mythic and enduring look of a Hollywood franchise — “Star Wars” and the “Lord of the Rings” series come to mind. XQuery had its origins in a W3C-sponsored query language
Crossing Over/Breaking the DB2 Platform Barrier
The popularity of DB2 UDB running on distributed platforms continues to grow. The sudden growth and popularity of DB2 on distributed platforms has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinking staffs. Many DB
IBM Recovery Expert for Multiplatform V2 Usage Guide
(Whei-Jen Chen, Hiromichi Shinozaki, Kevin Taylor, Marcia Miskimen and Yasir Warraich) IBM DB2 Recovery Expert for Multiplatforms (RE) provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. Recovery Expert
ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part II
(Muhammad Mosa) In this article we will continue our talking about ADO.Net 2.0 Enhancements. Here we will explore: –Bulk copy –Notifications (not SQL Server Notification Services but something else as we will see)
Returning Ranked Results with Microsoft SQL Server 2005
(Scott Mitchell) In early November 2005, Microsoft launched three new product lines: Visual Studio 2005, SQL Server 2005, and the .NET Framework version 2.0 (which includes ASP.NET version 2.0). SQL Server 2005 is the newest version of Microsoft’s database platform, with the last major SQL Server re
Creating XML with Ruby and Builder
(Michael Fitzgerald) Since the advent of Ruby on Rails last year, interest in the Ruby programming language seems to have grown steadily. Rails has helped the masses see what Ruby is: an elegant, easy-to-learn, and fun-to-use language, suitable even for industrial-strength applications. Ruby has bee
What’s In A Name – Naming and Idenifying Oracle Databases and Instances
(James F. Koopmann) Identification of the database you are currently working on can sometimes be somewhat confusing. Take a look at the internal parameters that Oracle keeps and see if you can uniquely identify the database you are currently working on.