Jul 14, 2011 | DavidP, Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 |
written by David Postlethwaite Ever wondered who has what access to your database or a particular object within? With the ever increasing need to keep permissions to a minimum this is becoming more important. If you are using Active Directory groups to assign...
Jun 15, 2011 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, Virtualisation |
After posting on twitter last week that I needed something to write a blog post about my good friend Christian Dadswell (Blog|Twitter) suggested I post the queries I wrote for him awhile back to dig him out of hole. Chris has dug me out of many a hole when I have...
Jun 14, 2011 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, Virtualisation |
After posting on twitter last week that I needed something to write a blog post about my good friend Christian Dadswell (Blog|Twitter) suggested I post the queries I wrote for him awhile back to dig him out of hole. Chris has dug me out of many a hole when I have...
Mar 14, 2011 | Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerPedia Syndication |
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...
Jan 26, 2011 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Blog |
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance Plans” Here is a link if you want to read it: http://www.sqlservercentral.com/articles/Backup+/+Restore/72234/ If you...
Jan 4, 2011 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Blog, SQLServerPedia Syndication |
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in task manager) is mapped to which specific instance of SQL Server running on a server, if you have a multi-instance server and the account running...
