About

15

I work as a SQL Server Administrator near Dallas Texas.  I started working with databases over 20 years ago now.  Back in the day, when the world was young, I started out working with Foxpro for DOS. It’s been awhile though, so I’m afraid I can barely spell “Foxpro” anymore.  I’ve been working in SQL Server for over 15 years now with a fairly even split between administration and development. 

This blog is to share some of the interesting bits and pieces I’ve either learned over the years or that I’m just now learning.  If anyone has any suggestions for me to write about or questions about what I’ve already written I would love to hear them. I can almost always be found hanging out on twitter so stop by and say hi!

Honored to be considered a Microsoft Data Platform MVP.

15 thoughts on “About

  1. David Stout says:

    I am getting ready to take the 70-432 Microsoft SQL Server 2008, Implementation and Maintenance exam. This will be my first time taking a Microsoft certification exam. I was wondering if you could provide me with any advice for passing the exam.

    Also I will be at the PASS Summit 2012 are you going?

    • Two major pieces of advice. First when you are done studying (or think you are) go back and read the skills required list again. I didn’t and found some gaps in my knowledge that caused me to have to take the test twice. Second some general test taking advice. If you aren’t sure of the answer eliminate all of the answers you are certain it can’t be. That will hopefully get you from a 25% chance on a guess to a 50% chance if you can narrow the number of choices from 4 to 2. Also if the answers are “coding” type answers then try to compare them bit by bit to see the differences. Sometimes even though you may not see the answer immediately you can get a reminder from the differences between the answers. For example:

      ALTER TABLE tablea ALTER COLUMN columna VARCHAR(25) NOT NULL
      ALTER TABLE tablea ALTER COLUMN columna VARCHAR(25) NULL

      Simple example I know but if the difference between the two answers is buried in a bunch of code it may not be easy to see, even though it’s as simple as NULL or NOT NULL.

      Hope that helps!
      Let me know how you do.

  2. David Stout says:

    Thank You, I will keep you posted. I am taking the test on Tuesday the 5th at PASS.

  3. sqlkohai says:

    If I’m just getting started on Certs, is there a specific order I should take them in? Interested in BI, but I’m wondering if I should take the basic cert first…

    • I would take them in the easiest to hardest order personally. IE Whatever is easiest for you. I did data first, then admin and still need to do BI.

      • sqlkohai says:

        Sounds like a plan. I was checking things thinking I’d take 467 first, but realized 463 is the base I should start with since that’s where I’m more comfortable. And multiple certs never hurt no one 😉

  4. Richard says:

    Looks like an interesting blog you’ve got here. I noticed you’re in Dallas. I just moved here a couple of months ago. Is it always this wet in the fall?

  5. Lee Everest says:

    You’ll get 100 emails…the db_datawriter trying to use output will get an error and (in the batch) the row will not be deleted, error is:

    Msg 229, Level 14, State 5, Line 1
    The SELECT permission was denied on the object ‘Checking’, database ‘AdventureWorks2012’, schema ‘dbo’.

    But, you’ve already tried too by now 😮 Good seeing you, and great job on the presentation.

    Lee

  6. pantea says:

    Hi..
    I have a question about the query just above the site… I mean the query which is shown in the top of the site. I wanna know what it is going to show? what does the query mean?
    thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: