June 2008 - Posts

• Making the GO command live up to its fullest potential

  Today I was trying to explain why the GO command is required between the statements of a CREATE PROCEDURE and its code block, and the GRANT EXECUTE statements to grant the rights to the Web Application Account. What was happening was the code was being Read More... Posted Saturday, June 28, 2008 12:32 PM by Jonathan Kehayias | 2 Comments Filed under: Transact-SQL

• 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