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 |
|
Johnny.Kopa
Starting Member
2 Posts |
 Posted - 2009-07-12 : 12:29:28
|
| I'm an intermediate Production DBA and busy writing a business case to upgrade from SQL Server 2005 to 2008, but struggle to find any 2008 features that makes upgrading to SQL Server 2008 a MUST. Yes, there are many "nice to have" features but none of them are MUSTS with the exception of (1)Maintaining Mainstream Support. I want to know about features that can justify the business costs and effort(time) for upgrading to 2008.I'm more interested in PRACTICAL features that can improve DBA productivity and efficiency (manageability), environment security, increased performance , increased availability, standardization and documentation. Can you help to list some of the features which you think are MUSTS for now. The details about how each feature works and how to practically implement it will follow at a later stage. Your assistance will be highly appreciated.Johnny KopaDBA |
|
|
Johnny.Kopa
Starting Member
2 Posts |
Posted - 2009-07-12 : 14:44:42
|
| I posed the same question on SQLServerCentral.com and here's what I included as some of the IMPORTANT features:1. Improved Productivity and efficiency - Management Studio Improvements (e.g. Multi-Server Queries,new Activity Monitor, Object Search,Intellisense)2. Standardization - Policy-Based Management3. Improved Efficiency(save disk costs)- Data and Backup Compression (still don't know why Microsoft didn't make it compatible with TDE)4. Improved Performance - Resource Governor and Performance Data Collector (performance baselining and reporting)5. Improved Security - Transparent Data Encryption(TDE) and SQL Server Audit6. Improved Availability - DB Mirroring and Clustering Improvements, Change Data Capture.7. Ease of Documentation - ???? e.g. automatic documentation (is there such a feature?)8. Scalability - ??? (Any?)Are there any practical features that you personally see as being important enough to justify 2008 upgrade? I know that it depends per environment but I'd like to know which ones are applicable to YOU.Thanks again, looking forward to your response.Johnny KopaDBA |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-13 : 16:25:52
|
| I know they made some changes to the way sql is licensed. Web edition may be the most significant. The way 08 is supported virtually is different now.Maybe you can use fewer machines?Or more? |
|
|
|
|
|
|
Practical reasons to Upgrade to SQL Server 2008