﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Articles</title><link>http://www.sqlservercentral.com/</link><description>Articles posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>A Generic Process to Convert XML Data - Part 1</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/XML/63889/</guid><pubDate>2009/07/03</pubDate><link>http://www.sqlservercentral.com/articles/XML/63889/</link></item><item><title>Remote BLOB Store Provider Library Implementation Specification</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66761/</guid><pubDate>2009/07/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66761/</link></item><item><title>Taking Advantage of Sample Reporting Services Reports</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67333/</guid><pubDate>2009/07/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67333/</link></item><item><title>Oracle for the SQL Server Guy - Instances and Databases</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/SQL+Server/67007/</guid><pubDate>2009/07/02</pubDate><link>http://www.sqlservercentral.com/articles/SQL+Server/67007/</link></item><item><title>Configuring SQL Agent Operators - SQL School Video</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/Video/67257/</guid><pubDate>2009/07/02</pubDate><link>http://www.sqlservercentral.com/articles/Video/67257/</link></item><item><title>Move SQL Server transaction log files to a different location via T-SQL and SSMS</title><description><![CDATA[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?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67335/</guid><pubDate>2009/07/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67335/</link></item><item><title>Avoiding the EAV of Destruction</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67343/</guid><pubDate>2009/07/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67343/</link></item><item><title>Generating Insert Statements</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/T-SQL/66987/</guid><pubDate>2009/07/01</pubDate><link>http://www.sqlservercentral.com/articles/T-SQL/66987/</link></item><item><title>Raw Materials - The Nightmare</title><description><![CDATA[It's good to identify with your work, isn't it?]]></description><guid>http://www.sqlservercentral.com/articles/Raw+Materials/67394/</guid><pubDate>2009/07/01</pubDate><link>http://www.sqlservercentral.com/articles/Raw+Materials/67394/</link></item><item><title>Windows Server Virtualization: Hyper-V, an Introduction</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67331/</guid><pubDate>2009/07/01</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67331/</link></item><item><title>Sending E-mail from SQL Server 200X</title><description><![CDATA[From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67340/</guid><pubDate>2009/07/01</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67340/</link></item><item><title>Automating tests for T-SQL code</title><description><![CDATA[Learn how you can write test automations for T-SQL code using T.S.T. New author Ladislau Molnar has a great project on Codeplex that can help improve your testing.]]></description><guid>http://www.sqlservercentral.com/articles/unit+tests/67050/</guid><pubDate>2009/06/30</pubDate><link>http://www.sqlservercentral.com/articles/unit+tests/67050/</link></item><item><title>Creating Indexed Views - SQL School Video</title><description><![CDATA[An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.]]></description><guid>http://www.sqlservercentral.com/articles/Video/67254/</guid><pubDate>2009/06/30</pubDate><link>http://www.sqlservercentral.com/articles/Video/67254/</link></item><item><title>Copy Only Backup for SQL 2005 and SQL 2008</title><description><![CDATA[Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67334/</guid><pubDate>2009/06/30</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67334/</link></item><item><title>Execute SQL and Bulk Insert Tasks in SSIS</title><description><![CDATA[Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67339/</guid><pubDate>2009/06/30</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67339/</link></item><item><title>SCOME - Part 4: Using Visual Studio To Develop The Report </title><description><![CDATA[Part 4 of this series from Drew Salem shows how you build a report in Visual Studio.]]></description><guid>http://www.sqlservercentral.com/articles/SCOME/67041/</guid><pubDate>2009/06/29</pubDate><link>http://www.sqlservercentral.com/articles/SCOME/67041/</link></item><item><title>Who's been logging into my SQL Server?</title><description><![CDATA[In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67264/</guid><pubDate>2009/06/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67264/</link></item><item><title>Page compression in SQL Server 2008 </title><description><![CDATA[Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67332/</guid><pubDate>2009/06/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67332/</link></item><item><title>On Error () Logging by Using Event Handlers</title><description><![CDATA[Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.]]></description><guid>http://www.sqlservercentral.com/articles/SQL+Server/66387/</guid><pubDate>2009/06/26</pubDate><link>http://www.sqlservercentral.com/articles/SQL+Server/66387/</link></item><item><title>Introduction to Fast Track Data Warehouse Architectures</title><description><![CDATA[This paper provides an overview and guide to SQL Server&#174; Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66759/</guid><pubDate>2009/06/26</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66759/</link></item><item><title>Identifying Object Dependencies in SQL Server</title><description><![CDATA[Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67267/</guid><pubDate>2009/06/26</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67267/</link></item><item><title>Split string using XML</title><description><![CDATA[Learn how you can split a delimited string in a single query using XML with Divya Agrawal.]]></description><guid>http://www.sqlservercentral.com/articles/XML/66932/</guid><pubDate>2009/06/25</pubDate><link>http://www.sqlservercentral.com/articles/XML/66932/</link></item><item><title>Adding a Computed Column to a Table (2) - SQL School Video</title><description><![CDATA[Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.]]></description><guid>http://www.sqlservercentral.com/articles/Video/67253/</guid><pubDate>2009/06/25</pubDate><link>http://www.sqlservercentral.com/articles/Video/67253/</link></item><item><title>The short course on how SQL Server really works</title><description><![CDATA[Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions – requires somebody to feed and care for it. You're the &quot;Microsoft Guy&quot; (or Gal), so whether you wanted to be or not, you were elected. This series of articles is all about making you more effective with SQL Server as an administrator, not a programmer.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67262/</guid><pubDate>2009/06/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67262/</link></item><item><title>Practical Database Change Management (Part 2)</title><description><![CDATA[The final article on Change Management examines the more technical aspects of Change Management. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67269/</guid><pubDate>2009/06/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67269/</link></item><item><title>Midlands SQL User Group Meeting</title><description><![CDATA[Come see John Welch speak on Getting Started With Analysis Services 2008, July 7, 2009 in Columbia, SC]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67361/</guid><pubDate>2009/06/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67361/</link></item><item><title>Deploying Databases From Visual Studio Team System Database Edition</title><description><![CDATA[With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.]]></description><guid>http://www.sqlservercentral.com/articles/visual+studio/65746/</guid><pubDate>2009/06/24</pubDate><link>http://www.sqlservercentral.com/articles/visual+studio/65746/</link></item><item><title>Raw Materials - Expecting the Worst</title><description><![CDATA[Optimists are often disappointed.]]></description><guid>http://www.sqlservercentral.com/articles/Raw+Materials/67129/</guid><pubDate>2009/06/24</pubDate><link>http://www.sqlservercentral.com/articles/Raw+Materials/67129/</link></item><item><title>Retaining historical index usage statistics for SQL Server - Part 2</title><description><![CDATA[We look at performing the same task for the sys.dm_db_index_operational_stats Dynamic Management Function (or DMF.)  The process is identical, the code is however quite different due to the structural differences between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67266/</guid><pubDate>2009/06/24</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67266/</link></item><item><title>Practical Database Change Management (Part 1) </title><description><![CDATA[Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67268/</guid><pubDate>2009/06/24</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67268/</link></item></channel></rss>