Jeff Moden (6/9/2015)
I am new to SQL Server, working as an IT support for the past 7 years and want to move to SQL
I am learning TSQL , and need your expert advice on how to move further ( SQL DBA or MSBI)
I have to ask... WHY??? What is it that you think you're going to like about SQL Server in one form or another?
Many thanks for your reply,
[font="Arial Black"]I have developed my interest for SQL server during working on a support project of our company website[/font].
Our company's website is developed by an external agency , but they have given me and 2 more members of staff how to do the daily updates on the website.
and as a back-end they use SQL server.
Now that's a good reason... especially if you like working with it. A lot of people "do it for the money" instead of the passion and they end up sucking at it.
My personal preference is "SQL DBA" mostly because I'm an old front end programmer and hated every minute of it. MSBI seems like it would contain a lot of the same stuff... I need a different color of Pink and I want Pale Yellow lettering on this White background and can you make the numbers look more attractive? That's not a slam on anyone that happens to be in the world of BI and it can pay well for those dedicated to the art... it's just not for me.
There are 3 basic types of "DBAs", in my humble opinion.
[font="Arial Black"]Systems DBA[/font]
These are the folks that work mostly only with the system itself. When it comes to performance tuning, they know what it takes for hardware, trace flags, configuration of TempDB, etc, etc. Typically, they manage a shedload of servers and know how to use the Central Management System very well. They also know about clustered servers, have an in-depth knowledge of Disaster Recovery, manage security, and, of course, manage backup and restore systems as well as capacity planning. There's more but that's a good overview.
[font="Arial Black"]Application DBA[/font]
This is the person that knows T-SQL inside and out along with in depth knowledge of a lot of the inner workings of things like Indexes, Partitioning, Table Structure, and most of the commands and functions. Frequently, these folks also write stuff for the BI people to use and they will have a strong understanding of the "Black Arts" of T-SQL and the good ones are also masters at performance tuning of the code.
[font="Arial Black"]Hybrid DBA[/font]
This person has a strong understanding of many of the things that both the Systems and Application DBAs do. A lot of times, they're backed up by an infrastructure group that is actually responsible for setting up the physical and virtual boxes so that they can concentrate on making sure that jobs run correctly, have the time to do peer reviews of code, mentor developers, do things like partitioning for the sake of reducing maintenance, backup, and restore times. They also are the ones that frequently do the backups and test restores although they frequently have nothing to do with clustered servers or offsite DR (done by the infrastructure group where I work). Of course, they're also Ninjas when it comes to T-SQL and are master Database Developers, themselves. Really good ones can even tell some of the other two types of DBAs some tricks that they might not have heard of because they have a pretty deep understanding of both worlds.
To be sure, I find the Hybrid DBA to be the most interesting and have developed an incredible passion for it over the years especially with the community of support and equal passion for the subject on this and other forums.
My recommendation for most people is to buy a copy of the Developers Edition (~60USD) AND "Books Online" (free download) and start with the basics of databases, tables, and T-SQL. Let your passion grow from there.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)