Best Practice Policies for Policy-Based Management

Policy-Based Management (PBM) was introduced with SQL Server 2008 – it’s a declarative system for ensuring the system configuration hasn’t drifted from the original configuration intent.  You can read more about Policy-Based Management in SQL Server Books Online, here. To help people get started with PBM and to promote best practices we provide a set…

1

Loading SQL Server Snapins into your PowerShell Session

Caveat: I don’t write code for a living. But I do know how to get things done, usually using brute force. SQLPS.exe is a decent environment, but sometimes I want to work in the default PowerShell environment. But if I want to work with SQL Server in the default PowerShell shell it means I need…

4

Central Management Servers => Shared Connection Favorites

Back in SQL Server 2008 my team implemented the Central Management Server (CMS) feature. If you work as part of a DBA team and you haven’t tried it out I encourage you to do so. It’s available on all editions, even Express. In short, the CMS allows you to share entries in registered servers with…

3

New SCOM Management Pack for SQL Server 2005, 2008, 2008 R2

Last week we released an updated, almost completely revamped, System Center Operations Manager Management Pack for SQL Server 2005, 2008, and 2008 R2. You can find all the details on the download page here.

0

NEW! SQL Server Setup Portal

I know I shouldn’t be but when I talk to DBAs I’m amazed how much time is spent installing/configuring the product. Having worked on the SQL Setup team for the SQL Server 2005 release I have an appreciation of how complex setup is from both sides: internal development and the end user. We just launched…

0

Perfect Conference Storm

November is shaping up to be the perfect storm of conferences. In a time when budgets are extremely tight it amazes me that we have 4 conferences to cover in November.   SQL PASS When: November 2-5, 2009 Where: Seattle, Washington Site: http://summit2009.sqlpass.org/ Sessions: 2 focused on SQL Server 2008 R2/Visual Studio 2010 SQL Connections…

0

PBM – it’s like liquid awesome!

Brent Ozar and Thomas LaRock do a 3 part video series on the power of Policy-based Management (PBM). Interestingly SCOM comes up several times in the discussion.   They cover the basics of PBM and Thomas goes into more depth on how he’s using it in his environment. The series is about 35 minutes in…

0

PCI Compliance and SQL Server 2008

Today compliance is a huge focus area for IT. Since compliance is written by lawyers for lawyers it takes a fair amount of translation to get it to the point where IT can understand what processes, policies, and configuration to implement to meet the requirements for a given compliance spec. If you are a SQL…

1

Using PowerShell to Get Data & Log File Sizes

I was playing around with PowerShell today (yes I’m was geeking out on Saturday afternoon) to learn how to access Performance Counters using PowerShell. My mission was to write a script that would return the Data File and Log File sizes for each database and a total for the instance. The good news is SQL…

3

www.sqlserverenergy.com

Check out the new SQL Server site!

3