Bread and Butter of SQL Server DBA - Part 1

Question

Bread and Butter of SQL Server DBA - Part 1

MAK9974

SSC Enthusiast

Points: 122
More actions
July 14, 2008 at 9:31 pm

#195276

Comments posted to this topic are about the item Bread and Butter of SQL Server DBA - Part 1

Viewing 15 posts - 1 through 15 (of 32 total)

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

sandrajones25 Grasshopper Points: 11 More actions · Answer 1

Hi,

Sorry, because not having that much of knowledge about the topic, but I have given some informations what I have for the time being. Transaction Log is probably one of the most underutilized, underappreciated, and least publicized part of SQL. This is probably due to its simplicity, but this also makes it one of the most misunderstood parts of SQL Server. The transaction log can actually help to lower the server’s resources, increase productivity, all the while providing a method of an additional safety layer for you to fall back on

======================================================

sandrajones25,

Knox Leon

Anipaul SSC-Insane Points: 24681 More actions · Answer 2

Looks like it is beginning of a excellent series. Looking forward for other parts.

Sim Lever Old Hand Points: 316 More actions · Answer 3

Sim Lever

Old Hand

Points: 316

July 15, 2008 at 4:43 am

#842929

Great start

Cheers,

Sim Lever

owen.pugh Grasshopper Points: 24 More actions · Answer 4

Thanks for the article.:D It provides useful information but is let down by the level of grammar and spelling - making it unlcear in places.:unsure:

I'm looking forward to Part 2.

Cheers

Sim Lever Old Hand Points: 316 More actions · Answer 5

I found the grammar and spelling to be fine.

Can you point out any typos?

Cheers,

Sim Lever

Robbob SSC Veteran Points: 212 More actions · Answer 6

I enjoyed that first article and I am looking forward to the rest of the series. I have recently been using SS2K5 a lot and although we do have Full Time DBA's I am interested in learning more about the commonly accepted backup and restore strategies. Thanks again for the first article.

Rob

Hari.Sharma SSCertifiable Points: 6904 More actions · Answer 7

Good Article

Cheers,
Hari
Tips & Tricks for SQL BI Developers

rhall-556945 Grasshopper Points: 14 More actions · Answer 8

Great article, looking forward to DBA Part 2 and more!

santhu Ten Centuries Points: 1113 More actions · Answer 9

santhu

Ten Centuries

Points: 1113

July 15, 2008 at 6:53 am

#843048

Gr8 Start, Looking forward for part 2

owen.pugh Grasshopper Points: 24 More actions · Answer 10

Hi Sim

Please don't misunderstand, I really do appreciate MAK's efforts and experience in putting this together.

I wasn't intending to rip the article to shreds. I thought that, rather than a professional article, it read more like a quick blog - without any editorial quality control.

Here are some of the typos I spotted:

One of the Primary tasks of any Database Administrator is Backup and eventually restores those backups somewhere.

or

Two of the primary tasks of any Database Administrator are Backup and, eventually, Restore of those backups.

Database Administrators creates fallback plan for every possible failures.

or

Database Administrators create fallback plans for every possible failure.

Database gets corrupted and not recoverable

or

Database gets corrupted and is not recoverable

Database Deleted by accident or by purpose

or

Database is deleted by accident or on purpose

SQL Server Crashes and data drive is not recoverable

or

SQL Server crashes and data drive is not recoverable

This article series is going to illustrate the various types of backup, take backups, restoring different types of backups, detaching databases, attaching databases, move database, Backup a table, compress a backup, encrypting the backups etc.

or

This article series is going to illustrate the various types of backup possible, how to take backups, restoring different types of backups, detaching databases, attaching databases, moving databases, backing up a table, compressing a backup, encrypting the backups etc.

Microsoft SQL Server provides three different types of backups. They are Full Backup, Differential Backup and Transactional log backups. There is also another backup called File group backups.

or

Microsoft SQL Server provides three different types of database backup. They are Full Backup, Differential Backup and Transactional Log Backup. There is also another backup called File Group Backup.

...

Cheers

Owen

rmontena Grasshopper Points: 13 More actions · Answer 11

Good start. But you need to work on grammar. First paragraph had four grammatical errors.

-bob

bondistrict Ten Centuries Points: 1269 More actions · Answer 12

Perfect start! The article is concise and accurate!:)

impugn Valued Member Points: 60 More actions · Answer 13

Here is the first paragraph of the article...translated from "English" to Chinese and back into "English" again:

"And an all database administrator primary mission is spare and restores these backups finally somewhere. The database administrator creates the plan possible defeat which can lean against every time. Microsoft introduced separates and attaches from the SQL server 7.0 orders. These orders also became the DBAs part to make a living, when talked about motion the database or the cleaning diary table and so on."

See? Could have been worse.

There you have it.

MAK9974 SSC Enthusiast Points: 122 More actions · Answer 14

Folks.

Thanks you for all the comments.

Owen.

100% Agreed. I should have double checked and proof read it thoroughly before publishing it. My bad.

I relied more on Microsoft word than my English. Microsoft word is more forgiving. Looks like you are not. I was focusing more on the actual technology rather than English language.

However when writing articles on technology there is no hard and fast rules.

I will be more careful next time.

Note: Microsoft word complains that "My Bad" is a fragment and consider revising.

http://www.mssqlengineering.com