Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Bread and Butter of SQL Server DBA - Part 1 Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2008 7:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 1, 2009 7:31 AM
Points: 10, 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
Post #534347
Posted Tuesday, July 15, 2008 7:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 4, 2010 3:23 PM
Points: 1, Visits: 4
Good start. But you need to work on grammar. First paragraph had four grammatical errors.

-bob
Post #534351
Posted Tuesday, July 15, 2008 7:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 15, 2011 1:21 PM
Points: 1,181, Visits: 24
Perfect start! The article is concise and accurate!:)
Post #534390
Posted Tuesday, July 15, 2008 8:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 13, 2011 9:32 AM
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.
Post #534418
Posted Tuesday, July 15, 2008 8:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 23, 2013 10:22 AM
Points: 8, Visits: 76
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



Post #534427
Posted Tuesday, July 15, 2008 8:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:49 AM
Points: 1,553, Visits: 1,846
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.
Post #534428
Posted Tuesday, July 15, 2008 8:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 78, Visits: 738
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.



Post #534454
Posted Tuesday, July 15, 2008 8:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 23, 2013 10:22 AM
Points: 8, Visits: 76
Steve Jones.

Thanks for updating the article.

Owen.

Please check the article when you get a chance.





Post #534467
Posted Tuesday, July 15, 2008 8:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 13, 2011 9:32 AM
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.
Post #534469
Posted Tuesday, July 15, 2008 10:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 10:00 AM
Points: 3, Visits: 44
Great topic.
I would add that you need to create a database before you can restore from your backup taken earlier.

Cheers,
Post #534557
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse