Microsoft SQL Server 2005 Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies deprecated features and configuration changes that might affect your upgrade, and it provides links to documentation that des
Other News
MySQL, Business Objects team for bundled offerings
(Elizabeth Montalbano) Business Objects and MySQL have strengthened their partnership by collaborating on software bundles that combine MySQL’s open-source database with business intelligence (BI) software from Business Objects, company representatives said.
Integrating AJAX with the JMX Notification Framework
(Graham P. Harrison) This article elaborates on an architectural benefit of AJAX that lets the management state be ‘broadcast’ to a browser-enabled user base without waiting for a page refresh.
XE, XML and WebDAV – Access your XML data in Oracle XE
(Lewis R Cunningham) The question I probably receive most is how to create XML so that it can be accessed via ftp, http or even from the desktop and tools like MS Word. XML DB can do this and it’s pretty easy to use. I’m going to use XE as my database of choice but this would work in any […]
Checking your registry variables via SQL
(Chris Eaton) Another new table function shipped in 8.2.2 (8.1 fixpack 9) is the REG_LIST_VARIABLES function. This table function will list all the registry variables used by the current database you are connected to. Here is an example of calling this function.
Building a Better Virus Trap
(Christopher Jones) Not so long ago, viruses were just one of those little annoyances that come along with using a computer, akin to the gnat that orbits your head at the family picnic. But over the past few years, those pesky little pieces of code have steadily moved from simply popping up mess
Managing MySQL on Mac OS X
(Robert Daeley) MySQL is a popular database management system with which most web developers are familiar. You can’t swing a cat on the internet without hitting a website running it on the back end. In fact there’s an acronym stemming from the ubiquitous open source combo of Linux, Apache, MySQL
Building Speech-Enabled Applications with ASP.NET
(Thom Robbins) As speech-enabled applications become a core requirement for many enterprise and commercial applications, you’ll need to become familiar with the Microsoft Speech Platform.
Database Security and Patches – Part 3
(Steve Callan) Part 3 of this series examines some new functionality found in Oracle10g’s Enterprise Manager Console. In prior releases of Oracle (as shown in the first two parts of this series), patching and patch administration were manually performed by the DBA. In 10g, some of that workload
DB2 Version 8 and that little thing called Unicode
(Willie Favero) Unicode is an interesting subject. For some reason there still seems to be a lot of confusion on the subject. Unicode is one of those things that looks new yet has been around for a long time. Although it has been an optional part of DB2 on the OS/390 and z/OS platforms since Ver