Archive for year 2013

Finding impersonation info in SQL Server

Since SQL Server 2005 we’ve been able to grant one login the ability to impersonate another in order to have a different set of effective permissions.  More than a few times I’ve found this paradigm useful in order to solve problems while adhering to the principal of least privilege and likewise more than a few times I’ve tried to find information about who has impersonation privileges in SSMS and have been severely disappointed to find that it is buried.  This extremely simple script solves that problem and gives all of the information about who has impersonation rights on an instance.


If you want to read more about all the fantastic things you can do with EXECUTE AS and impersonation, MSDN is a good place to start

SELECT AS WhoCanImpersonate ,
        grantee_principal.type_desc AS ImpersonatorType , AS WhoCanTheyImpersonate ,
        sp.type_desc AS ImpersonateeLoginType

FROM    sys.server_permissions AS prmssn
        INNER JOIN sys.server_principals AS sp
            ON sp.principal_id = prmssn.major_id
               AND prmssn.class = 101
        INNER JOIN sys.server_principals AS grantee_principal
            ON grantee_principal.principal_id = prmssn.grantee_principal_id
WHERE   prmssn.state = 'G'

The Community Has Spoken

This years election results are officially in the books.  Unfortunately I’ve come up four votes short in my effort to be elected.

I’d like to congratulate the winners, I’m sure y’all will do great things.  Dont worry, we’ll all be watching to see you make good on those campaign promises!

I’d also like to thank all of my supporters, public and private.  Your words helped me more than you’ll likely ever know.

Andy Warren in particular was abolutely critical in helping me strategize through this years campaign.  I wouldn’t have made it this far without his support and encouragement over the years.





Wrapping up my campaign

Just do it!

According to the published timelinethe 2013 iteration of the PASS Board elections will be over in just a few hours.  As I wrap up this year’s campaign I wanted to send out a huge thank you to the SQL community members who have supported me in my endeavor to have a second term on the Board.  I am humbled to have such a great and supporting group of friends and colleagues.

I hope that my writings have proven helpful by detailing my visions for PASS and that you have already chosen to select my name on the ballot.  However, if you haven’t voted yet, or just haven’t seen enough of my ideas for making PASS a better place, please check out my elections page for plenty more information.

I’m Allen Kinsel, I hope you’ll vote for me and I approve this message

Being a Better Director if Reelected

Happily, It’s Friday and as I was looking at all the digital bits I’ve spilled in this campaign, I realized there was one more topic I wanted to draw your quick attention to: Things I want to do better this time

  • I need to remember that communication is key and telling you what I ‘m working on is at least as important as what I’m working on.  In my first term, particularly towards the end, I sometimes sacrificed communication in order to get something done.  You need to see what I’m doing (or not doing) and be able to give feedback if you think I’ve headed in the wrong direction.
  • I want to get back to doing a better job of utilizing volunteers.  Aligning work and volunteers is hard.  As anyone who has lead a chapter, a SQLSaturday or any kind of volunteer effort know, it often feels easier and faster to just do things than to delegate things.  I had good success with delegation in the program committee and am prepared to return to a similar model during this term.  My success should not be measured by how much I do personally but rather by how much gets done within my portfolio.
  • I want to think “International” every time I start on something new.  Not because it’s the cool community buzzword but because I want PASS to serve everyone and I know I don’t have enough experience to know what will or won’t work in other countries.

That’s it for the week.  Thanks for reading and thanks for voting!  Have a great weekend!

My PASS Network

When I started volunteering for PASS nine years ago I was focused on contributing and helping where I could. I met a few people, volunteered some more, met a few more people, and somehow before I knew it I was serving on the PASS Board.  I learned a lot, tried to help people where I could, had a lot of fun and without thinking about it much at all, had built a network

Once I had decided to run for the board again I decided to ask my network, the people I’ve worked with, for their help in my campaign.  I asked for help reviewing my application, for help preparing for the NomCom interview, and I asked, awkwardly and reluctantly, for their public endorsements.  I am lucky enough to have had many of them answer my call for help and I am humbled by what many of them have said publicly about my efforts and PASSion for PASS.  It would be impossible for me to say that I’m not thrilled in getting these pillars of our communities support for my campaign but the reality is I am equally as happy to know that each of them have recognized the work and effort I’ve put forth for PASS over the years.

Here are a few hand selected quotes from my supporters writings 🙂

Karen Lopez:

“Allen Kinsel should be your very first vote for the PASS Board. His passion for the community and chapters is perfect. In fact, he continued his volunteering and continued to work on Board-level projects during his brief time off the Board”

Andy Warren

“We were colleagues for a year during his first term on the Board and I found him to be hard working, thoughtful, and always willing to listen to other points of view – exactly the qualities a Board member needs!”

Andy Leonard

“Allen has a good sense of the inner workings of the PASS Board. He brings extensive experience with the SQL Server Community, as well.  I think both are important, and that’s why I’m voting for Allen.”

Tom Larock

“Allen Kinsel’s dedication and passion for the members of the PASS Community is second to none.”

Grant Fritchey

“I absolutely believe that Allen has the best interests of this organization at heart. He wants to make a difference for the better. More than that, I’ve seen him working as a volunteer within the organization where he does make a difference, does make things better. He brings passion to the job.”

Allen White

“as head of the Chapter program has helped countless user group chapters come into being and thrive. I think this success warrants a return to the board.”


Rob Farley

“There are few people who can influence PASS like Allen Kinsel. The impact that he while had on the board before was nothing short of remarkable. I’ll be voting for Allen because I know he will serve the community wholeheartedly, throwing his all behind making the SQL community stronger.”

Jeremiah Peschka

“Allen is hard working, thoughtful, and dedicated to making PASS a great organization for the members”

Brian Kelley

“Allen knows how to do the job, can do the job, has the experience for the job, and the passion for the job. I can’t say that about any other candidate, as good as they are. That’s a key reason Allen stands out to me”

Wayne Snyder

“There are a couple of things I look for in a Board Member for PASS. Long Term Committment to the community and to PASS, whatever you promise – you must deliver, demonstrated ability to work with and motivate other community leaders, and PASSion. Allen has shown all of these traits during his long experience with our organization and our volunteers and will make an excellent Board Member.”

Aaron Bertrand

“I’ve known Allen for several years and I’ve always admired and respected the passion and dedication he has for the community.”

Patrick LeBlanc

“The thing that stands out the most is his passion and commitment to PASS and the SQL Server community as a whole”

Tim Mitchell

“He is a shoot-straight Texan who is not afraid to speak up even if what he has to say is unpopular”

Jack Corbett

“More was accomplished for local groups in Allen’s time leading that portfolio than in any other time period during my involvement with PASS. Allen’s passion for the PASS mission to Connect, Share, and Learn drives him to cut through the red-tape and get things done”



Go to Top