Featured Article(s) Troubleshooting Linked Servers in SQL Server 2005 In this article, Alexander Chigrik explains some problems with SQL Server 2005 linked servers. He also tells how you can resolve these problems. Importing Data? Cool Blog Posting Our friends at DataDefractor have a blog that talks about all sorts of tips for importing and massaging data for your system. I’ve […]
Other News
Would You Use SQL Server as a Service?
Great New Books in the Book Directory Three new books from IBM Press – and more – http://bitonthewire.wpengine.com/book_directory – if you’re looking from some great references and especially these new titles focused on DB2 – you should check out the book directory. Take a look at the new DB2 titles: – DB2 9 for Linux, UNIX, and Windows Sixth Edition: […]
Getting Internet Usability to the Next Level: Oracle Usability Advisory Board
(Anna M. Wichansky) In every endeavor, there are issues that persist regardless of our best singular efforts to resolve them. So it goes with usability. In my 13 years as Usability Manager and Senior Director of Advanced User Interfaces at Oracle, I have tackled and conquered many a usability proble
Code Generation: Why XQuery is Better than XSLT
(Dmitri Nesteruk) As of recently, all my new development efforts are using XQuery instead of XSLT as the language of choice. The following blog entry outlines the reasons why I decided to go with XQuery, and what I gained from it.
A DB2 Person in an Agile Software Development Discussion
(Robert Catterall) I’m posting this week from Orlando, Florida, USA, site of the winter meeting of the SHARE user group (www.share.org). I came here primarily for the purpose of delivering a presentation at the conference (the topic was SOA for DB2 people), but when I attend a conference as a speake
How to Rename a Copied or Cloned ASM Disk Group
(Grégory Guillou) ASM is definitely one of the coolest technologies inside the Oracle Database. On the other hand, the ability of the storage arrays to provide a read/write access to a copy or a “snapshot” of its content is something we can easily leverage as an Oracle DBA. For a couple of weeks, I
z/OS V1.10 preview: Update #3
(Willie Favero) Last Tuesday wasn’t just a bunch of new hardware getting announced. IBM also had a preview of the next z/OS operating system, z/OS V1.10. z/OS just keeps getting cooler and cooler and if you are interested in the mainframes operating system, you really need to check out Tuesday’s (Fe
Inheriting Web sites: Getting a Web site to a maintainable state
(Brett D. McLaughlin, Sr.) In a perfect world, you’d create every Web site you were ever assigned to maintain, improve, and redesign. Unfortunately, in the real world, you’re often forced to take on a site someone else designed or constructed.
DB2 Security, Part 11: Develop a security plug-in for DB2 database authentication
(Gene Kligerman) This article describes the design and development of a DB2 for Linux, UNIX, and Windows security plug-in that retrieves user ID, group, and group membership information from a local or remote DB2 database. Use of this plug-in allows for the development of database applications that
Detecting Duplicate XML Data in SQL Server
(Matt Woodward) I’ve been working quite a bit with XML in SQL Server lately (I’ll try to do a post on some xquery stuff at some point), and I had a need to check XML data that I’m pulling off disk against a table in SQL Server to see if the data I pulled off disk is a duplicate with […]