SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Bread and Butter of SQL Server DBA - Part 1


Bread and Butter of SQL Server DBA - Part 1

Author
Message
owen.pugh
owen.pugh
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 18
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
rmontena
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 4
Good start. But you need to work on grammar. First paragraph had four grammatical errors.

-bob
bondistrict
bondistrict
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1217 Visits: 24
Perfect start! The article is concise and accurate!Smile
impugn
impugn
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 56
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
MAK9974
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 79
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



Carla Wilson-484785
Carla Wilson-484785
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2544 Visits: 1951
Can we please rise above the "grammar issues".
I really enjoy hearing from the global community, and appreciate the effort everyone puts into volunteered articles.

I look forward to more articles in the series.
andycao
andycao
SSC Veteran
SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)

Group: General Forum Members
Points: 269 Visits: 943
It's plain grammar issues. There is no need to place the subject in quotes. The issues are real. Readers will distrust the technical content when the verbiage in the article is flawed.

Just because the content is volunteered is not a good reason to look the other way when the prose is riddled with errors.



MAK9974
MAK9974
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 79
Steve Jones.

Thanks for updating the article.

Owen.

Please check the article when you get a chance.



impugn
impugn
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 56
Carla Wilson (7/15/2008)
Can we please rise above the "grammar issues".
I really enjoy hearing from the global community, and appreciate the effort everyone puts into volunteered articles.

I look forward to more articles in the series.


Since we're here on this Internet thingy...it seems to me that one's grammar comprises a very large part of how one presents oneself to the rest of the world. It actually is important. It actually says something.

In any event, pointing out problems with the article's presentation is not mean. It is just plain fact. If my kid spells "cat" like K - A - T, I don't tell him he's 2/3rds right and pat him on the head. Some might, but woe be unto that child when faced with reality, later.

I've actually refused to use software at times because either the accompanying literature or the interface, itself, was rife with horribly written prose. Why? Carelessness evident in what I can see only makes me distrust what I can't (i.e. the underlying code).

Now, the upside for the article's author: I wouldn't even be able to write out [all 18 words of] Stallone's dialog from Rambo: First Blood in MAK's native language (whatever that is). Okay. Got it. English is his second language. That is what his grammar is telling us. Ain't nothing wrong with that. Knowing that, though, does not make the grammar right and didn't stop me from chuckling through bits of the article.

And furthermore, all your base are belong to us. Make your time. Ha ha ha ha.
Paul Bhupal
Paul Bhupal
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 44
Great topic.
I would add that you need to create a database before you can restore from your backup taken earlier.

Cheers,
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search