Allen Kinsel - SQL DBA

SQL Server, PASS, and other data mishaps

PASS Value Allocation

By Allen Kinsel, 5 months and 30 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!

Whose got my DAC?

By Allen Kinsel, 6 months and 6 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 →

Convincing your boss to pay for your training

By Allen Kinsel, 6 months and 9 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 →

← Previous 01 02 Next →