(Michelle Gutzait) As a DBA, I tend to look at performance issues and therefore would like to make sure that performance will not be affected by the use of XML (Extensible Markup Language). In this first article of a series, I’ll show performance implications by comparing the XML AUTO function with
Other News
Complete set (an alternative solution)
(Arjen Lentz) Scott Noyes wrote about a question frequently asked in for instance the freenode #mysql channel: given a table with students and answers, which students have answered all of a certain set of questions.
New SQL Server Weekly Show Posted
Watch the Latest Weekly SQL Server Show Here We’ve posted the latest edition of SelectViews, our weekly show on SQL Server and databases in general. This week’s show, number 75, is about DBA roles and how to apply those in a politically charged situation. We’ll also go into luggage and databases, upcoming events, the 60 second tip of the day […]
Creating rich Web service clients with Flash and Flex
(William Brogden) Of all the various browser accessories that enrich the Web browsing experience, surely the most powerful is the nearly ubiquitous Flash player. This browser plug-in first got serious attention as Macromedia Flash 1.0 in 1996 and major enhancements have been made at frequent interva
Using XML Web Services in Traditional ASP
(Luke Niland) There are a lot of services out on the web now (such as Flickr and Digg) that allow developers access to their data over an API and web service. Most of this data is available to everyone as long as they have registered with the service and have a valid API key. This article will expla
Build AJAX Security With JSON
(Lee Thé) Conferences about new development environments, such as AJAX, typically feature sessions showing cool new things you can do with it. Inevitably, though, some sessions will focus on security issues. They’ll be like a trip to the dentist: less fun, but absolutely necessary. For those who mig
Encryption [DB2 9 for z/OS]
(Craig Mullins) DB2 V9 offers some encryption news, but we need to go back a version to start the story. You see, DB2 supports encryption in Version 8 through encryption functions that need to be explicitly coded in order to encrypt and decrypt data.
Database I/O Type
(James F. Koopmann) Last week I received a call from the field wanting to know how to tune an Oracle database based on a particular storage array configuration.
Hosting a .NET Application in a Web Farm
(Tejaswini Das) A Web server farm or simply Web farm is a group of computers acting as servers and housed together in a single location. A server farm is sometimes called a server cluster. A Web server farm can be either (1) a Web site that has more than one server or (2) an Internet service provide
Business Intelligence in the Balance: IBM tackles BI’s complex future with dynamic warehousing
(David Stodder) Put the right information in the right hands at the right time: that’s been the mantra of business intelligence (BI) since the beginning. But today, the parameters are changing for how the BI and data warehousing (DW) community delivers on that goal. What’s the right information when