Allen Kinsel - SQL DBA

Latest comments

• Allowing effective developer access to SQL Server:
  • Karen Lopez: Another approach I use: Be generous in granting privileges in the DEV database (but still lock down the server environment), but don't let Devs promote any DDL to the next environment. Only the DBAs can deliver/apply DDL to the next (usually QA) environment. So if the devs modify their tables/columns without the architect...
• PASS Summit Community Choice Session results revealed:
  • Andy Warren: Allen, nice job on this. Great to see the community get a chance to participate in building the program and share in the excitement of the upcoming Summit. Andy
• Community Choice Sessions at the PASS Summit 2010:
  • Allen Kinsel: Thanks, We hope that this will be a good test of community selections, and hope to expand it a bit in the future
  • robert cook: glad you decided to keep blogging and gracias to you and your amigos for giving an opportunity to the sql community for direct involvement with session choices
• Sql Server and SSPI handshake failed error hell:
  • Robert L Davis: I agree about the reboot. That's why I check SPN's before DC/Kerberos errors. An SPN can be fixed without rebooting, but if the issue is DC connection and no one can log in to the SQL Server, you're down anyway so a reboot shouldn't be out of the question. The problem with having a...
  • Allen Kinsel: I guess should have worded that a little differently, in my experience in a lot of environments kerberos isnt used since its not configured, so it always falls back to NTLM, with only NTLM and no Kerberos in the result list, its usually safe to say that SPN's arent the issue. I...