SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: 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… Read more

0 comments, 1,714 reads

Posted in The SQL DBA in the UK on 21 March 2011

Becoming a DBA: How to gain experience

Last week I had an interesting telephone call from a someone who I connected with on linkedin.com. 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…

Read more

1 comments, 1,681 reads

Posted in The SQL DBA in the UK on 16 March 2011

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…

Read more

4 comments, 2,771 reads

Posted in The SQL DBA in the UK on 14 March 2011