Clever Geek Handbook

SQL Server: What to Know if You Are Going to Use a Dedicated Solution

Today we are using a shared SQL Server database, which is great since I don't know anything about SQL Server maintenance. But for economic reasons, we need to move to a dedicated server.

Given that I don't have time to read all the documentation, what do I need to know about SQL Server in order not to screw it up?

Resource recommendations appreciated!

0


source to share


5 answers


The answer probably has to do with how important your data application is. If you like most business applications, you are probably good at reading a couple of quick start guides and backing them up (as long as you back up regularly ... this is important, so read this carefully). SQL Server is generally pretty self-tuning, and unless you're talking about millions of rows and high TPS, you're probably fine for a while.



If it is a data intensive application or has high availability or bandwidth, get a DBA, even just by contract. Don't put all your eggs in a basket that you can't carry.

+2


source


Backup!



+2


source


Oh, that's a random DBA!

Brent Ozar has some helpful articles: http://www.brentozar.com/sql/

Don't forget about SQLServerPedia - http://sqlserverpedia.com/wiki/Main_Page

Hooray!

+2


source


For backups, remember to back up the transaction log as well as the database, unless you want your transaction log to grow until it takes over the entire disk.

I also read about indexing as well as statistics and rebuilt each one.

You should also have a good understanding of how database protection works.

Get the dev server as well as prod if possible. It's much better to test changes on dev than on production! Then restrict prod's access to only a few people and push all changes to production through the scripts tested.

+2


source


In order of importance:

  • How to schedule a backup
  • How to create indexes
  • How to rebuild indexes

Profiler and Tuning Wizard can help you with 2 and 3.

If you're programming a database and not just administering it, I recommend Robert Vieira's book . This is a great introduction.

0


source






More articles:


All Articles