20121003200545.jpg

T-SQL Tuesday #75: Jump into Power BI

Posted on

So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it yet, is Microsoft’s analytics and visualization solution. This month I challenged everyone to create their own Power BI report and share it with the world via […]

EPM Framework v4 Released!

Posted on

The Enterprise Policy Management Framework (EPMF) team is proud to announce the updated release of “Enterprise Policy Management Framework 4.0 for project EPMFramework. This is a major release with lots of performance tweaks and The EPM Framework 4.0 includes the following updates: For enhanced support of large environments Reviewed database design, including views and indexing […]

Expiring Databases and Policy-Based Management

Posted on

Today on Twitter my friend Jes “Run Forrest Run” Schultz Borland (Blog | Twitter) asked the Community “How do you clean up your dev environments? Let DBs sit out there forever? Delete after X months? Other? This seemed like an interesting issue to tackle and me being the PBM freak that I am, immediately I […]

Make It Simple With Policy-Based Management

Posted on

At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your development environment. Funnily enough, a few hours later, I see my friend Andie Letourneau (Blog | Twitter) posted a blog on how to adjust your recovery modes in development. While Andie’s homework assignment is to […]

SQL Server Denali CTP3: Policy Based Management

Posted on

Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”. Did you know that the HADR feature actually leverages PBM for checks? Yup, that’s right folks. If you’re an administrator and you’re NOT using Policy-Based Management yet, I highly recommend you pick up a book […]

Policy-Based Management and Local Password Policy

Posted on

This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to create a policy condition that enforces local sql accounts to adhere to password expiration policies. First off, to create the condition itself is relatively easy. Below I’ve provided the T-SQL code so that you can […]

Find Table Heaps Using Policy-Based Management

Posted on

This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already use Twitter, the SQL Community has setup a great resource on there using the hashtag of #sqlhelp. Today a conversation came up due to a forum question over at SQLServerCentral regarding applying policies to databases […]

Policy for Ad-hoc Workloads

Posted on

During my presentation at SQLSaturday 62 in Tampa I was asked by an attendee about having a policy to check the setting for ad-hoc optimization settings. At the time since I was in a bit of a time crunch (and I couldn’t remember the exact facet to look under) I couldn’t properly demo how to […]

EPM Framework and SQL 2008 R2

Posted on

This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentation one of the cool things I cover is how policy-based management can be extended utilizing Reporting Services and PowerShell through the use of an amazing tool called the Enterprise Policy-Management Framework available on Codeplex. Enterprise Policy Management Framework, or […]

PragmaticWorks Webinar – Policy-Based Management

Posted on

This is just a quick note to remind everyone I’ll be presenting tomorrow, Tuesday October 26th 2010 for the PragmaticWorks Free Monthly Webinar Series. The topic (big surprise here) is Policy-Based Management! The webinar runs from 11:00 AM – 12:00 PM EDT and you can register for free here. Hope to see you all there!