(Serdar Yegulalp) Few people planning to upgrade to SQL Server 2005 will start from absolute scratch. Most will migrate to 2005 either from another database product entirely or from an earlier version of SQL Server. In this article I’ll look at issues that may arise specifically when upgrading an ea
Author: SSWUG Research
PostgreSQL/libpqxx Class Generator
(oti) I was a bit conflicted about where to put this code. I didn’t know whether to put it into the Free Tools with Source section or here. I decided on here because, well, I already have an article here, and it’s starting to feel like home.
Mini-Tip #4: Open Source Tools for Oracle
(Lewis R Cunningham) I’ve written about Open Source and Oracle in the past but thought I would remind everyone that open source is a good place to go for new tools. Instead of starting from scratch, it sometimes helps to see if someone has done something already. My philosophy is to not reinvent the
Delegate-Based XML Processor for Configuring Objects From XML
(vonwao) There have been times when I’ve needed to parse an XML file and configure some objects. XmlReader is very flexible, but too low level for the simple task at hand. The built-in serialization is a tempting option also, but not flexible enough and too intrusive. DOM is too memory intensive
Understanding XForms: AJAX, XBL & XForms.org
(Kurt Cagle) This particular series has been ongoing since late last year – not quite a book, though a very healthy chapter towards one, fortunately. When I started it, I was hoping to learn a little bit myself about XForms, as teaching a new technology is, at least for me, one of the best ways I ca
Using the WebPermission Setting in ASP.NET Partial Trust
(Stefan Schackow) One of the permissions defined in ASP.NET’s Medium and High partial trust files is System.Net.WebPermission. This is probably one of the most confusing permissions for developers to use due to the interaction between ASP.NET’s element and the settings for this permission.
Take advantage of ADO.NET connection pooling
(Tony Patton) The process of establishing a database connection can be time consuming depending upon network connectivity. Connection pooling is a viable option if the network is an issue, and database server resources are available. This topic may seem to conflict with my recent coverage of working
Build a Google Earth Interface on Oracle Database XE
(Rich Gibson) How we look at our data forms our view of the world. Until recently most of us have ignored location because we lacked the tools (or the ability to use those tools) needed to acquire, manage, and present the spatial component of our data. This means we have missed the geospatial compon
Oracle DML Error Logging
(Steve Callan) Not all errors in Oracle are fatal, and that statement applies to data manipulation language statements as well. Even though an error in and of itself may be fatal, when handled properly it becomes benign. The question is this: how do you make an otherwise fatal error benign or harmle
You cannot remotely connect to a named instance of SQL Server 2000 by using the TCP/IP protocol
Consider the following scenario. You have a computer that is running an instance of Microsoft SQL Server 2005 and a named instance of Microsoft SQL Server 2000. After you uninstall the instance of SQL Server 2005, you cannot remotely connect to the named instance of SQL Server 2000 by using the TCP/