Skip to main content


Showing posts from March, 2011

Blog Syndication

I got sent an email recently asking  how I went about syndicating my blog on some of the popular SQL Server sites. It is a very straight forward process that involves the sites that I syndicate on making use of my RSS feed. As someone took the time to send me an email to ask the question, I thought that there might be others out there who would appreciate knowing this stuff too so I thought I’d put together a short post.For those of you that don’t know, my blog ( is syndicated over at (SSC) and (SSP). Both these site will happily syndicate your blog and give you attribution for your work. For those of you who do blog and would be interested, this is how it works on each of these The great thing about SCC is that you can either use their blog platform to host your blog or you can syndicated you content there and maintain a separate blog all of your own. I chose the later mainly for the fl…

Becoming a DBA: How to gain experience

Last week I had an interesting telephone call from a someone who I connected with on On Linkedin I’m what they call an “open networker” which means I won’t click on ‘I don’t know you’ if you send me a connection request. If I don’t want to connect with you then I’ll simply archive your message/request.  I use primarily for work and business. I use it to connect with fellow DBAs and database professionals  and I also connect with recruiters/agents whose business is to fill SQL Server contract roles. At the time of writing I’m well over 500 connections but have a fair way to go before I get to 1000. If you would like to connect please do feel free to send me a request here.
A SQL person sent me a connection request which I accepted  and he then sent me an email and then phoned me up asking if I would help him out. The crux of the phone call was around him getting more experience using SQL Server. He has a Virtual Lab set up with a SQL Server in it, he wanted m…

Stored Procedure Definitions and Permissions

I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database role in SQL Server. You can read that post here. This post is going to build on that concept of using database roles for groups of users and allocation permissions to the role. I recently had a situation where a tester wanted permission, for themselves and the rest of the testing team, to look at the definition of all the stored procedures on a specific database, strangely enough for testing purposes. I thought for a while on how best to grant this permission, I did not want to grant the VIEW DEFINITION permission at the server level or even the database level. I just wanted to grant for all the store procedures that existed in the test database at that time. This is the solution I came up with:
Create a database role in the specific database called db_viewspdef
CREATEROLE [db_viewspdef] GO

I then added the tester windows group to that role:
USE [AdventureWorks] GOEXEC sp_addrolem…