March 4, 2008 at 6:08 am
Hi
What are the new features in server 2005 which are not in 2000 for DBA
Thanks
koteswarrao
March 4, 2008 at 6:17 am
Dear Koteshwar Rao,
There are lot of changes from sql server 2000 to 2005 in areas like backup,security and mail etc....... or purachse any sql 2005 book which will help you better. Please google to find more info.
Regards
Chandra Mohan N.G.D.
[font="Verdana"]Thanks
Chandra Mohan[/font]
March 4, 2008 at 6:21 am
Thats a pretty big topic to discuss like that. One of the most interesting thing I noted is the two Snapshots that has been introduced. “SnapShot Isolation” (SI) and “Read Committed SnapShot Isolation” (RCSI). This is used by SQL 2005 for Row Level versions. That is Committed Reads will not have to wait for Transactions to be completed for executing. The previous Committed version of the data will be provided.
-Roy
March 4, 2008 at 6:30 am
For the DBA you have one integrated tool (although slower than old isqlw in many ways unfortunately) rather than QA and EM separately.
You can now have the GUI script all actions that it can do for you. If you go into a GUI window to change DB properties, for example, then instead of saving you can have it save a script based on the things you've done in that screen.
Snapshot backups are great although they're only in enterprise/developer.
There are just sooo many changes. I'd look on the Microsoft website, or download the SQL Server 2005 Books Online. There will be several "what's new" topics in there.
March 4, 2008 at 9:06 am
The following should give you a detailed description of what's new in 2005.
March 4, 2008 at 11:11 am
In my opinion, the biggest advantage of 2005 over 2000 is the SSMS tool itself, and in particular, the non-modal dialogs.
March 4, 2008 at 11:19 am
In addition to what is posted above, SQL 2005 has new data types, functions, greater xml support, new availablity options, online index operations, online piecemeal restores, CLR support for custom code etc..
Likes others have said this is a very broad topic and would be best explained by this link:
http://www.microsoft.com/sql/prodinfo/features/top30features.mspx
March 4, 2008 at 12:41 pm
I found these articles by Steve very useful in my last couple of interviews. Though they are published long time back. But still good for references.
http://www.sqlservercentral.com/articles/Administration/2988/
http://www.sqlservercentral.com/articles/News/3036/
SQL DBA.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply