Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.

File Management with Scripting Object

by Additional Articles

Database Journal

Programming

Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).

Storing XML Data in a Relational Database

by Additional Articles

InformIT

Use familiar XML markup to extend the capabilities of your relational database.

The “sys.dm_os_performance_counters” Dynamic Management View

by Additional Articles

SQL Server Performance

SQL Server 2005

SQL Server performance can be tracked and monitored by using performance counters. For SQL Server 2005 performance counters can be displayed by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV).

Fixing Orphaned Users

by sqlagentman

SQLServerCentral

Administration

Migrating databases between production, test, development and train servers is something that a DBA needs to deal with constantly. During migration, one of the inevitable issues we need to deal with is concept of Orphaned Users.

Advanced Matrix Reporting Techniques

by Additional Articles

SimpleTalk

Reporting Services (SSRS)

In SQL Reporting Services, the native Matrix control provides a crosstab view of data, similar in behavior to a PivotTable in MS Excel. Rows and columns will have intersecting points of data which is often useful in time based reporting . David Leibowitz shows you how...

Implementing Common Reference Data in a Data Warehouse

by Additional Articles

DMReview

Data Warehousing

This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.

SQL Server Indexes: The Basics

by Additional Articles

SQLTeam.com

Indexing

Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.

Ten Ways To Lose Your DBA Job

by Steve Jones

SQLServerCentral.com

Miscellaneous

We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.