Author: SSWUG Research

Community

SQL Server 2005 Upgrade Advisor

(Gregory A. Larsen) Have you started looking at what issues you might have migrating your existing applications to SQL Server 2005? If not then maybe as a first step, you should consider looking into what the SQL Server 2005 Upgrade Advisor can do for you. This article will discuss what the Upgrade

Community

Pitfalls of using T-SQL cursors

(Hilary Cotter) Conventional wisdom states that cursors are evil! A cursor is a memory resident set of pointers that reference data in your result set or, more accurately, the data in the base tables. Cursors have a bad reputation because they are typically the favorite hammer of every junior SQL de

Community

MSXML, concluded

(Jim Keogh and Ken Davidson) So far in this chapter, you’ve learned how to insert one XML document into another. In addition to this, you’ll need to select, extract, delete, and validate information contained in an XML document.

Community

The MaxDB series on PlanetMySQL

MySQL has started a MaxDB series on its corporate blog aggregator. Since the beginning of Februar the MaxDB team tries to write one MaxDB article per week for you. The articles get published on our english language web site http://www.planetmysql.org. All articles together will make a complete MaxDB

Community

What’s new with SAML?

(Ed Tittel) In previous XML tips we’ve looked at (and around) the Security Assertion Markup Language, aka SAML. But in the wake of increasing adoptions and use—as for example, its adoption as a cornerstone of the US Federal E-Authentication Initiative—another look seems warranted and is bound to pro