A lot of questions had been asked in forums about the difference between SQL Server 2000 and 2005. Below is a table which shows the components of both versions:
| Component | SQL Server 2000 | SQL Server 2005 |
|---|---|---|
| Extract, transformation, and load | Data Transformation Services (DTS) | SQL Server 2005 Integration Services |
| Relational data warehouse | SQL Server 2000 relational database | SQL Server 2005 relational database |
| Multidimensional database | SQL Server 2000 Analysis Services | SQL Server 2005 Analysis Services |
| Data mining | SQL Server 2000 Analysis Services | SQL Server 2005 Analysis Services |
| Managed reporting | SQL Server 2000 Reporting Services | SQL Server 2005 Reporting Services |
| Ad hoc reporting | | SQL Server 2005 Reporting Services |
| Ad hoc query and analysis | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) |
| Database development tools | SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other | SQL Server 2005 Business Intelligence Development Studio |
| Database management tools | Enterprise Manager, Analysis Manager | SQL Server 2005 SQL Server Management Studio |
2 comments:
Can anyone recommend the top performing Managed Service tool for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central remote software access
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!
My friend and I were recently discussing about the ubiquitousness of technology in our daily lives. Reading this post makes me think back to that discussion we had, and just how inseparable from electronics we have all become.
I don't mean this in a bad way, of course! Ethical concerns aside... I just hope that as the price of memory decreases, the possibility of downloading our memories onto a digital medium becomes a true reality. It's a fantasy that I dream about all the time.
(Posted on Nintendo DS running [url=http://kwstar88.livejournal.com/491.html]R4 SDHC[/url] DS SeKu)
Post a Comment