Allen Kinsel - SQL DBA

SQL Server, PASS, and other data mishaps

A call to arms, SQLPASS arms that is

By Allen Kinsel, 8 months and 6 days ago

I need help

 

No not the mental kind, but the volunteer labor kind.

 

Keep reading →

Related posts

Share this post

More PASS Summit SQLKaraoke & Networking

By Allen Kinsel, 8 months and 7 days ago

What does Karaoke have to do with PASS?

 

Luckily, having a moral opposition to karaoke does not preclude you from attending the summit of from volunteering to help SQLPASS grow.  We'll take anyone who wants to help anytime you're willing (more on that tomorrow). 

 

Keep reading →

Related posts

Share this post

SQL Karaoke, Volunteering and SQLPASS

By Allen Kinsel, 8 months and 10 days ago

Why do I volunteer for PASS?

 

Ive been asked more times than I can count why I spend so many hours working for an organization that doesnt pay anything other than thanks and smiles. 

I work for a large company, and have a very small team of people.  As such, it is often very helpful to have a sounding board outside of your sphere of influence to talk to people about ideas, issues and bacon, mostly bacon.  Sure there has always been newsgroups and forums and they certainly have their place for this type of information exchange.  However, when you know someone and have shared a dinner, a beer, a session, or even just a 5 minute hall discussion, they are more vested in you're outcome than some random stranger on an internet forum.   The overall quality of the conversations and of the information that is exchanged in these groups is higher than the average internet sql community, if only by a little bit.  

Keep reading →

Related posts

Share this post

A new blog is born

By Allen Kinsel, 8 months and 10 days ago

A new take on an old idea

As if there aren't already enough blogs around about SQL server I've decided to start and build my own.  For those of you tortured lucky enough to know me you'll know exactly how hard the decision has been to start this blog.

I hope this blog will become a place that I can throw random thoughts about with almost reckless abandon.  I plan on using this place as a sounding board for ideas as well as a place to store my ideas for use at a later time.

I will likely be focusing more on SQLPASS than on SQL Server troubleshooting itself so, this is where this blog will be different from most.  I think SQLPASS could be so much more than it currently is and I intend to do my level best to make that happen

Keep reading →

Related posts

Share this post

Yes a blog lives here Shhh--- Dont tell anyone

By Allen Kinsel, 8 months and 11 days ago

Since Im the only one who reads this, this should be considered a test, and nothing more than a test.  If only I werent so lazy, Id have a fully functioning blog instead of this lousy shell.

Related posts

Share this post

Follow Me


Tags

Allen Kinsel on Twitter

Categories

Most Recent Posts

Subscribe

Archives

Next Posts

Latest comments

  • 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...
    • NULLgarity: This post should win an award. These SSPI errors have cause me all sorts of trouble over the years and are EXTREMELY difficult to troubleshoot. In my experience, they often went away before I even had a chance to look into them. Thanks for the post!
    • Shawn Melton: It's been a while since I have done SA duties with AD but I would be curious too. I actually have a User Group meeting tonight (06/17/10) with an MCT that teaches AD and will ask him if he can explain that authentication mess.
    • Robert L Davis: sys.dm_exec_connections does not tell you what protocol they used to attempt their connection. It tells you which protocol suceeded. Kerberos is ALWAYS tried first and NTLM is used as a failback. So if they show as using NTLM, it's not because they didn't attempt to use Kerberos, its because Kerberos wasn't successful. In my...
  • SQL Saturday 35 Recap:
    • Jen McCown: Cookout, eh? Maybe we'll have the next after party at chez McCown :)

Most commented posts