In the past month I’ve answered a couple of questions similar to: Is there a database role I can assign (other than dbo) that will allow a user to "see" stored procedures.  As it is, I have granted the user db_datareader so, from SSMS, they can see tables but no stored procedures.  Is there a way to "give" them ...

The other night I was asked on Twitter by Todd McDonald (Twitter), for a build list for SQL Server 2005 and 2008.  My initial response was to provide a link to the SQL Server Build List Blog, which documents all of the builds of SQL Server and provides links to the KB articles associated with the builds.  However, this wasn’t what Todd ...

I asked this on twitter and now I am going to ask it on here to see what kind of responses I get.  If your SQL Server services run under a domain user account, is NT AUTHORITY\SYSTEM (Local System) a sysadmin in your SQL Server and if so, why? I was prompted to ask this question while configuring a server early today and after installing SQL ...

Part of the reason for a reduction in the amount of blogging that I have been doing is that I have tried to expand the amount of information that I put into writing up a topic and instead of blogging those topics, publish them as articles online.  My most recent article was just published on SQL Server Central and is titled “Using a ...

If you have a multi-instance SQL Server 2005/2008 Server that is behind a firewall, and you want to be able to remotely connect to the DAC, you have to create firewall rules that allow the TCP ports for the DAC through the firewall.  You can easily set the port that the SQL Server Instances listen on using the SQL Server Configuration ...

As a DBA I have all kinds of elevated access that most people don't.  I guess when I was younger this was a novelty but it really isn't anymore.  I have access to the master list of usernames and passwords for all kinds of stuff, but would never use them for anything unless it was appropriate to do so.  So it really aggravates me ...