December 21, 2005 at 12:46 am
I'm looking for suggestions on some mini projects from SQL Server DBA front which can help to improve regular DBA related activities...
TIA.
Madhur
December 21, 2005 at 6:45 am
It would help if we understoof what do you mean by mini-projects?
Do you mean the sort of tasks that need to be carried out on a server to keep them running optimally or something else?
December 21, 2005 at 9:37 am
Like "restore a database to a different location"
DR type tasks are usually good practice projects for DBAs to get better at their job.
December 21, 2005 at 10:06 pm
Another idea...
Take a business case study where someone is trying to build an application requiring a database. Work through the database objects that'll be needed and generate the database access layer to these objects. For instance, take a car parts store and figure out what they would need if you were building an inventory application for them. This will help your design and T-SQL programming skills.
K. Brian Kelley
@kbriankelley
December 22, 2005 at 7:16 am
Definitely want to throw a disaster recovery drill in there. This should include setting up your backup strategy and plan, testing your plan by restoring databases to a new server. Databases in both full recovery and simple recovery should be considered. Also, make sure you work with point-in-time recovery.
December 23, 2005 at 9:57 am
I think your focus will depend on what type of DBA role you will be filling. If you are a production DBA, then you will want to get yourself familiar with backup/restore activities, DR planning, performance monitoring and tuning. Get yourself familiar with the backup/restore concepts in BOL and create yourself a backup/restore and DR strategy. Get yourself familiar with performance monitoring tools for both Windows Servers and SQL Server. For performance tuning, you need to understand how SQL Server interacts with the Windows server's CPU, memory, and disk architecture. There are many good articles and/or forum posts on this site devoted to performance. Search for 'performance webcast' on http://www.microsoft.com/support. This will return some good material for performance tuning and monitoring.
If you will be filling a development DBA role, you should focus on database design. You need to be comfortable with T-SQL and stored procedure usage and design.
Both areas need to be comfortable with SQL query optimization, index usage and tuning.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply