<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">
<channel>
	<title>SQL Server Performance</title>
	
	<link>http://www.sql-server-performance.com</link>
	<description>SQL Server Performance Tuning</description>
	<lastBuildDate>Wed, 22 Feb 2012 10:13:52 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.3.1</generator>
<xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" />
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/SQLServerPerformance" /><feedburner:info uri="sqlserverperformance" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>Recovering a SQL Server Database from Suspect Mode</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/xCgpXEPiGqM/</link>
		<comments>http://www.sql-server-performance.com/2012/recovery-sql-server-suspect-mode/#comments</comments>
		<pubDate>Wed, 22 Feb 2012 10:13:52 +0000</pubDate>
		<dc:creator>satnam singh</dc:creator>
				<category><![CDATA[General DBA]]></category>
		<category><![CDATA[Recovery]]></category>
		<category><![CDATA[suspect mode]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2891</guid>
		<description><![CDATA[A couple of days back at I got a call from my support team informing me that one of our database located on the Production Server went into Suspect Mode. The version used was SQL Server 2005 Service Pack 3. Being a Production Database server, it was a Priority 1 incident and the expected time [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/recovery-sql-server-suspect-mode/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/recovery-sql-server-suspect-mode/</feedburner:origLink></item>
		<item>
		<title>Pareto Charts in SSRS</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/BcdWN6wF2F0/</link>
		<comments>http://www.sql-server-performance.com/2012/pareto-charts-in-ssrs/#comments</comments>
		<pubDate>Wed, 22 Feb 2012 03:38:14 +0000</pubDate>
		<dc:creator>Dinesh Asanka</dc:creator>
				<category><![CDATA[Developer]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[SSRS]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2888</guid>
		<description><![CDATA[The purpose of a Pareto chart is to highlight the most important amongst a set of factors. For example, in quality control for a manufacturer, a Pareto chart can highlight the most common sources of defects and the highest occurring type of defect. The Pareto principle is also known as 80-20 rule, so for quality [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/pareto-charts-in-ssrs/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/pareto-charts-in-ssrs/</feedburner:origLink></item>
		<item>
		<title>Design A Hybrid Report in SSRS</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/-X4Q46NKcjI/</link>
		<comments>http://www.sql-server-performance.com/2012/hybrid-report-ssrs/#comments</comments>
		<pubDate>Wed, 15 Feb 2012 07:29:51 +0000</pubDate>
		<dc:creator>Dinesh Asanka</dc:creator>
				<category><![CDATA[Developer]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[Hybrid Report]]></category>
		<category><![CDATA[SSRS]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2883</guid>
		<description><![CDATA[Hybrid reports are the reports which have two types of graphs using different axes within the same graph . For example. In the above report, Product cost is on the right axis while Sales Amount Percentage is shown on the left axis, so that viewers can easily compare Product Cost vs Sales Amount Percentage. Below [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/hybrid-report-ssrs/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/hybrid-report-ssrs/</feedburner:origLink></item>
		<item>
		<title>Understanding SQL Server 2008 R2 Fixed Server Roles – Part 1</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/9t2mVt3S1VM/</link>
		<comments>http://www.sql-server-performance.com/2012/sql-server-2008-r2-fixed-server-roles-pt1/#comments</comments>
		<pubDate>Wed, 15 Feb 2012 07:14:45 +0000</pubDate>
		<dc:creator>satnam singh</dc:creator>
				<category><![CDATA[General DBA]]></category>
		<category><![CDATA[2008 R2]]></category>
		<category><![CDATA[fixed roles]]></category>
		<category><![CDATA[Roles]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2881</guid>
		<description><![CDATA[When considering the security and protection of the database engine, one of the first considerations that comes to mind is SQL Server Fixed Server Roles. The Server Roles are named Fixed Server Roles as the user cannot alter these under any conditions. Assigning the appropriate roles to the user helps keep the SQL Server Environment [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/sql-server-2008-r2-fixed-server-roles-pt1/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/sql-server-2008-r2-fixed-server-roles-pt1/</feedburner:origLink></item>
		<item>
		<title>Implementing Transactions in SQL Server – Part II</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/1d6zUfmeeIg/</link>
		<comments>http://www.sql-server-performance.com/2012/implementing-transactions-sql-server/#comments</comments>
		<pubDate>Mon, 13 Feb 2012 05:15:07 +0000</pubDate>
		<dc:creator>Amit Chaudhary</dc:creator>
				<category><![CDATA[Audit]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[transactions]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2867</guid>
		<description><![CDATA[In Implementing Transactions Part I I briefly described the role of Transactions in SQL Server and outlined a very basic implementation. In this second part, I will explain how a DBA can best implement Transactions in scripts that are to be deployed on production databases. One of the regular tasks of a DBA is to [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/implementing-transactions-sql-server/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/implementing-transactions-sql-server/</feedburner:origLink></item>
		<item>
		<title>Transactions in SQL Server Part I – An Introduction</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/TjPuGg3nCvI/</link>
		<comments>http://www.sql-server-performance.com/2012/transactions-sql-server-introduction/#comments</comments>
		<pubDate>Wed, 08 Feb 2012 06:54:12 +0000</pubDate>
		<dc:creator>Amit Chaudhary</dc:creator>
				<category><![CDATA[Developer]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[Uncategorized]]></category>
		<category><![CDATA[transactions]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2863</guid>
		<description><![CDATA[A basic requirements in most SQL Server based applications is implementing a database operation (DDL or DML) in a single unit of work. The DDL requirement is more from a DBA’s perspective rather than the application, since any application would perform only INSERTs, UPDATEs and DELETEs on the existing data, and a DBA would be [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/transactions-sql-server-introduction/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/transactions-sql-server-introduction/</feedburner:origLink></item>
		<item>
		<title>Managing and Connecting to AlwaysOn Availability Groups</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/71xf-LoX-kA/</link>
		<comments>http://www.sql-server-performance.com/2012/managing-and-connecting-to-alwayson-availability-groups/#comments</comments>
		<pubDate>Wed, 01 Feb 2012 09:58:47 +0000</pubDate>
		<dc:creator>Arshad Ali</dc:creator>
				<category><![CDATA[Clustering]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[Performance Tuning]]></category>
		<category><![CDATA[2012]]></category>
		<category><![CDATA[AlwaysOn]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2854</guid>
		<description><![CDATA[From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica. In this way the client doesn’t need to know which [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/managing-and-connecting-to-alwayson-availability-groups/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/managing-and-connecting-to-alwayson-availability-groups/</feedburner:origLink></item>
		<item>
		<title>Drop Failed for Login ‘User xxx’</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/ptGqd79it6g/</link>
		<comments>http://www.sql-server-performance.com/2012/drop-failed-for-login-user-xxx/#comments</comments>
		<pubDate>Tue, 31 Jan 2012 04:50:52 +0000</pubDate>
		<dc:creator>Dinesh Asanka</dc:creator>
				<category><![CDATA[Errors]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[Jobs]]></category>
		<category><![CDATA[user]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2849</guid>
		<description><![CDATA[How To Drop Users Who Are Owners or Databases and Jobs When you want to drop users you need to en sure that those users are not owners databases SQL Server agent jobs, otherwise you will be confronted with the below error: To avoid this you will need to change both the database and SQL [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/drop-failed-for-login-user-xxx/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/drop-failed-for-login-user-xxx/</feedburner:origLink></item>
		<item>
		<title>Configuring and Creating An AlwaysOn Availability Group in SQL Server 2012</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/TRiwV4TwLVg/</link>
		<comments>http://www.sql-server-performance.com/2012/configuring-creating-alwayson-availability-group-sql-server-2012/#comments</comments>
		<pubDate>Thu, 26 Jan 2012 08:30:08 +0000</pubDate>
		<dc:creator>Arshad Ali</dc:creator>
				<category><![CDATA[Clustering]]></category>
		<category><![CDATA[Developer]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[2012]]></category>
		<category><![CDATA[AlwaysOn]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2842</guid>
		<description><![CDATA[In the previous article on AlwaysOn Availability Groups in SQL Server 2012, we looked at The Environmental Setup for An AlwaysOn Availability Group. In this article we turn our attention to the creation and configuration of the Availability Group. There are two primary steps to creating an AlwaysOn availability group which has to be done [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/configuring-creating-alwayson-availability-group-sql-server-2012/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/configuring-creating-alwayson-availability-group-sql-server-2012/</feedburner:origLink></item>
		<item>
		<title>SQL Server 2012 AlwaysOn Availability Group Environmental Setup</title>
		<link>http://feedproxy.google.com/~r/SQLServerPerformance/~3/-lzkkbrnrco/</link>
		<comments>http://www.sql-server-performance.com/2012/sql-server-alwayson-availability-group-environmental-setup/#comments</comments>
		<pubDate>Mon, 23 Jan 2012 10:12:33 +0000</pubDate>
		<dc:creator>Arshad Ali</dc:creator>
				<category><![CDATA[Developer]]></category>
		<category><![CDATA[General DBA]]></category>
		<category><![CDATA[2012]]></category>
		<category><![CDATA[AlwaysOn]]></category>
		<category><![CDATA[Clustering]]></category>
		<category><![CDATA[high availability]]></category>
		<guid isPermaLink="false">http://www.sql-server-performance.com/?p=2833</guid>
		<description><![CDATA[Continuing from AlwaysOn Part 1 the series continues with a step-by-step guide to setting up the environment for an AlwaysOn availability group. In this article we will break down AlwaysOn environment preparation into three steps : Installation of SQL Server 2012 on each node/replica/server. Installation of the failover clustering feature on each node/replica/server. Creation of [...]]]></description>
		<wfw:commentRss>http://www.sql-server-performance.com/2012/sql-server-alwayson-availability-group-environmental-setup/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.sql-server-performance.com/2012/sql-server-alwayson-availability-group-environmental-setup/</feedburner:origLink></item>
	</channel>
</rss>

