Extensible Markup Language (XML) is a meta-markup language that provides a format for describing structured data. Unlike HTML, XML does not handle the presentation of data. Instead, the tags used to encompass the data are used to describe the data. This allows for a simplified passing of data betwee
Author: SSWUG Research
Get Ready for SQL Server 2005 with Free Microsoft E-Learning Courses
Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality. These courses, valued at $99 each w
Binding the ReportViewer Control to Multiple Generic Collections
(Terry Voss) It is easy to get the ReportViewer Control to report off of a DataSet that is set during design time. But what if you want to use code to cause one ReportViewer control to display many totally different reports using your own O/R mapper collection instead? It is not easy to see how to d
Visual Basic 2005 and MySQL 5 Developer Notes – Part One
(Mike Hillyer) In my original series of VB.Net/MySQL articles, I created a sample application that tracked a collection of users and whether they were in or out of the office.
Controlling Dynamic SQL with DSCC
(Susan Lawson and Dan Luksetich) In today’s high performance computing environments we are bombarded with dynamic SQL more than we ever were in the past. Queries coming into our subsystems from products like DB2 Connect and Websphere are executed as dynamic SQL. This dynamic SQL creates problems suc
FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit
In SQL Server 2000, you receive an error message when you try to rebuild the master database. This problem occurs when the following conditions are true: • You are running SQL Server 2000 Service Pack 4 (SP4) 64-bit, and you have installed hotfix builds. Note This problem does not occur in SQL
Understanding Oracle OLAP Memory Management
(Mark Rittman) When you work with the OLAP functionality in Oracle Database 10g, you need to be aware of how it handles memory. Just like a relational data warehouse, data held in multidimensional datatypes makes use of memory structures such as the System Global Area (SGA), Program Global Area (PGA
Make the jump to SQL Server 2005 with these notes and tips
(Scott Lowe) SQL Server isn’t a product that Microsoft updates very often, so when they do release an upgrade, it has the potential to be significant. As such, there are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently
Developing and Implementing Applications
(Kevin Loney and Bob Bryla) Managing application development can be a difficult process. From a DBA’s perspective, the best way to manage the development process is to become an integral part of teams involved in the process. In this chapter, you will learn the guidelines for migrating applications
New Features in Visual Studio 2005 Windows Forms
(Jim Duffy) The little voice in my head shouted “Don’t do it! Don’t do it!” as I contemplated using the worn out cliché “Good things come to those who wait” to describe the experience of designing Windows applications with Visual Studio 2005.