﻿<?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>Forecasting with SQL</title><description><![CDATA[Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.]]></description><guid>http://www.sqlservercentral.com/articles/T-SQL/69334/</guid><pubDate>2010/02/09</pubDate><link>http://www.sqlservercentral.com/articles/T-SQL/69334/</link></item><item><title>Professional Microsoft SQL Server 2008 Integration Services - Sample Chapter</title><description><![CDATA[Get a feel for this book from ]]></description><guid>http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/69498/</guid><pubDate>2010/02/09</pubDate><link>http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/69498/</link></item><item><title>Introducing SQL Server 2008 and 2008 R2 Integration Services</title><description><![CDATA[The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69410/</guid><pubDate>2010/02/09</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69410/</link></item><item><title>A guide to recover a database out from Suspect mode </title><description><![CDATA[This is a guide to bring back a database back from Suspect status. This covers common causes and the steps to resolve the situation.]]></description><guid>http://www.sqlservercentral.com/articles/Database+in+suspect/69133/</guid><pubDate>2010/02/08</pubDate><link>http://www.sqlservercentral.com/articles/Database+in+suspect/69133/</link></item><item><title>PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage</title><description><![CDATA[Upcoming webcasts in February on the 9th and 10th of the month.]]></description><guid>http://www.sqlservercentral.com/articles/pass/69485/</guid><pubDate>2010/02/08</pubDate><link>http://www.sqlservercentral.com/articles/pass/69485/</link></item><item><title>SQL Server Third Party Application Requirements Document / Checklist</title><description><![CDATA[In August 2009 I wrote a tip concerning checklists for third-party applications running against Microsoft SQL Server.  I thought it was a good time to revisit the topic and provide an added bonus: a requirements document that you can download and customize for your own uses. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69408/</guid><pubDate>2010/02/08</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69408/</link></item><item><title>TSQL Challenge 23 - Calculate the uptime and downtime of a system by reading the data from an audit log</title><description><![CDATA[It is again time to play with some date/time values. This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69414/</guid><pubDate>2010/02/08</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69414/</link></item><item><title>SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers</title><description><![CDATA[SQL Server MVP and SSIS guru, Andy Leonard, discusses Integration Services and some of the tasks and containers that he uses quite often.]]></description><guid>http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/</guid><pubDate>2010/02/05</pubDate><link>http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/</link></item><item><title>Laying out SQL Code</title><description><![CDATA[It is important to ensure that SQL code is laid out the best way for the team that has to use and maintain it. Before you work out how to enforce a standard, one has to work out what that standard should be for the application. So do you dive into detail or create an overall logic to the way it is done?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69402/</guid><pubDate>2010/02/05</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69402/</link></item><item><title>Don Syme: Geek of the Week</title><description><![CDATA[ It came as a surprise to many of us when Microsoft pulled from it's hat a rabbit in the form of an exciting, radical, language that offers an effective alternative to the Object-oriented orthodoxy. The creative force behind this language, F#, turns out to be a brilliant Cambridge-based Australian called Don Syme, already well known for his work on generics in .NET. F# has taken the specialised power of ML and OCaml and developed a versatile general-purpose .NET language. We sent Richard Morris across the road to investigate. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69403/</guid><pubDate>2010/02/05</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69403/</link></item><item><title>Report Server Diagnostic Reports</title><description><![CDATA[Diagnostic report pack for SSRS that provides monitoring capabilities for all items on the Report Server.]]></description><guid>http://www.sqlservercentral.com/articles/SSRS/69257/</guid><pubDate>2010/02/04</pubDate><link>http://www.sqlservercentral.com/articles/SSRS/69257/</link></item><item><title>SQL Saturday #37 - Philadelphia</title><description><![CDATA[Come to this great one day training event in Philadelphia, PA. SQL Saturday is a great way to get free training on all aspects of SQL Server.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69332/</guid><pubDate>2010/02/04</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69332/</link></item><item><title>Data storage and retrieval for geospatial data in SQL Server 2008</title><description><![CDATA[The company I work for has migrated to SQL Server 2008 and we're ready to start planning for the use of geospatial data. One of the applications we want to use geospatial data in will assist order fulfillers in efficiently picking stock for orders. Our warehouse is fairly large, which geospatial data type should we use?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69407/</guid><pubDate>2010/02/04</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69407/</link></item><item><title>A Search and Replace Script when Moving Objects from Prod to Test</title><description><![CDATA[Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views. ]]></description><guid>http://www.sqlservercentral.com/articles/Search/69253/</guid><pubDate>2010/02/03</pubDate><link>http://www.sqlservercentral.com/articles/Search/69253/</link></item><item><title>Raw Materials - Performance Acceleration</title><description><![CDATA[Sometimes it's best to keep your secrets to yourself.]]></description><guid>http://www.sqlservercentral.com/articles/Raw+Materials/69316/</guid><pubDate>2010/02/03</pubDate><link>http://www.sqlservercentral.com/articles/Raw+Materials/69316/</link></item><item><title>SQL Saturday #33</title><description><![CDATA[A one day training event in the Charlotte, NC area. Come join MVPs from around the area at another great SQL Saturday.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69331/</guid><pubDate>2010/02/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69331/</link></item><item><title>Introduction to Security in Analysis Services</title><description><![CDATA[Join BI Architect Bill Pearson in this introduction to Security in Analysis Services 2008. Here we explore security concepts and implementation, and look forward to hands-on practice with security in other articles of this subseries.<!-- Too many SQL Servers to keep up with? -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/too_many_servers.htm?utm_source=ssc&utm_medium=rss&utm_content=toomany200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>Too many SQL Servers to keep up with?</strong><br /><a href="http://www.red-gate.com/products/SQL_Response/offers/too_many_servers.htm?utm_source=ssc&utm_medium=rss&utm_content=toomany200912&utm_campaign=sqlresponse">Download a free trial</a> of SQL Response to monitor your <br>SQL Servers in just one intuitive interface."The monitoring<br>in SQL Response is excellent." Mike Towery. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69409/</guid><pubDate>2010/02/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69409/</link></item><item><title>Easy Error Trapping When Using xp_cmdshell </title><description><![CDATA[Getting errors and output messages when using xp_cmdshell can be tricky.  This method can solve your problems.]]></description><guid>http://www.sqlservercentral.com/articles/Error+Handling/69196/</guid><pubDate>2010/02/02</pubDate><link>http://www.sqlservercentral.com/articles/Error+Handling/69196/</link></item><item><title>How to use sys.fn_PhysLocFormatter undocumented function</title><description><![CDATA[It would be nice if we could use the DBCC PAGE command to see exactly what it is stored at the page level, however, in order to do this we need to find a way to correlate the results returned from a SELECT statement with the physical data location. Is that possible? The answer is: YES. All we need to do is use the sys.fn_physLocFormatter function.  In this tip, I will cover how to use this undocumented function.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69406/</guid><pubDate>2010/02/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69406/</link></item><item><title>SQL Server DMV Green Paper</title><description><![CDATA[Get a free green paper, an early access look at a new DMV book from longtime author Ian Stirk.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69444/</guid><pubDate>2010/02/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69444/</link></item><item><title>13 Things You Should Know About Statistics and the Query Optimizer</title><description><![CDATA[Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a mention of  Brazilian Soccer stars and young ladies on Copacabana beach. You'll never quite think of statistics, execution plans, and the query optimiser the same way again after reading this, but we think you'll understand them better.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69454/</guid><pubDate>2010/02/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69454/</link></item><item><title>Generating charts in SQL Server Reporting Services</title><description><![CDATA[This article displays how we can place charts in reports created using SSRS.<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69176/</guid><pubDate>2010/02/01</pubDate><link>http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69176/</link></item><item><title>SQL Server 2008 Build List</title><description><![CDATA[The list of builds for SQL Server 2008 updated with Cumulative Update 6 for SP1 and CU9 for RTM.]]></description><guid>http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/</guid><pubDate>2010/02/01</pubDate><link>http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/</link></item><item><title>Learn about SQL Server without leaving your desk</title><description><![CDATA[SQL Server Central, with Pragmatic Works, is offering a new option in learning: high-quality training at a fraction of the usual cost with work absence slashed to zero. Our classes are done online with the same type of quality instructor you would receive from our private classes but done at your own desk. Even though you're doing the class online, the instructor can still hear you while you ask questions and optionally see your screen. Because the class is done in half-day increments, you also still have time to do your job.<!-- Do the best for your data -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_maintenance_plans.htm?utm_source=ssc&utm_medium=rss&utm_content=maintenance_201001&utm_campaign=sqlbackup"><img alt="SQL Server Maintenance Plans" height="68" src="http://www.red-gate.com/images/marketing/SSC/maintenance_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Do the best for your data</strong><br>Get a free copy of “Brad’s SQL Server Maintenance Plans” <br>eBook and try SQL Backup™ for smaller, faster, more  <br>robust backups.  <a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_maintenance_plans.htm?utm_source=ssc&utm_medium=rss&utm_content=maintenance_201001&utm_campaign=sqlbackup">Download your free resources now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69459/</guid><pubDate>2010/02/01</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69459/</link></item><item><title>Immerse Yourself in Advanced SQL Server Knowledge with Paul S. Randal and Kimberly L. Tripp</title><description><![CDATA[A chance to dive deep into SQL Server with Paul Randal and Kimberly Tripp this Spring in Boston.]]></description><guid>http://www.sqlservercentral.com/articles/Events/69458/</guid><pubDate>2010/02/01</pubDate><link>http://www.sqlservercentral.com/articles/Events/69458/</link></item><item><title>Managing Data Growth in SQL Server</title><description><![CDATA['Help, my database ate my disk drives!'.  Many DBAs spend most of their time dealing with variations of the problem of database processes consuming too much disk space.  This happens because of errors such as incorrect configurations for recovery models, data growth for large objects and queries that overtax TempDB resources. Rodney describes, with some feeling, the errors that can lead to this sort of crisis for the working DBA, and their solution.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69405/</guid><pubDate>2010/02/01</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69405/</link></item><item><title>ROW_NUMBER(): An Efficient Alternative to Subqueries</title><description><![CDATA[The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.]]></description><guid>http://www.sqlservercentral.com/articles/T-SQL/66512/</guid><pubDate>2010/01/29</pubDate><link>http://www.sqlservercentral.com/articles/T-SQL/66512/</link></item><item><title>Microsoft SQL Server vs. MySQL</title><description><![CDATA[Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69294/</guid><pubDate>2010/01/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69294/</link></item><item><title>Brad's Sure DBA Checklist</title><description><![CDATA[Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don’ts. It provides a handy reminder. Brad has come up with a new update to his famous checklist...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69401/</guid><pubDate>2010/01/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69401/</link></item></channel></rss>