Feeds:
Posts
Comments

Image

Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as Partners.  For those who do not know about Linchpin, they are a technology company with a focus on the Microsoft Database stack on the front, but behind the scene they are about developing people.  The company values are called the Service 22:40 which is modeled after Matthew (22:37-40).  This is what some call the “Golden Rule”

This is where I fit in.  First I get to be mentored by these wonderful guys, but more importantly I get to keep giving back to the community in more ways.  I recently started a small consulting firm to be able to focus on helping small to mid size companies that need the expertise of a senior level database professional.  The focus of my company is to baseline the organization, standardize installations, backup and recovery, disaster recovery, high availability, tune and get the systems running like they should.  I train the accidental dba who is responsible for the environment and then hopefully land a maintenance contract with the company to do periodic health checks.

My primary responsibility will remain focused on the large corporation where I am currently employed.  Being a DBA typically means “Doing Business After-hours” and any contracts I get with Radney Consulting or affiliation with Linchpin will typically fall into a night and weekend endeavor.  I can’t go repartioning a disk, creating a bunch of indexes, reconfiguring tempdb, or rearranging data and log files during business hours on a production system now can I?

I am very excited to be joining my friends in helping them build a great company and having a far greater reach to enrich others lives by sharing my life lessons and SQL knowledge with others.

Linchpin People = ”Changing one career at a time”

SQLSAT107

SQLSAT107

I was recently selected to speak at SQL Saturday 107 in Houston TX.  I am really excited to be selected from such a great group of folks who submitted.  This will be my second time speaking in TX, but my first time to Houston.

I will already be in Houston for my introduction into the 2012 Idera ACE program and enjoying some early benefits of the program.  It will be a lot of fun getting to hang out with some of the existing ACE’s and most of the new ones.  I am truly a blessed individual.

If you happen to be reading this and live around Houston, make sure to register for the event.  For those not around Houston, well we have LOTS of SQL Saturday’s all over the world.  Make sure to attend one, or plan your own.  Check them out at http://www.sqlsaturday.com

SQL Saturday 107

I attended my first SQL Skills event in December 2011.  Due to a big project at work I was able to work in week three of the Immersion Events which is HA/DR “High Availability and Disaster Recovery”.  Although I am taking the training out of sequence my hope is to be able to attend IE2 later this fall.  IE2 is the performance tuning session.

Expectations are high when you attend an Immersion Event.  Many will argue that it is the best training available.  I haven’t attended every possible training out there but I have attended training from the numerous “training centers”, attended a lot of SQL Saturday’s and three PASS Summits.  Of all the training I have attended, the Immersion Events are the best.

Anytime that you put Paul Randal, Kimberly Tripp, Joe Sack and Jonathan Kehayias in the same room talking about topics they love you are in for a treat.  I will tell you that topics range from consolidation, virtualization, backups, restores, clustering, mirroring, replication, design options and more.  The fact you can find this information at SQL Skills I don’t mind sharing it.

For me, each day I was able to learn something pretty significant that will have direct impact at work, thus each day the cost of the training was justified.  How cool is that.

Thursday night at these events are community night.  Several attendees get to present a 15 minute session.  I was fortunate to be able to be one of those.  I presented “Getting Involved and Getting Ahead”, my session was on all things SQL Community.

If you ever have a change to attend, you are well feed both physically and intellectually.  Don’t miss the chance to get immersed in SQL Server.

SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean.  I was fortunate enough to be able to attend this event and demo a couple of favorite tools of mine.  SQL Prompt and SQL Compare.  Being the PASS regional mentor for this area made me want to attend and show support even more.

Roy Ernest did a fantastic job in putting together this event.  It was Roy’s first SQL Saturday but you would not have known it.  He acted as a seasoned professional.  Not only did Roy manage to pull off a well ran event, he also was able to coordinate picking up 3 out of country speakers and Karla Landrum (Twitter).

One of my favorite things about the event is that the boys from Georgia showed up in force to help Roy fill the speaker slots.  Rob Volk (Twitter), Bill Pearson (Twitter) and myself each presented three sessions while Roy (Twitter) presented two and Rohan Joackhim (Twitter) presented one.  In all the attendees had 12 sessions to chose from.  The dedication from the SQL Community goes unmatched with any other professional field.

Roy took us to an incredible venue for the speaker dinner in Riffort village.  The Indian food was top notch and the view was wonderful.  I was fortunate to be able to take my son with me.  My son had been begging to get to fly on an airplane to what better trip to let him tag along.

Before the event was even over we started asking Roy about plans for the next one.  Curacao is on top of my list for places to visit again.  If you ever have the chance to visit I recommend taking an underwater camera, lots of sun screen, goggles and a snorkel.  There are reefs all around the island.  No need to have to get on a boat to take you somewhere to snorkel, simply get in the water.  Truly amazing!

Idera ACE Program

On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was included in the list.  http://bit.ly/ABedR0  March 9th could also be deemed the day twitter blew up my iPhone.  The congratulations from the SQL Community was truly amazing.

The Idera ACE program is something that has interested me since Idera began the program.  Idera ACE’s are “Advisors & Community Educators for SQL Server” and Idera helps promote the ACE’s by sponsoring their travel to a number of SQL Server events.  You can read all about the program and meet your current ACE’s HERE.

Six of us were chosen from a great deal of applicants.  I can only imagine how difficult the selection process had to me and I count my blessings that my name got stuck to one of the other new ACE’s applications and got counted in the mix.  I am proud to be a part of the 2012 ACE program and join Jason Strate, Christina Leo, Jack Corbett, DB Argenis and Ben Nevarez.

Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database.  Since most folks probably don’t have a routine in place to record the version number each time SQL server is patched we need a way to be able to determine the version and build level of our instance.

If you take regular backups of the master database and have to restore to the same instance, you should be ok to not have to worry about the version.  However, if you are having to recover the system database from one instance to another server, then the build version becomes very important.

Imagine the scenario that you get a call from the NOC at 3:00 AM stating an important production server has crashed. You crawl out of bed, remote in and realize that all your SAN LUNS are missing.  You report back to the NOC, they call the SAN administrator and you learn that the LUNS are unrecoverable.  As luck would have it, you have a spare server you can migrate over to but you don’t script out all your user objects so you have to recover the system databases as well.  What version are you on?  10.0.4023 or 10.0.4062  You don’t know.  All you know is SQL 2008 Sp2.

As luck would have it, the boys and girls at Microsoft thought ahead.  This data is stored in the header and we have the ability to retrieve that information.

RESTORE HEADERONLY FROM DISK = ‘DRIVE:\PATH\DB_NAME.BAK’

This will return the SoftwareVersionMajor, SoftwareVersionMinor, and the SoftwareVersionBuild.  For example 10.0.4064.  Pretty neat huh?

Once you have SQL on the new instance installed and patched to the same level, you can start SQL in single user mode, connect to SQL using SQLCMD, and then restore the master database.  There are tons of blogs with step by steps on how to recover the master database.

I hope you never have to use this in production, but you should have plenty of experience practicing this.

In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed logins.  It is simple enough to open SSMS, connect to the instance, right click on the server, chose properties, click on security and then check the proper radio button.  When putting together or most recent updates to our server installation guide I decided to spend the few minutes to research how to make this change with few steps.

In my case I need this to be both failed and successful logins.  I will execute the following code within SSMS.

EXEC xp_instance_regwriteN'HKEY_LOCAL_MACHINE', 
 N'Software\Microsoft\MSSQLServer\MSSQLServer',N'AuditLevel', REG_DWORD, 3 Continue Reading »
Follow

Get every new post delivered to your Inbox.

Join 500 other followers