PROBLEM: You need to script all stored procedures from a database.  Each stored procedure needs to be on its own file so you can add them to a source control repository. SOLUTION: The solution here is a variation of what we did for “How to Script All Tables From a Database with PowerShell”.  The only difference […]

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, […]

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 […]

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 […]

SESSION I – BLITZ! 60 Minute SQL Server Takeovers This past Friday I received an email from a co-worker about the virtual event hosted by Brent Ozar, Buck Woody, Kevin Kline and Ari Weil. I have to admit I deleted the message because I get tons of emails during the day and did not have […]

Bill Karwin style and choice of arranging the material within the chapters made it an easy read. It includes good and accurate examples the reader can test in almost any database system. Overall, the book will save the inexperience from many failures and embarrassment. I purchased this book hoping to find something new. Unfortunately, I […]

I recommend this book to all database administrators who still have not jumped in and executed their first PowerShell command.  I know of several DBAs who for one excuse reason or another, keep postponing their exposure to the next generation command line shell.  This volume makes a good first PowerShell book for DBAs.  It covers […]

PROBLEM: You manage many MS SQL servers and need an easy way to review jobs that have failed. SOLUTION: I will show you one way to accomplish this task with results displaying on the screen or to a file. To make your life easier, I recommend you download & install PowerGUI from Quest Software. This […]

PROBLEM: You need to find out which computers and servers in my network have an instance of MS SQL installed. SOLUTION: In this solution we’ll create an instance of the Windows Management Instrumentation (WMI) for each computer in a list. We’ll then query the Win32_Service class for the existence of a service which name starts […]

PROBLEM: I need an easy way to script out all the tables from a database in MS SQL 2000 and above. SOLUTION: Like anything in programming, there are a thousand ways to skin a cat. Here, I’ll show you the simplest way I found to meet this request. Go ahead and open a new session […]