Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ted_smith
Starting Member
2 Posts |
 Posted - 2006-01-20 : 08:13:12
|
| Firslty, my aplogies if this is documented elsewhere - I am a new user to SQL Team and not yet found everything! I hope someone here can help me...In brief, I am making the foolish mistake of embarking on my third and final year of an MS(c) degree in forensic computing. For my final year project I am intending to study and document (for forensic computing purposes) the forensic capture and investigation of data from a MS SQL Server database. However, my experience is mostly from MySQL! In other words, I know very little about the internal structure of MS SQL Server 2000 or 2005. Which leads me to my question....Can anyone point me in the direction of a technical page\document\pdf (whatever) that details what the core fundamental differences are between 2000 and 2005. I'm not talking about an MS publicity paper - no, I need a non-bias technical guide which states the differences as fact. If the differences in 2005 are mostly just cosemtic (the GUI etc) then I'll study 2000 because lots is already known and documented about it it seems. However, if it's much more than that and the differences are specific to what I'm studying (the forensic capture) then I'll probably have to go with 2005 because that's what we will be encountering more of in the next few years and the differences will effect the investigator. Your time and responses much appreciated. RegardsTed(BTW - Having looked at the description of 'Inside Microsoft SQL Server 2000', it seems like it might be a good book for my project (if I do 2000). Would you guys agree?) www.f3.org.uk |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-20 : 08:23:25
|
| http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspxMadhivananFailing to plan is Planning to fail |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-01-23 : 03:55:45
|
| Kalen Delaney's "Inside SQL Server 2000" has a lot of information about the workings of SQL Server. Not sure that there is a 2k5 edition yet.steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
ted_smith
Starting Member
2 Posts |
Posted - 2006-01-24 : 18:06:34
|
| Thanks very much guys. This is very helpful. Looking at the title, "Inside Microsoft SQL Server 2005: The Storage Engine" this book may be particularily useful, except it's not been released until the 27th Sept 2006 which will be half way through my project. Bummer. So that said, I may go with 2000 if the core workings are not hugely dissimilar. I will have a look at the URL's given for the books. Tedwww.f3.org.uk |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-02 : 23:27:52
|
quote:
Originally posted by wesyeds
Needed some help quickly on this topic, not sure where to go  Afreen J
what is your question ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Differences between MS SQL Server 2000 and 2005?