February 2009 - Posts

• SQL Injection

  I've been teaching a class called SQL Server 2008 for the Oracle DBA in a number of cities in the US and Canada. I helped build the class last summer and it's truly enjoyable to bring the technology of Microsoft SQL Server to people whose careers have Read More... Posted Saturday, February 21, 2009 3:09 PM by AllenMWhite | 2 Comments Filed under: Database Administration

• SMO Changes from SQL 2005 to SQL 2008

  A year ago in anticipation of publishing a book on SMO (which never came to be) I wrote a number of chapters demonstrating how to manage specific sets of objects, and I provided examples in VB.Net, C# and PowerShell. As should be expected, I thoroughly Read More... Posted Friday, February 20, 2009 10:17 AM by AllenMWhite | 7 Comments Filed under: SMO, PowerShell, SQL Server 2008

• Finding Your Default File Locations in SMO

  I love the fact that you can get information about your SQL Server installations from SMO, and then you can use that information in scripts. This allows you to create one script for some function, like to create a database, for example, and run it on Read More... Posted Thursday, February 19, 2009 1:31 PM by AllenMWhite | 6 Comments Filed under: SMO, PowerShell, Database Administration

• Use PowerShell to Retrieve your Server Inventory

  I've recently completed a chapter for Paul Nielsen's SQL Server 2008 Bible on Scripting with PowerShell. While writing the chapter I created a short script to do a quick inventory of SQL Server information. Right after I wrote the chapter I was on a consulting Read More... Posted Wednesday, February 18, 2009 1:49 PM by AllenMWhite | 4 Comments Filed under: SMO, PowerShell, Database Administration

• Get a Quick Review of SQL Server Information

  It can be tedious to keep a list of the version, edition or other information on each of the servers you manage. SMO provides an easy way to return this information, and PowerShell provides a quick way to get to SMO. Sometimes you may not know if a server Read More... Posted Sunday, February 01, 2009 5:22 PM by AllenMWhite | 2 Comments Filed under: SMO, PowerShell, Database Administration