Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.  Read more...

This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.  Read more...

Recent installments of our series dedicated to SQL Server 2005 Express Edition have discussed the Reporting Services component. This article provides an overview of sample reports that you can take advantage of in order to familiarize yourself with the more advanced graphical designer features present in SQL Server 2005 Express Edition-based Reporting Services.  Read more...

Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.  Read more...

Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.  Read more...

I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location?  Read more...

A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions.  Read more...

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...

It's good to identify with your work, isn't it?  Read more...

For SQL Server and Exchange Server, Windows Server Virtualization is going to be increasingly important as a way for the administrator to allocate hardware resources in the most efficient way, provide more robust services, and deploy services. Jaap Wesselius starts his new series on Hyper-V by explaining what Hyper-V is, how it relates to Windows Server 2008 and how it compares to ESX, Virtual Server and Virtual PC.  Read more...