Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Then, my last week as a DBA at Advanstar, followed by my first week as a Trainer for ...

In the February CTP of SQL Server 2008 a new feature has appeared in SQL Server Management Studio. You now have the ability to right-click on an object in the Object Explorer window and open up a PowerShell window. In this window you can navigate the database structures much like you can a disk file subsystem, or like you can navigate the ...

In browsing through the SQL Server 2008 SMO Object Library I noticed there are a couple of additional DLL's. For example, the SQL Server WMI Management objects, formerly in Microsoft.SqlServer.Smo.dll, are now in Microsoft.SqlServer.SqlWmiManagement.dll. There's also a new one called Microsoft.SqlServer.SmoExtended.dll. I took a look in there ...

Last December I blogged about a bug in the MailServer object, in that they left out a New() method for creating a MailServer object. The full description of the error and workaround is here and the Connect item I filed on the problem is here.. In browsing through the SMO Object Library for SQL Server 2008 I see they still have not included a ...