<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.mssqltips.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Chad Boyd - All Comments</title><link>http://blogs.mssqltips.com/blogs/chadboyd/default.aspx</link><description>MSSQLTips - SQL Server Blog</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>wan accelerator</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/15/katmai-sql-2008-data-compression-including-backup-compression.aspx#2196</link><pubDate>Wed, 12 Nov 2008 09:15:24 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:2196</guid><dc:creator>wan accelerator</dc:creator><description>&lt;p&gt;Bangor car dealers and realtors: It’ s a race to see who can rip you off the most.&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=2196" width="1" height="1"&gt;</description></item><item><title>Restore-SqlDb - Automate a Database Restore (improved with Powershell) - Chad Boyd</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/10/14/invoke-nz-powershell-script-similar-to-nz-vba-function.aspx#1975</link><pubDate>Tue, 14 Oct 2008 14:42:04 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1975</guid><dc:creator>Restore-SqlDb - Automate a Database Restore (improved with Powershell) - Chad Boyd</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Restore-SqlDb - Automate a Database Restore (improved with Powershell) - Chad Boyd&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1975" width="1" height="1"&gt;</description></item><item><title>Restore-SqlDb - Automate a Database Restore (improved with Powershell)</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/10/04/try-catch-finally-with-powershell.aspx#1974</link><pubDate>Tue, 14 Oct 2008 14:42:03 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1974</guid><dc:creator>Chad Boyd</dc:creator><description>&lt;p&gt;UPDATE: This script requires the Invoke-TryCatch.ps1 and the newly posted Invoke-Nz.ps1 scripts as well&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1974" width="1" height="1"&gt;</description></item><item><title>Invoke-Nz - Powershell script similar to Nz VBA function</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/10/12/restore-sqldb-automate-a-database-restore-improved-with-powershell.aspx#1973</link><pubDate>Tue, 14 Oct 2008 14:38:03 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1973</guid><dc:creator>Chad Boyd</dc:creator><description>&lt;p&gt;I got a few pings about the Restore-SqlDb script requiring the Invoke-Nz script to execute - here it&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1973" width="1" height="1"&gt;</description></item><item><title>Automate a Database Restore - Chad Boyd</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/10/12/restore-sqldb-automate-a-database-restore-improved-with-powershell.aspx#1962</link><pubDate>Mon, 13 Oct 2008 04:08:26 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1962</guid><dc:creator>Automate a Database Restore - Chad Boyd</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Automate a Database Restore - Chad Boyd&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1962" width="1" height="1"&gt;</description></item><item><title>Restore-SqlDb - Automate a Database Restore (improved with Powershell)</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/07/29/automate-a-database-restore.aspx#1961</link><pubDate>Mon, 13 Oct 2008 04:01:54 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1961</guid><dc:creator>Chad Boyd</dc:creator><description>&lt;p&gt;A while back I posted on Automating a Database Restore and it was quite a popular post, I also received&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1961" width="1" height="1"&gt;</description></item><item><title>Estimating Data Compression ratios for all...</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/15/katmai-sql-2008-data-compression-including-backup-compression.aspx#1859</link><pubDate>Mon, 22 Sep 2008 22:41:38 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1859</guid><dc:creator>Chad Boyd</dc:creator><description>&lt;p&gt;One of my favorite features with SQL 2008 has been Data and Backup compression (which I discuss in more&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1859" width="1" height="1"&gt;</description></item><item><title>MERGE statement syntax modified</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/11/01/katmai-sql-2008-merge-more-than-upsert-more-advanced-uses.aspx#1826</link><pubDate>Tue, 16 Sep 2008 18:03:38 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1826</guid><dc:creator>Michael Zilberstein</dc:creator><description>&lt;p&gt;This is probably known to all but I've just found out - MERGE command syntax had been modified since&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1826" width="1" height="1"&gt;</description></item><item><title>re: Automate a Database Restore</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/07/29/automate-a-database-restore.aspx#1659</link><pubDate>Wed, 20 Aug 2008 04:18:04 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1659</guid><dc:creator>primer200</dc:creator><description>&lt;p&gt;Great post!&lt;/p&gt;
&lt;p&gt;Most of the times we require restore a database to another server to a point in time. All we know is the orginal server name, database name, the target server name, target database name, the file path for mdf and ldf files on the target server and a point in time. &lt;/p&gt;
&lt;p&gt;In this case we need first query the msdb of the original server to get a list of files and its location required to restore to the point in time. If you can include this, I rekon the sp is even more useful. I have done this myself, but I I had to use some ugly coding such as cmdshell. &lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1659" width="1" height="1"&gt;</description></item><item><title>Link Listing - July 29, 2008</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/07/29/automate-a-database-restore.aspx#1529</link><pubDate>Wed, 30 Jul 2008 13:49:17 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1529</guid><dc:creator>Christopher Steen</dc:creator><description>&lt;p&gt;Sharepoint Silverlight Drag, Drop, Import and Export [Via: Michael Washington ] Creating a WSS / MOSS...&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1529" width="1" height="1"&gt;</description></item><item><title>Link Listing - July 29, 2008</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/07/29/automate-a-database-restore.aspx#1528</link><pubDate>Wed, 30 Jul 2008 13:48:38 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1528</guid><dc:creator>Christopher Steen</dc:creator><description>&lt;p&gt;Link Listing - July 29, 2008&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1528" width="1" height="1"&gt;</description></item><item><title>re: SERIALIZABLE isolation level (serialized transactions) and duplicate key insertion attempts</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/15/serializable-isolation-level-serialized-transactions-and-duplicate-key-insertion-attempts.aspx#1377</link><pubDate>Wed, 09 Jul 2008 03:35:52 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1377</guid><dc:creator>aprato</dc:creator><description>&lt;p&gt;Nice, Chad!&lt;/p&gt;
&lt;p&gt;The blocking behavior is something I&amp;#39;ve seen before and it makes sense if you think about it. &amp;nbsp;The lock manager doesn&amp;#39;t know what you&amp;#39;ll ultimately be doing with all the rows locked in the range... you could be deleting them all for all it knows.&lt;/p&gt;
&lt;p&gt;PS: I tried to give your article a 5 star rating but my fat, flabby, sausage-like fingers mis-clicked&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1377" width="1" height="1"&gt;</description></item><item><title>My interested stuff(2008-07-02)</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/06/29/installing-clustered-sql-servers-outline-checklists-document-sheets.aspx#1366</link><pubDate>Sat, 05 Jul 2008 02:10:06 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1366</guid><dc:creator>代码乱了</dc:creator><description>&lt;p&gt;BTDex-EasystringcompressionandencryptionJamesAvery-JulyLoungeUpdateandCheckingyourS...&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1366" width="1" height="1"&gt;</description></item><item><title>Link Listing - June 30, 2008</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/06/29/installing-clustered-sql-servers-outline-checklists-document-sheets.aspx#1329</link><pubDate>Tue, 01 Jul 2008 10:25:55 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1329</guid><dc:creator>Christopher Steen</dc:creator><description>&lt;p&gt;ASP.NET How to use the IHttpAsyncHandler in ASP.NET [Via: Mads Kristensen ] SQL Server SQL SERVER -...&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1329" width="1" height="1"&gt;</description></item><item><title>Link Listing - June 30, 2008</title><link>http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/06/29/installing-clustered-sql-servers-outline-checklists-document-sheets.aspx#1328</link><pubDate>Tue, 01 Jul 2008 10:25:27 GMT</pubDate><guid isPermaLink="false">ef11a07c-6ae8-4192-a8c7-2f25c1b79fe4:1328</guid><dc:creator>Christopher Steen</dc:creator><description>&lt;p&gt;Link Listing - June 30, 2008&lt;/p&gt;
&lt;img src="http://blogs.mssqltips.com/aggbug.aspx?PostID=1328" width="1" height="1"&gt;</description></item></channel></rss>