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 17, 2011 | SQL Server Blog, SQLServerPedia Syndication |
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to SQLServerPedia category in the SQLServerPedia.com’s inaugural blogger awards. Quest sent all those nominated a nice prize pack of notepad, pen, T-shirt and best of...
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...
Dec 30, 2010 | SQL Server Blog, SQLServerPedia Syndication |
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The long and short of it, these were the people whose blog’s I had read the most throughout the year. There are many other great blogs and bloggers out there that...
Dec 29, 2010 | SQL Server Blog, SQLServerPedia Syndication |
Hopefully my title gives away what this post is about. This my list of the top five people or more precisely their blogs that have made most use out in the year gone, I am not going to put them in any specific order they all add to my knowledge in different ways:...
Dec 18, 2010 | SQL Server 2005, SQLServerPedia Syndication |
Steve Jones mentioned recently that SP4 for SQL Server 2005 is on its way because Microsoft closed his connect item. Well looks like it was released yesterday, you can download it here:...
