I read about T-SQL Tuesday #15 this evening while riding the train on my way home; I need to get in the scoop of these events when they first come out. How to Review SQL Logs with PoweShell describes one of the many scripts I created in PoweShell to automate my daily tasks. I have … Read more
During a smoke break, Mike and Pat (two suits for a global consulting firm) were having one of those vainglorious conversations about who spends more on what, who has the larger whatever and who has the latest gadget. Their conversation was interrupted as the CTO and smoking pal, Jeff showed up and joined the two … Read more
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 … Read more
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
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
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more