(Baya Pavliashvili) There are some issues associated with managing identity columns with replication in your SQL Server database. As with previous releases of software, SQL Server 2005 requires that database administrators use special care when replicating tables with identity columns. (R)
Other News
More on XML output from MySql
(Erik Wetterberg) In a previous post I described how you could create XML output from SQL using stored functions. But that was a flat structure, with only one table and simple XML structure with a tag for every row in the result set, and column values as attributes or sub tags. Part of the real powe
i5/OS DBA: Simplified Management of External User-Defined Functions (and Stored Procedures)
(Kent Milligan) User-defined functions (UDFs) provide programmers with a great deal of flexibility when trying to integrate business calculations with SQL requests. A UDF enables a programmer to supply their own functions to complement the built-in functions that DB2 provides for basic string manipu
Learn About DotNetNuke, and Fantasy Football 2nd Call
Featured Article(s) An Introduction to DotNetNuke Web Application technology is bestowed with another boon. An open source content management solution in the name of DotNetNuke has emerged to revolutionize as far as web application development is concerned. DotNetNuke is an open source web application framework ideal for creating, deploying and managing interactive web, intranet, and extranet sites securely. It is […]
SSWUG Fantasy Football Leagues Forming!
SQL Server Show Posted Friday Watch the latest episode of SelectViews Here. The show has information about SQL Injection, Cross-Site Scripting, a minicast on working with the surface area configuration tools in SQL Server 2005, upcoming events and more. There is even a "segment selector" now that lets you jump around the show to specific segments you want to check […]
An OOXML thought experiment
(John Carroll) Adobe’s Portable Document Format (PDF) is a de facto standard on the Internet. The format is supported on most computing platforms, and the ability to read and write PDF is common, driven by Adobe’s early willingness to release full details of the specficiation. Subsets have been stan
XForms, XML Schema, and ROX
(Kurt Cagle) “If I have an XML schema, is there any way that I can work with that schema to build forms for populating instances of that schema?” Over the years, I’ve seen a number of variations on this same question, and generally for a pretty good reason. It takes a lot of work to create a sch
New Parameters in 11g (Part 2)
(Howard Rogers) A ‘lost write’ is what happens when Oracle flushes a data block to disk, the file system reports the write has taken place… but in fact it’s lying through its teeth and the write never actually completed. The trouble starts when Oracle next reads the block: if it thinks the block i
DB2 LUW – Returning a recordset from a stored procedure
In one of our earlier posts, we had covered how one can return result-sets from a stored procedure in Oracle. In this post, we are going to cover the same for DB2 LUW. DB2 LUW also does not require any variable declaration to pass back to the calling program. But we need to DECLARE the cursor first
Publish critical public warnings on the Web
(James Snell) The recently completed Atom Publishing Protocol provides a simple, HTTP-based mechanism for publishing and managing content on the Web. When used with the Common Alerting Protocol standard, Atom publishing can provide a powerful and flexible way to distribute critical, life-saving info