PROBLEM: You need to script all the tables from a database. Each table needs to be on its own file so they can be added to a source control repository. SOLUTION: The use of SQL Server PowerShell Extensions (SQLPSX) facilitates the solution I’m about to show. The first example is a straight to the point, … Read more
PROBLEM: You have a directory with many files and would like to change the extension on many of them without having to do one by one. SOLUTION: You can solve this problem with PowerShell and in less than 3 lines of code. CLEAR CD [PATH TO FILE LOCATION] Get-ChildItem *.[FILE EXTENSION]|Rename-Item –NewName {$_.Name –replace “[FROM … Read more
I got a copy of this book back in September of 2009 because I wanted to know more about the hardware configuration of production database servers. Specifically, I wanted to know about best practices and recommendations in the areas of storage, memory and CPU. While at the store, I read chapter 2 “Storage and System … Read more