Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Answered: Linux Admin is Now A MSSQL DBA

    I've been a Linux administrator since 2002. Recently I've found a new passion in databases. I've messed w/ PostgreSQL, MongoDB, and MySQL. I've also did some Oracle 10g --> 11g instance in-place upgrade however I have very little SQL / T-SQL, Data Modeling, and other fancy DBA tool belt things experience.

    We've had a DBA slot open for some time in my dept. and I finally asked my boss if I could be considered. In less than 24 hrs time I was told by our Sr. DBA "welcome to the team"

    My company is a heavy MS SQL 2008/2014 shop w/ a lot of PostgreSQL & MongoDB here and there as well.

    I just started the Microsoft Database fundamentals training video: http://www.microsoftvirtualacademy.c...e-fundamentals

    The video is OK however sometimes the presentation is extremely bad. They try to do a relational diagram in Power Point which takes 15 min. for them to stumble through.

    I really want to be ready for my internal MS SQL Server exam and as well as being able to get / pass exams: 98-364 (and maybe even 70-461 ). I really just wanted to ask you guys for study / training content that you guys had learned to be extremely beneficial especially for someone learning MS SQL from scratch.

  2. Best Answer
    Posted by Pat Phelan

    "First and foremost, I can't recommend Pluralsight highly enough. They offer two tiers of training, and the most expensive is around $500 USD / year. I'm not positive, but I think that I remember being told that there were over 600 YEARS of 24 hour per day of training, some Windows, some MSSQL, some PostgreSQL, some Linux, many flavors of scripting, many languages, business content, etc. I don't know of any better variety or "bang for the buck" training if their content suits your style, and they offer free trials (contact me if you can't find a suitable demo offer).

    For live SQL Server training, check http://www.SQLSaturday.com as a place to start. The SQL Server community is great (the best I've ever seen, in any technical field) at helping new members. Be sure to also check the parent site which is http://www.sqlpass.org for both local chapters of the user group, and the virtual chapters which meet online.

    If you envision buying training, there are many outstanding providers. Two that jump right to mind are http://www.sqlskills.com and http://www.brentozar.com which are both fabulous. There are many other training providers, these are simply two that I know do a good job and can train everyone from the "accidental DBA" and also train Microsoft staff as well.

    If this doesn't answer your questions, ask again and I'll try to give you more information. This is just "shoot from the hip" between a meeting and lunch!

    -PatP"


  3. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    First and foremost, I can't recommend Pluralsight highly enough. They offer two tiers of training, and the most expensive is around $500 USD / year. I'm not positive, but I think that I remember being told that there were over 600 YEARS of 24 hour per day of training, some Windows, some MSSQL, some PostgreSQL, some Linux, many flavors of scripting, many languages, business content, etc. I don't know of any better variety or "bang for the buck" training if their content suits your style, and they offer free trials (contact me if you can't find a suitable demo offer).

    For live SQL Server training, check http://www.SQLSaturday.com as a place to start. The SQL Server community is great (the best I've ever seen, in any technical field) at helping new members. Be sure to also check the parent site which is http://www.sqlpass.org for both local chapters of the user group, and the virtual chapters which meet online.

    If you envision buying training, there are many outstanding providers. Two that jump right to mind are http://www.sqlskills.com and http://www.brentozar.com which are both fabulous. There are many other training providers, these are simply two that I know do a good job and can train everyone from the "accidental DBA" and also train Microsoft staff as well.

    If this doesn't answer your questions, ask again and I'll try to give you more information. This is just "shoot from the hip" between a meeting and lunch!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •