SQL SERVER DBA

Question

SQL SERVER DBA

rajendran.e

Mr or Mrs. 500

Points: 531
More actions
June 1, 2009 at 10:49 pm

#200999

What are all the basic stuffs required for DBA.
I am aware of writing sql queries ,performance tuning,Backup,Restore,Creating database,Assigning Permission.
I don't have any idea about the cursor.Is this required for DBA?

Viewing 8 posts - 1 through 7 (of 7 total)

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

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 1

Learning something is not bad and if u already have SP ,Triggers functions etc then go ahead and learn cursor 🙂 so that u can swithc between a developement DBA and into pure administration.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

rajendran.e (6/1/2009)
What are all the basic stuffs required for DBA.
I am aware of writing sql queries ,performance tuning,Backup,Restore,Creating database,Assigning Permission.
I don't have any idea about the cursor.Is this required for DBA?

The only reason to learn about cursors is so that you can recognize when to use (very rarely) and when not to. Also so that you can work with existing code written using cursors so that you can look at rewriting those that should be written in a set-based manner instead.

I view cursors as a necessary evil, sometimes it is the right tool for the job, just not very often.

Eswin SSCrazy Eights Points: 8320 More actions · Answer 3

Check out:

http://www.databasejournal.com/features/mssql/article.php/1439731/Using-SQL-Server-Cursors.htm

http://www.sql-server-performance.com/tips/cursors_p1.aspx

http://www.sqlservercentral.com/articles/Advanced+Querying/2785/[/url]

http://www.sqlservercentral.com/Forums/Topic466467-149-1.aspx

http://support.microsoft.com/kb/837957

Tanx 😀

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 4

I'd strongly recommend reading Craig Mullin's book "Database Administration." It's a few years old, but it does a fairly good job of describing what a DBA is and does.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning