Browse by Tags

• Articles
• Configuration
• Transact-SQL

• Creating a Database Role to Allow Users to Script Object Definitions

  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, Read More... Posted Wednesday, August 04, 2010 11:47 PM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Security

• SQL Server Installation Checklist

  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 Read More... Posted Monday, March 22, 2010 11:31 PM by Jonathan Kehayias | 22 Comments Filed under: Configuration, Database Administration, Security

• Question: Is NT AUTHORITY\SYSTEM a sysadmin in your SQL Server and Why?

  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 Read More... Posted Wednesday, January 27, 2010 10:10 PM by Jonathan Kehayias | 11 Comments Filed under: Database Administration, Security

• New Article on SQL Server Central: Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail

  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.  Read More... Posted Thursday, December 17, 2009 3:58 AM by Jonathan Kehayias | 1 Comments Filed under: Articles, Database Administration, Security, Transact-SQL

• Customizing the TCP Port for the Dedicated Administration Console (DAC)

  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 Read More... Posted Friday, June 26, 2009 1:30 AM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Security

• Securing Production Servers from Developers with SSMS and Application Usernames/Passwords

  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 Read More... Posted Wednesday, June 18, 2008 1:28 PM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Security