(Michael Rys) This session explores advanced concepts and techniques for working with XML data types using Microsoft SQL Server 2005 and Visual Studio 2005. Topics covered include casting to and from CLR types, working with XML on the provider level, and integrating with SQLXML 4.0. Learn how to pas
Author: SSWUG Research
Fujitsu PRIMEQUEST 400 Series & SQL Server 2005
This whitepaper provides information on the fundamental benefits of running SQL Server 2005 on Fujitsu PRIMEQUEST 400 Series Servers. (R)
Oracle takes integrated approach with G-Log buy
(Mark Brunelli) G-Log, we barely knew you. Less than five months after Oracle revealed plans to gobble up G-Log Inc., a King of Prussia, Penn.-based provider of supply chain management and logistics software, Oracle today announced that it’s dropping the G-Log name in favor of Oracle Transportat
Using Strongly-Typed Data Access in Visual Studio 2005 and ASP.NET 2.0
(Joseph Chancellor) When we as developers are learning new techniques, examples can be our own worst enemies. Tutorials are designed to be easy to understand, but at the same time they often reinforce lazy, inefficient, and even dangerous coding practices. Nowhere is this more common than in ADO.NET
You may receive an ‘OLE DB provider ‘‘ supplied inconsistent metadata for a column’ error message when you issue an SQL query statement against a DB2 table in Host Integration Server
In Microsoft Host Integration Server, you may receive an error message that is similar to the following when you issue an SQL query statement: Server: Msg 7356,Level 16,State 1,Line 1 OLE DB provider ‘Provider Name’ supplied inconsistent metadata for a column. Metadata information was changed at
Using XML: A PHP Developer’s Primer
(Adam Delves) This series of articles will focus on XML, its applications in modern day web development and how PHP fits into this niche. In this article, we will focus specifically on the tools provided to us by PHP which enable us to manipulate XML data sources.
Migration to Open Source Databases
(Jutta Horstmann) With Open Source database management systems getting mature, they are evolving as a target system for database migration. This diploma thesis focuses on migration scenarios and strategies, proposing an elaborate migration workflow. (pdf)
Ten Principles for Knowledge Management Success
This paper explores ten areas of KM including: common pitfalls of implementing KM and how to avoid them, championing the initiative and setting expectations, managing cultural change for employees and integrating KM with existing support technologies. (R)
Using Oracle Database 10g Automatic Storage Management with FUJITSU Storage
This document describes the most efficient database environment that provides the combined benefits and advantages of the new Oracle Database 10g feature, Automatic Storage Management (ASM), and Fujitsu ETERNUS storage systems. (R)
Checklist: Maximize SQL Server backup performance
(Greg Robidoux) The following steps will help you improve the performance of your SQL Server backups. Not every option will be right for your environment, but using as many of these best practices as possible will significantly improve your backup performance. (R)