(Marcin Policht) In our series dedicated to new features implemented in SQL Server 2005 Beta 2, we have focused so far mostly on areas of design and functionality improvements, covering availability, scalability, and, more recently, security (including authentication, authorization, encryption, and
Other News
Loading and Saving an XML Document with DOM 3.0
(Deepak Vohra) The W3C’s Document Object Model (DOM) Level 1 and DOM Level 2 (The org.w3c.dom API is DOM Level 2 API) specifications do not have a standard method for loading and saving an XML document. Instead, most developers use vendor specific code for input to and output from DOM parsers, which
MySQL 5.0 Triggers
(Peter Gulutzan) This book is for long-time MySQL users who want to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, information_schema”. The long answer is the “MySQL 5.0 New Features” series, and this book is the second in the series. (pdf)
Spiking in eXtreme .NET (Sample Chapter)
(Neil Roodyn) Spiking is about experimentation and about being prepared to throw away the code you have written while retaining the knowledge gained from it. This chapter will help you to develop this vital skill in the .NET environment.
Getting Started with XQuery, Part 2
(Bob DuCharme) In part one of this article, we saw how the free version of the Saxon program lets you jump right in with XQuery, the increasingly popular (although not quite finished) W3C standard for querying XML data sources. We learned how to pass Saxon XQuery queries to execute on the command li
Information management in Service-Oriented Architecture, Part 1: Discover the role of information management in SOA
(Mei Selvage, Dan Wolfson and John Handy-Bosma) Learn about information management, its importance to Service-Oriented Architecture (SOA), and the relationship between between information management and SOA. Then explore the challenges and benefits of reengineering information management into SOA. I
What are the best practices for backing up the master, model, and msdb databases?
(Greg Robidoux) The value of SQL Server system (Master, Model, MSDB) database backups cannot be underestimated due to the significant amount of information residing in these databases. From an operational perspective, I recommend incorporating the system database backups on the same schedule as the
Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
(Sergei Gundorov and Clark Hamilton) In the second of this three-part series, learn how to map well-formed XML from a standard SQL Server query to a single cell in a worksheet. The resulting output is an XML tree with non-repeating elements.
Technical conference featuring DB2, Business Intelligence, Informix, U2 & WebSphere Information Integration
With over 350 sessions to choose from you will learn how DB2 Information Management Software simplifies and speeds development with embedded capabilities to integrate and analyze information, regardless of its format or location. You will also learn how you can derive new insight, address business i
FIX: A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver
A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver. When SQL Server Distribution Agent cannot synchronize with the IBM DB2/MVS heterogeneous subscriber, the synchronization ends. You may receive the following error mes