(David E. Wheeler) One of the most powerful features of PostgreSQL is its support for user-defined functions written in various programming languages, including pure SQL, C, Perl, Python, and PHP. Perhaps the most common programming language for PostgreSQL functions, however, is PL/pgSQL (don’t ask
Other News
ASP.NET security with SQL Server 2005
(Sanjay Gulati) Today I was trying to access the web page and getting following error Error Message:Login failed for user ”. The user is not associated with a trusted SQL Server connection.
Checklist: Archiving SQL Server backups
(Greg Robidoux) Archiving database backups is probably relatively low on most DBA to-do lists. Unfortunately, it’s one of those things that has to be done. (R)
Using XQuery to Manage XML with SQL Server 2005
(Jesse Smith) It has probably taken longer for XML to become a mainstream part of today’s applications than many developers first thought. XML is now becoming more widely used as wireless devices are becoming more secure and with better bandwidth. New technologies such as XQuery for SQL Server 2005
Using XQuery, New Large DataTypes, and More
(John Papa) SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification
XML application migration from DB2 8.x to DB2 Viper, Part 1: Partial updates to XML documents in DB2 Viper
(Hardeep Singh) XML support in DB2 Universal Database (UDB) Version 8.x is based on DB2’s relational infrastructure. Previous to the DB2 Viper release, XML data was either stored intact as a character large object (CLOB) or shredded to relational tables.
Browsing XML/XSL/XSD with HTA/Scripting Runtime
(Dmitry Khudorozhkov) The initial idea of this article was to bring you a simplistic example of using a Scripting Runtime Library, “click here and here, blah-blah-blah, thank you”. The reason why I began writing was the need to make my and my colleagues’ scripts file-system-aware. This ability prove
Oracle announces general availability of Oracle Secure Backup
(Dave Chappelle) Oracle has announced the general availability of Oracle Secure Backup, intended to deliver high-performance network tape backup for Oracle databases and file systems on Linux, UNIX, and Windows platforms.
LINQ Into Microsoft’s New Query Capabilities
(Markus Egger) At PDC 2005, Microsoft introduced brand new technology known as LINQ, which stands for “Language Integrated Query.”
Why Oracle Works the Way it Does (6) – The SGA
(Dratz) The System Global Area (SGA) is powerful set of memory components that help you make Oracle very performant and scalable.