1024programmer Java SQLServer: What to learn if you are going to a dedicated solution – SQLServer: What to learn if you are going to a dedicated solution

SQLServer: What to learn if you are going to a dedicated solution – SQLServer: What to learn if you are going to a dedicated solution

Today we’re using a shared SQL Server database and that is perfect as I don’t know anything about SQL Server maintenance. But for economic reasons we’re need to upgrade to a dedicated server.

Today we are using a shared SQL Server database, which is perfect since I know nothing about SQL Server maintenance. But for financial reasons, we need to upgrade to a dedicated server.

Given that I don’t have time to read the entire documentation, What do I absolutely need to know about SQL Server to not screw this up?

Given that I don’t have time to read the entire document, what else do I need to know about SQL Server not to screw up?

Resource suggestions appreciated!

Resource suggestions appreciated!

5 solutions

#1


The answer probably has to do with how data-intensive your application is. If it’s like most business applications, you’re probably OK reading a couple quick start guides and winging it (as long as you back up regularly … that’s important, so read up on that carefully). SQL Server is generally pretty self-tuning, and if you’re not talking millions of rows and high TPS, you’re probably fine for a little while.

The answer may have to do with how data-intensive your application is. If it’s like most business applications, you can probably read a few quick start guides and show it off (as long as you back up frequently… which is important, so read it carefully). SQL Server is generally very self-tuning, and if you’re not talking about millions of rows and high TPS, you’ll probably be fine for a while.

If it is a data-intensive application, or has high availability or throughput needs … get a DBA, even just on contract. Don’t put all your eggs in a basket you can ‘t carry.

If it’s a data-intensive application, or has high availability or throughput needs… even if it’s just a contract, get a DBA . Don’t put all your eggs in a basket you can’t carry.

#2


Backing up!

#3


Oh, it’s the accidental DBA!

Oh, this is an accidental DBA!

Brent Ozar has a handful of useful articles: http://www.brentozar.com/sql/

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

Don’t forget about SQLServerPedia – http://sqlserverpedia.com/wiki/Main_Page

Don’t forget SQLServerPedia – http://sqlserverpedia.com/wiki/Main_Page

Cheers!

#4


In terms of backing up, don’t forget to backup the transaction log as well as the database, unless you’d like your transaction log to grow until it takes over the entire drive.

When it comes to backups, don’t forget to back up the transaction log and database, unless you want the transaction log to grow until it takes up the entire drive.

I’d also read up on indexing, and statistics and rebuilding each.

I will also read indexes, statistics and rebuild each.

Also you should probably get a good understanding of how database security works.

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

If at all possible get a dev server as well as a prod one. Much much better to test changes on dev than directly in production! Then limit prod access to only a couple of people and make all changes to production happen through tested scripts.

If possible, get a development server as well as a prod server. Better to test changes in development than directly in production! Then limit prod access to only a few people and make all changes to production via test scripts.

#5


In order of importance:

Order by importance:

  1. How to schedule backups
  2. How to schedule a backup

  3. How to create indexes
  4. How to create an index

  5. How to rebuild indexes
  6. How to rebuild the index

The Profiler and Tuning wizard can help you with 2 and 3.

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

If you are programming the database and not just administering it, I’d reccommend Robert Vieira’s book. It’s a great introduction.

If you are programming a database and not just managing it, I would recommend Robert Vieira’s book. This is a great introduction.

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/756364

author: admin

Previous article
Next article

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索