Allen Kinsel - SQL DBA

SQL Server, SQLPASS, and other random things

About

I am a lead database analyst with a large multi line insurance company.  I have been with my current employer going on 10 years so, I must be doing something right!!  While I spend a good deal of my time supporting databases of all types, styles, and shapes (yes SYBASE still exists) I do occasionally have time for other things.

I am very active volunteer with SQLPASS holding many different titles within the organization since I started helping in 2005.  I currently am manager of the program committee and I also attempt to help with the volunteer committee.

My duties with the program committee pretty much encompass everything you see that has to do with education while attending the SQLPASS Summit

I am an avid fisherman (#1 target is yellowfin tuna) , palm tree fanatic, and occasionally I like to kid myself that I can take pictures.

I have the best, most supportive Wife and family anyone could ever wish for and they enable me to succeed at life

If you need to get in contact with me for any reason  try

Share this post

Comments disabled

Comments have been disabled for this post.

Trackbacks disabled

Trackbacks have been disabled for this post.

Tags

Allen Kinsel on Twitter

Categories

Most Recent Posts

Subscribe

Archives

Next Posts

Latest comments

  • Whose got my DAC?:
    • Allen Kinsel: They might not be too happy about that but, hopefully you know who they are and can contact them before killing their session, if you cant get a response and its an sleeping connection, then out comes the KILL command!
    • Jack Corbett: Wonder what the person on the other end would think if you killed their connection.
  • PASS TPS #1:
    • AjarnMark: Allen, keep up the writing! This type of transparency into the process and efforts that it takes to put together such a phenomenal event as the Summit is great!
    • Andy Warren: Allen, I hope you'll write a LOT about the efforts of the program committee. There's a lot of good/hard work that gets done there and I think we need to share that. And when things go wrong - like the sessions counts - that's ok too, good to let everyone know that we know something...
  • SQL Active Directory User ID SID Mismapings:
    • Allen Kinsel: Awesome, one of these days Im going to get a lot better at Powershell, thanks for sharing!
    • Chad Miller: Powershell and .NET will also work. From sqlps: PS SQLSERVER:\SQL\Z002\SQL2K8> invoke-sqlcmd -Query "select name, sid from sys.server_principals where type IN ('U','G')" | foreach {add-member -in $_ -membertype noteproperty SSDL (new-object security.principal.securityidentifier($_.SID,0)).ToString() -passthru} | where {$_.SSDL -eq 'S-X-X-X-X'}
  • Using Aliases with SQL Server:
    • Ken: I'm currently in a migration that will be making use of dns aliases, and have done some testing of moving from a default instance to named instances. You actually can use this still for moving applications from one named instance to another, you have to configure your named instances to listen on the default...

Most commented posts