Creating Basic Policies in SSMS

Policies were introduced in SQL 2008 as a way to enforce or confirm user defined rules. SQL MVP Brian Knight ideo shows you how to create basic policies in Management Studio.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

suvankar on 6/24/2009

great video

Bala on 6/24/2009

nice

Travis on 6/24/2009

Most of these policies created in this video are already predefined policies that you can just import. No need to create them yourself. They are XML files under the Program Files\Microsoft SQL Server\100\Tools\Policies\Database Engine\1033 directory.

Travis on 6/24/2009

I would also make sure that each database has its Trustworthy bit off as well. It is off by default but it is always good to add this check just to be safe too. Checks whether the dbo or a db_owner is assigned to a fixed server sysadmin role for databases where the trustworthy bit is set to on. Database users with the appropriate level of permissions can elevate privileges to the sysadmin role. In this role, the user can create and execute unsafe assemblies that compromise the system. So, the best practice is to turn off the trustworthy bit or change the dbo and db_owner to a fixed server role other than sysadmin.

EDE1C31671 on 6/24/2009

Very good tutorial.

Rubens on 6/24/2009

Excellent video, love them and keep it coming!

833DC6E792 on 6/24/2009

Can't hear the speaker

Jamshid Nouri on 6/24/2009

great demo

Suresh on 6/28/2009

Another nice useful presentation from brian knight

Suresh on 6/28/2009

Good work BK.

Syed Arshad on 7/18/2009

Sound is not clear and very low

Marshall Cole on 7/20/2010

Brian, as only you can demand people to understand, but suttle. Once again, THANK YOU!!! Marshall