August 2009 - Posts

• PowerShell to Validate SAN File Migration

  This post is a bit off topic for SQL Server proper, but I thought someone out 'oogling teh inter-tubes might find it useful. Our group recently had to perform a large SAN migration both to new equipment and to a new geographic location. We started with Read More... Posted Monday, August 31, 2009 1:03 PM by merrillaldrich | 4 Comments Filed under: powershell, ssis

• Parameters, Perms and Procs: Are You Really Protected from Injection?

  In my last post, Top 10 T-SQL Code Smells , I caught some flack got some feedback for including one (#3) about the use of Stored Procedures for Select statements. Several people expressed objections over the risk of SQL Injection, and how Stored Procs Read More... Posted Monday, August 24, 2009 2:29 PM by merrillaldrich | 5 Comments Filed under: injection, security, stored procedures

• Top 10 T-SQL Code Smells

  I enjoy forums, and lately I've been really enjoying Stack Overflow. The few, but important enhancements the Stack Overflow team has made to the forum notion, such as easily ranking solutions, separating solutions and commentary into separate channels, Read More... Posted Tuesday, August 18, 2009 2:55 PM by merrillaldrich | 26 Comments

• Goldilocks and her Yugo Mechanic: A Parable

  It is my belief that everyone in IT eventually faces the Yugo Mechanic's Dilemma . After Goldilocks ran away from the Three Bears' cottage, she decided she needed some wheels. She knew that transportation would be useful, but she didn't know all that Read More... Posted Thursday, August 13, 2009 4:33 PM by merrillaldrich | 2 Comments

• Hexagonal Close Packing for your Fact Data

  Disclaimer : It's likely you don't really want to do what I am proposing in this post. This is just an esoteric defrag process, which won't really deliver much performance benefit but carries a fair amount of risk. I present it purely as a curiosity. Read More... Posted Sunday, August 09, 2009 9:00 PM by merrillaldrich | 2 Comments