Getting Started in SQL Server

  • Evil Kraig F

    SSC Guru

    Points: 100851

    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

  • Geoff A

    SSChampion

    Points: 11417

    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.

  • Grant Fritchey

    SSC Guru

    Points: 396384

    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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • jcrawf02

    SSC-Insane

    Points: 24198

    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."

  • Rich Mechaber

    SSChampion

    Points: 10935

    *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

  • casinc815

    Old Hand

    Points: 303

    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!

  • sjimmo

    SSChampion

    Points: 11139

    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

  • cy-dba

    SSCarpal Tunnel

    Points: 4149

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

  • jasona.work

    SSC-Forever

    Points: 49965

    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

    One of my nieces requires a powerchair to get around and is trying to raise the funds to buy one:
    https://www.gofundme.com/f/get-breezy-a-new-wheelchair?utm_source=customer&utm_medium=copy_link-tip&utm_campaign=p_cp+share-sheet

  • TalkSql

    SSC Enthusiast

    Points: 189

    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

  • zenrigar

    Ten Centuries

    Points: 1350

    Great Article Craig

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

    Keep up the good work!

  • Sioban Krzywicki

    One Orange Chip

    Points: 27770

    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

  • paul s-306273

    SSChampion

    Points: 10615

    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!

  • Evil Kraig F

    SSC Guru

    Points: 100851

    :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

  • Evil Kraig F

    SSC Guru

    Points: 100851

    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 41 total)

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