May 2011 - Posts

• Flash-y Re-index: Why Defrag on SSD’s?

  Some time ago, I blogged about how to really comprehensively re-index a data warehouse: http://sqlblog.com/blogs/merrill_aldrich/archive/2009/08/09/hexagonal-close-packing-for-your-fact-data.aspx . (Wow, 2009. Time flies.) Today I am reviving that old Read More... Posted Friday, May 27, 2011 5:56 PM by merrillaldrich | 4 Comments

• Case Study: Secure Log Shipping via SSL FTP

  Today I’m putting up sort of an oddball solution I build a couple of months ago. We had the need to provide a reporting copy of some production databases for analysts to do ad-hoc reporting. The trick was that we needed to move the databases from a less Read More... Posted Thursday, May 19, 2011 6:12 PM by merrillaldrich | 1 Comments Filed under: logshipping, powershell, security