﻿<?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 Content tagged Blogs</title><link>http://www.sqlservercentral.com/</link><description>Content tagged Blogs posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Maintenance Plan clean up task - not working to plan</title><description><![CDATA[A colleague of mine who is getting to grips with SQL Server had an issue after creating and implementing a...<!-- Free “SQL Server Tacklebox” eBook -->
<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/response_tacklebox.htm?utm_source=ssc&utm_medium=rss&utm_content=ResponseAndBook200909&utm_campaign=sqlresponse "><img alt="SQL Server Tacklebox" height="68" src="http://www.red-gate.com/images/marketing/SSC/SQL_Server_Tacklebox_60px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “SQL Server Tacklebox” eBook</strong><br />
    <a href="http://www.red-gate.com/products/sql_response/offers/response_tacklebox.htm?utm_source=ssc&utm_medium=rss&utm_content=ResponseAndBook200909&utm_campaign=sqlresponse">Download the eBook</a> for expert advice on tackling<br>
SQL Server issues and try out SQL Response<br>
to be alerted to problems on your SQL Servers.<br>
<img src="/Images/spacer.gif?d=ad_resp1" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68822/</guid><pubDate>2009/11/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68822/</link></item><item><title>Get 25% Off SQL Server E-Learning from Microsoft</title><description><![CDATA[Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68835/</guid><pubDate>2009/11/20</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68835/</link></item><item><title>MDX, DMX, and XMLA Templates</title><description><![CDATA[One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68650/</guid><pubDate>2009/11/20</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68650/</link></item><item><title>SQL Lunch Recordings Now Available</title><description><![CDATA[After several tries I think we finally have it working.&#160; If you were unable to attend the last two SQLLunches,...<!-- Exceptional DBA -->
<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_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup"><img alt="ExceptionalDBA" height="68" src="http://www.red-gate.com/images/marketing/SSC/EXDBA_V2_68px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “How to Become an Exceptional DBA (2nd ed.)” eBook</strong><br /><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup">Download your copy</a> and a free trial of Red Gate SQL Backup for<br>
 robust SQL Server database backups.<br /><img src="/Images/spacer.gif?d=ad_bkup2" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68823/</guid><pubDate>2009/11/20</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68823/</link></item><item><title>Why We Recommend Against xp_cmdshell</title><description><![CDATA[Every so often I see a post&#160;in a forum or on&#160;Twitter about the use&#160;of xp_cmdshell. Usually it is someone looking&#160;for...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68781/</guid><pubDate>2009/11/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68781/</link></item><item><title>Flight or Invisibility: Which do you Choose?</title><description><![CDATA[A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...<!-- Exceptional DBA -->
<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_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup"><img alt="ExceptionalDBA" height="68" src="http://www.red-gate.com/images/marketing/SSC/EXDBA_V2_68px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “How to Become an Exceptional DBA (2nd ed.)” eBook</strong><br /><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup">Download your copy</a> and a free trial of Red Gate SQL Backup for<br>
 robust SQL Server database backups.<br /><img src="/Images/spacer.gif?d=ad_bkup2" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68760/</guid><pubDate>2009/11/18</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68760/</link></item><item><title>SQL Server 2008 Database Mirroring in Action</title><description><![CDATA[I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68759/</guid><pubDate>2009/11/17</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68759/</link></item><item><title>Super Seven Cleanup Steps Before Deploying Your Cube</title><description><![CDATA[Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68758/</guid><pubDate>2009/11/16</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68758/</link></item><item><title>New HP Envy 15 Laptop</title><description><![CDATA[After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68738/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68738/</link></item><item><title>Will the New PASS Summit Attendees be Back?</title><description><![CDATA[Despite the down economy, the 2009 PASS Summit attendance was down only 8% compared to the 15% of other conferences...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68739/</guid><pubDate>2009/11/13</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68739/</link></item><item><title>Using a SSRS Report to run SQL Agent Jobs</title><description><![CDATA[Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68724/</guid><pubDate>2009/11/12</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68724/</link></item><item><title>Performance Tuning OLAP Reports</title><description><![CDATA[Reports that use an Analysis Services cube as a data source can often have performance problems during pre-execution.&#160; Before you...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68708/</guid><pubDate>2009/11/11</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68708/</link></item><item><title>SQL Server 2008 Diagnostic Information Queries</title><description><![CDATA[Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68687/</guid><pubDate>2009/11/05</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68687/</link></item><item><title>Suggested Max Memory Settings for SQL Server 2005/2008</title><description><![CDATA[It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68657/</guid><pubDate>2009/11/04</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68657/</link></item><item><title>SQL University: Multiple Paths and Ownership Chaining</title><description><![CDATA[Welcome back to&#160;our last class this term on security in SQL Server here at SQL University. According to the syllabus,...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68656/</guid><pubDate>2009/11/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68656/</link></item><item><title>Electronic Health Records – What’s the Big Deal? (Part 2)</title><description><![CDATA[In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...<!-- NEW! Object recovery for SQL Server -->
<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_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_200909&utm_campaign=sqlolrnative"><img alt="SQL OLR Native" height="68" src="http://www.red-gate.com/images/sql_server_central/olr_native_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>NEW! Object recovery for SQL Server </strong><br />Recover individual database objects from native SQL Server<br> backups and restore them to any database. <a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_200909&utm_campaign=sqlolrnative">Download a free trial </a><br>of Red Gate’s new SQL Object Level Recovery Native™.<img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>
]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68626/</guid><pubDate>2009/11/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68626/</link></item><item><title>Where Will We PASS Each Other?</title><description><![CDATA[In my a post on Monday, I talked about who I want to meet while at the PASS Summit.&#160; Today...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68623/</guid><pubDate>2009/10/30</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68623/</link></item><item><title>My Schedule at the Summit/Let’s Connect</title><description><![CDATA[I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68624/</guid><pubDate>2009/10/30</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68624/</link></item><item><title>SSRS - Setting Default Parameter Values for Analysis Services Datasets</title><description><![CDATA[When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68591/</guid><pubDate>2009/10/28</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68591/</link></item><item><title>PASS Update #18</title><description><![CDATA[Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68582/</guid><pubDate>2009/10/27</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68582/</link></item><item><title>What Direction Do You Choose?</title><description><![CDATA[You have brains in your head. You have feet in your shoes. You can steer yourself, any direction you choose.
Dr. Seuss
]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68583/</guid><pubDate>2009/10/27</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68583/</link></item><item><title>Characters</title><description><![CDATA[No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.” ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68581/</guid><pubDate>2009/10/26</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68581/</link></item><item><title>Review: ASUS Eee PC 1005HA Netbook</title><description><![CDATA[Our home desktop&#160;was several years old and due for replacement. I still have my Dell laptop,&#160;and it's still more than...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68549/</guid><pubDate>2009/10/23</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68549/</link></item><item><title>SharePoint 2010 And SQL Server 2008 R2</title><description><![CDATA[Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68550/</guid><pubDate>2009/10/23</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68550/</link></item><item><title>Transparency and PASS</title><description><![CDATA[I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a...<!-- Exceptional DBA -->
<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_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup"><img alt="ExceptionalDBA" height="68" src="http://www.red-gate.com/images/marketing/SSC/EXDBA_V2_68px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “How to Become an Exceptional DBA (2nd ed.)” eBook</strong><br /><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup">Download your copy</a> and a free trial of Red Gate SQL Backup for<br>
 robust SQL Server database backups.<br /><img src="/Images/spacer.gif?d=ad_bkup2" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68558/</guid><pubDate>2009/10/22</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68558/</link></item><item><title>Electronic Health Records – What’s the Big Deal? (Part 1)</title><description><![CDATA[Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant.  While we caught up, he asked me to explain in terms he could understand what I do for a living.  I went through one of my spiels (the one usually..<!-- Free “SQL Server Tacklebox” eBook -->
<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/response_tacklebox.htm?utm_source=ssc&utm_medium=rss&utm_content=ResponseAndBook200909&utm_campaign=sqlresponse "><img alt="SQL Server Tacklebox" height="68" src="http://www.red-gate.com/images/marketing/SSC/SQL_Server_Tacklebox_60px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “SQL Server Tacklebox” eBook</strong><br />
    <a href="http://www.red-gate.com/products/sql_response/offers/response_tacklebox.htm?utm_source=ssc&utm_medium=rss&utm_content=ResponseAndBook200909&utm_campaign=sqlresponse">Download the eBook</a> for expert advice on tackling<br>
SQL Server issues and try out SQL Response<br>
to be alerted to problems on your SQL Servers.<br>
<img src="/Images/spacer.gif?d=ad_resp1" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68548/</guid><pubDate>2009/10/21</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68548/</link></item><item><title>SQL Server Legend – Data Files and Threads</title><description><![CDATA[Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68482/</guid><pubDate>2009/10/20</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68482/</link></item><item><title>Generate Lots of Test Data with CROSS JOIN</title><description><![CDATA[“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68481/</guid><pubDate>2009/10/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68481/</link></item><item><title>Work on a Strength or Weakness?</title><description><![CDATA[When deciding what to learn, there's a binary decision. Will you focus on a strength or a weakness? I think many people focus mostly on their strengths because they have a goal of really standing out in something. They perhaps want to avoid being..]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68453/</guid><pubDate>2009/10/16</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68453/</link></item><item><title>Sparse Columns – ConvertSVtoXML &amp; XMLToResv</title><description><![CDATA[Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the  Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68452/</guid><pubDate>2009/10/15</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68452/</link></item></channel></rss>