Allen Kinsel - SQL DBA

SQL Server, PASS, and other data mishaps

PASS Value Allocation

By Allen Kinsel, 4 months and 19 days ago

Listening to the SQL community over the years, I thought Id take a second to put a quick thought out about why I believe PASS makes almost every decision it makes as an organization.

As a non-profit, Its all about money value, and its use to support the community.  Almost every decision that is made within the organization has a value cost, whether that value is actual dollars that need to be spent, or if its a volunteers time, nothing is free or limitless.  Just because Microsoft decided that the top tier SQL engine will now cost 58k per processor, doesn't mean they are giving that money away freely to user group organizations.

If you're unhappy with where the organization is allocating its resources, Contact them directly, or probably even better contact all of the board of directors (protip: email format )  let them know you want things to have a different priority, if that fails, they have elections every year, VOTE!

Related posts

Share this post

Whose got my DAC?

By Allen Kinsel, 4 months and 26 days ago

What is the DAC?

The Dedicated Admin Connection, Commonly called the DAC is used to manage SQL Server when a regular connection wont succeed.  Here's what SQL Books Online (BOL) has to say about the DAC «This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.»

DAC Errors

Occasionally, while troubleshooting SQL servers in a large environment, especially one thats managed from many different geographic locations you could come up with this error, if more than 1 person is using the DAC.  It should also be noted this only happens if you have remote DAC enabled in your environment

Error 17810

Keep reading →

Related posts

Share this post

Convincing your boss to pay for your training

By Allen Kinsel, 4 months and 29 days ago

 

Things are tight

It seems like budgets are being cut everywhere, and IT training seems to be one of the first places cut.  In an earlier post I outlined where you could get a lot of valuable training for relatively little cost.  In this post I will explore a few methods that have worked for me over the years to get your boss to say YES to paying for you to refresh your fountain of knowledge.

Keep reading →

Related posts

Share this post

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

← Previous 01 ... 02 03 04 05 06 ... 08 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