Rotating Header Image

Posts under ‘Security’

PWNED! (from beyond the grave)

OK first off if you don’t know the definition of the word PWNED here is a tutorial… So now that you’re well versed on pwned or pwnage let’s talk about a way to ensure that the DBA (who we’ll call “Brent”) that left the company does not get all zombie and start eating your brain after […]

SQL 2008 CMS Security

So we’ve recently adopted the use of SQL Server 2008’s Central Managment Server for our development team.  Something that tends to get missed or not talked about in articles about CMS is the security required to connect and view the Central Management Server. There are 2 MSDB database roles that relate to the Central Managment […]

Podcast: Auditing With SQL Server 2008

Well here we go.. my first podcast. Big thanks to Brent Ozar for helping both by critiquing the video ahead of time (and providing some very valuable feedback) as well as offering to encode, setup, and host the video on In watching the video on SQLServerPedia I’m already thinking of ideas for topics of […]

EDMPASS – July Meeting

In July the Edmonton Chapter of PASS is going to have it’s 2nd meeting. Details below: Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.  Date:  July 29th 2009 Time: 5:00 pm – 7:00 pm Location: Stanley A. Milner library […]

Running SSIS Packages – Security

So as most of my blog articles this post is inspired by an email I received asking for permissions to run SSIS packages.  In SQL Server 2005 there are 3 Database Roles in the msdb system database: MSDN Integration Services Roles 2005 Role Read action Write action db_dtsadmin Enumerate own packages. Import packages. or Enumerate all […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.