Check out this blog entry for BgShell a new PowerShell host. I'm just amazed at the endless possibility PowerShell provides. I haven't pulled this down yet, but I could imagine using it to automate common daily tasks. The problem I encounter is I don...

I was recently asked what the exception_message and exception columns in the msdb.dbo.syspolicy_policy_execution_history_internal table are used for. There are situations where the policy evaluate can throw an exception. For example, if the policy references...

I recently sat down with Joey Snow over at TechNet to discuss Policy-Based Management. You can watch the video here .

The February CTP for SQL2K8 included first class support for PowerShell. Many people have ask how they can get started with PowerShell - not just using PowerShell to interact with SQL Server but just using PowerShell in general. PowerShell was a wealth...

Several people have asked me for the presentation Praveen and I used for the Manageability session @ the SQL2K8 Launch event last month in LA. A version of the presentation is available on the DVD that all launch attendees received. However, the version...

Buck Woody, a PM on my team, has launched a new weekly Podcast entitled "Real-World DBA". You can find out more information at his Blog . Here's a link to the first episode . I encourage you to take a listen and provide feedback. This is not a marketing...