Getting Started in SQL Server

  • Comments posted to this topic are about the item Getting Started in SQL Server


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • nice article Craig. one litttle thing you left out though;

    you have to really enjoy working with the technology. as Confucius said, "Choose a job you love, and you will never have to work a day in your life."

    that is really something that I feel is extremely important. i have to love this non-sense to answer pages at 2 am, apply hot fixes on Sunday mornings and listen to devs complain they need sysadmin access..... the list goes on and on...

    but, for some strange reason, i love it.

  • Holy crud. This is excellent stuff! Well done. I don't think I've seen it all put together quite so succinctly. Thanks.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Great stuff Craig, thanks for this!

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • *Puts hand up from back of room*

    CREATE TABLE #PartsOfSpeech

    (

    WordType VARCHAR(30),

    Definition VARCHAR(200),

    Example VARCHAR(1000),

    Notes VARCHAR(1000)

    );

    GO

    INSERT INTO #PartsOfSpeech

    (WordType, Definition, Example, Notes)

    VALUES

    (

    'Gerund',

    'A verb used as a noun.',

    'Replying to SQL Server Central articles is lots of fun!!',

    'The word "replying" in the example, although a verb, is the subject of the sentence and used as a noun.'

    );

    SELECT *

    FROM #PartsOfSpeech;

    DROP TABLE #PartsOfSpeech;

    *Puts hand down and ducks pork chops*

    :w00t:

    Rich

  • Well Done, Craig!

    As a Data Architect, I liked your definition and would forward your article to all the HR, brokers, and recruiters who don't want to put a little effort into the hiring process with their clients and search for the "best of the best."

    It does appear to be a trend to try to wrap two or three people into one job description only to spin their wheels looking for the elusive superman!

    ...and life continues!

    Good luck!

  • Craig,

    Excellent article. Can't wait to see the next one.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • Very nice article. This validates much of what I had in my head already, but not nearly as organized!

  • Interesting article, it pointed out to me some areas where I need to do some work, before I can call myself a DBA...

    Yes, I'm a novice at this, despite doing some basic DBA stuff for my employer (hardware stuff, installing SQL, Windows networking / security / Active Directory) there are things I don't know how to do (create a view, stored procedures) and some I can do if I keep Google handy (basic queries, backups)

    Thanks!

    Jason

  • Great article Craig,

    It was really put well, I now know where to focus more as a developer now and how to steer myself to the next level. I just got laid-off and applying for jobs and whenever the see the job description i get tears in my eyes. They are looking for a superman.

    Regards,

    Bala

  • Great Article Craig

    This helps a lot seeing from a wide view what really i enjoy regarding databases.

    Keep up the good work!

  • Craig Farrell (12/8/2010)


    Comments posted to this topic are about the item <A HREF="/articles/Career/71608/">Getting Started in SQL Server</A>

    Nice article.

    As a consultant I go on many interviews and see even more job listings. Most listings include quite a bit that isn't needed for the job or understood by the people looking for someone to fill the position. For example, most seem to think SSIS/SSAS/SSRS is all of a piece. Frequently they only need one of the three, ususally SSRS or SSIS, but they almost always ask for all 3.

    Additionally, I've found a good way to advance one's skill set is to constantly go for jobs you're almost qualified for, but are confident you can grow into. It keeps things interesting and lets you learn and grow on the job.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • Good article Craig.

    If you apply where I work you don't need to know anything technical - nobody of that ilk is allowed to interview!

  • :blush: First, thank you all for your kind words. I came on ~1/2AM my time out of perverse curiousity and must admit, I was worried. It had 600 reads, 3 stars, and no dialogue to tell me why. :hehe:

    I'm glad you're all finding it useful. I wanted to put it together primarily as a starting point for new people, but I'm hoping that it may help interviewers and recruiters along the way figure out what they actually need. They could save money, juniors and low mids could get jobs, and everyone ends up in a better position.

    Thank you again. No worries, the second one won't be tooo far off. 😀


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • casinc815 (12/9/2010)


    It does appear to be a trend to try to wrap two or three people into one job description only to spin their wheels looking for the elusive superman!

    Sad but true, but I actually believe a lot of that is shopping, too. They know what they need and will concentrate a job to that, but if you can pull in someone who hasn't bounced around the industry from contract to contract for the last 10 years (and thus know the market) and just wants a change, and going from $50k/yr to $65k/yr is a huge jump to them, but they're worth 100k+.... 'eh.

    Everyone wants to get 'the best they can for their dollar'. The only way to get that sometimes is to write up a job description that shoots for the moon, and during the interview process pick your best fit, with as many extras, for the lowest price.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 15 posts - 1 through 15 (of 40 total)

You must be logged in to reply to this topic. Login to reply