July 2010 - Posts

• T-SQL Tuesday #008:Teach a little, Learn a lot

  My mother was a teacher. My wife was a teacher and a principal. My daughter is a teacher. Me, I'm a DBA, but living inside technology and working for one company, it can be hard to really learn about that technology. It's much easier to just do what you Read More... Posted Tuesday, July 13, 2010 4:16 PM by AllenMWhite | 2 Comments

• The Power of sed in PowerShell

  SSIS is a great tool for managing ETL, but in a complex process it's easy to have a lot of packages all referencing the same data source. In testing I found I needed to change all the connection managers in all the packages to a different database. When Read More... Posted Friday, July 09, 2010 11:41 AM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell