I work as a SQL Server Administrator near Dallas Texas.  I started working with databases over 30 years ago now.  (And yes, that does make me feel old.) 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 just over 20 years now with a fairly even split between administration and development. Frequently using development to do the administration (I like scripts and automation).

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.

25 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:


      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.


  6. pantea says:

    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?

  7. Pail Writer says:

    I see a lot of these replies are several years old. I was wondering if you are still active on this blog? If so, do you have any recommendations for passing the 70-461 exam?

    • Yep. I’m still active. That’s the exam for SQL 2012 & 2014 right? I’d start by looking at the exam objectives and see how you stack up. There are also several “training kits” (books you can find on Amazon) and at least MeasureUp has a practice test you can buy and try out.

      • Pail Writer says:

        Ah, your there. Awesome. So many sites I have been to have long since been abandoned.
        Yes, I am working on taking the 70-461 SQL Server 2012 exam. I have been studying the “Querying Microsoft SQL Server 2012” book and went through the “Querying Microsoft SQL Server 2012 Jump Start” videos on MVA.
        I just wondered if there is anything else I could use to study for this? I just don’t want to fail on my first try. I haven’t been in any school or testing environment for more decades that I care to admit, so I’m a little nervous about taking the test.

        • Yea, my best advice at that point is to review the tested subjects on the exam site and make sure you are completely comfortable with each category. (https://www.microsoft.com/en-us/learning/exam-70-461.aspx). After that if you are still uncomfortable get a practice exam from Measureup. They are a little over $100 but the biggest benefit for me has always been peace of mind. Also depending on when you purchase the exam there is sometimes a free retake option that you can get.

        • Pail Writer says:

          Thanks for the advice. I plan on taking the exam in the next few weeks. I thought about buying some brain dumps, just to see how the questions are worded on the exam. Any comments or suggested brain dump sites?

        • I don’t really like brain dumps. They go against the spirit (and in many cases the laws) of the exams. In fact, depending on the brain dump if MS catches you using them they will revoke the certification and ban you (I think) from getting others. I’d stick with something like Measureup’s practice tests.

        • Pail Writer says:

          Holly SQL Macros, Thanks for the caution. I didn’t know. Okay, I’ll stick with MeasureUp and my books.
          On a side note, there’s you a subject for an article, SQL macros and macro sets.

  8. Glad to see you are still active here, Kenneth! I just re-discovered your blog from a 2016 evernote I saved from your site. I’ve had to move on from SQL Server, as my last 3-4 jobs have forced me to learn PostgreSQL, Redshift (AWS), Apache Spark SQL (surprisingly pretty standards compliant), and, most recently, Snowflake (another cloud DW, also pretty standards compliant). As a result of this, I guess I’ve become somewhat of a SQL nerd and have moved more towards ANSI/ISO standards. I was surprised by how much they have evolved over the years (if you are curious, the site modern-sql.com is really good).

    I was just wondering, given your dual focus on development and administration, if, while having your SQL developer hat on, you ever wish SQL Server was more standards compliant. Not that it’s the worst (that award would certainly go to MySQL), but it’s not the best either (probably Oracle or PostgreSQL would win that one).

    Do you see the world changing, as more companies shift to cloud services that are not necessarily from M$? What does it mean to be a SQL developer anyway in this new world?

  9. Lance Wulfers says:

    Can you send me the source for your sp_DBPermissions script? Not sure what the web page is doing to your source but a copy and paste generates a bunch of invalid characters in the resulting paste buffer

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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

Join 3,753 other subscribers

Follow me on Twitter

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