Allen Kinsel - SQL DBA

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...