Allen Kinsel - SQL DBA

SQL Server, PASS, and other data mishaps

Accessing Top Quality Training

By Allen Kinsel, 5 months and 6 days ago

Where did the Training go?

With the economy being what it is, many companies are cutting back on training budgets yet our need for knowledge as database professionals never stops.  Luckily the SQL Server community is one of the liveliest around and there are solutions.

Online

I'd estimate that  almost everyday of the week you can find live webcasts about various subjects in the SQL Server arena, the problem here is that many of these top quality training events aren't well publicized.  I never knew about them until joining Twitter a few years back.  As it turns out, many SQL user groups around the world stream their meetings online via live meeting, there are PASS VC's webcasts, Vendor sponsored webcasts, and the list goes on and on.

Local Events

Keep reading →

Related posts

Share this post

PASS TPS #1

By Allen Kinsel, 5 months and 12 days ago

TPS reports, love them or loathe them, they are a necessary thing for most of us working in corporate America.  I firmly reside in the loathe camp, Just ask my boss.

In this case though, I've decided to start putting out regular updates about what Ive been up to for PASS.  I hope the benefit is 2 fold, 1 to allow a greater transparency into what happens behind the scenes and more importantly for me to have a place to reference what we did and when!

Summit 2009 wrapup

We sent out quite a few different surveys during/after the 2009 summit, some of them are listed:

Keep reading →

Related posts

Share this post

SQL/Windows Clustering Stupidity

By Allen Kinsel, 5 months and 12 days ago

Win98 300x225When is high availibility not? 

When its any version of SQL running on a clustered Windows 2003 Server or sql 2005 running on clustered Windows 2008 Server.  Seems that while you can dynamically add a disk and use it in SQL when your running a standalone server, if your running in a «highly availiable» cluster configuration you have to take SQL offline to add the disk as a dependency in order to be able to use it within SQL.  Here's the proof right from SQL books online.

Im sure there was a good reason to require this at the time but clearly this wasnt thought out in the grand scheme of taking 0 downtime.  Anytime a single server has a more highly availiable architecture than your system that is designed for high availibility -->youre doing it wrong, Sorry someone had to say it

Related posts

Share this post

SQL Active Directory User ID SID Mismapings

By Allen Kinsel, 5 months and 13 days ago

Sometimes login mapping issues exist where you least expect them

This is not the traditional SQL login SID mismap issue that is frequently encountered and discussed here. This mismap was a new one on me so I thought id document it.

When trying to add a new Windows login for SQL Server 2005 or 2008 (probably earlier versions but not tested) you may wind up with this error message

Msg 15025, Level 16, State 2, Line 1

Keep reading →

Related posts

Share this post

Call for Program Committee Volunteers

By Allen Kinsel, 5 months and 20 days ago

Spidey 300x225The 2010 PASS Program Committee Call for volunteers is open, We're looking for the usual assortment of people to help shape the summit in 2010.

Abstract Reviews

Ever wanted to have an input into which sessions are actually chosen for the summitt?  The group of volunteers who do this are chosen from these applications. Its a very challenging endeavor but also very rewarding.

Special Projects

There are literally dozens of separate projects that need to happen every year in order for the Summit to come together appropriately.  Things like setting up the mgmt software, reviewing the ppts, reviewing the chosen abstracts for grammatical errors etc.  These people will also be chosen primarily from the applications received

Keep reading →

Related posts

Share this post

← Previous 01 02 Next →

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