| Author |
Topic |
|
mark_b
Starting Member
24 Posts |
 Posted - 2007-11-08 : 10:30:14
|
| Hi all,I have just downloaded the July version of Katmai to have a quick look at it.On the surface i can not really see any major differences between this version and 2005. Interface looks the same, and all the functionality seems to be in the same places also.I have been scooting around on the MS website [url]http://www.microsoft.com/sql/2008/default.mspx[/url] trying to find out "why i should upgrade to 2008" but have not been able to find any compelling arguments.Has anyone out there done a more indepth study of sql 2008 in their environment and found something that i have missed?CheersMark |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-08 : 11:21:20
|
The new MERGE command.The TIME and DATE datatypes.The HierachyID datatype.Table parameters allowed in UDF och SP.Better XML support.Better datawarehouse design.Better reporting engine.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-08 : 11:23:10
|
Built-in compression on columns.Built-in compression on backups.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-11-08 : 11:25:30
|
| Mark,What you're looking at is a very, very early beta so all the features aren't in place yet. In fact most of the features that exist in that beta are the ones that were easiest to implement. For environments that support multiple applications things like the resource governor will certainly be a reason to upgrade. Data and backup compression will also be key selling points -- especially in the data warehouse world. There is better support for geographic data and non-structured data (i.e. files). I'm very interested in the change data capture as a way to populate data warehouses.This is certainly a smaller upgrade than 2005 but still has some pretty compelling features.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-11-30 : 09:49:20
|
Evolution not revolution.Lots of BI stuff including improved SSIS, OLAP optimisations, rewrite of reporting services renderer & engine. The encrypted database & backup is interesting. Compressed backups as mentioned (worth a second mention  ).Nothing that is getting me really excited but a few decent features. |
|
|
|
JasonL
Starting Member
35 Posts |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-12-14 : 09:34:02
|
quote:
Originally posted by pootle_flump
Nothing that is getting me really excited but a few decent features.
As a production/operations DBA, the Declarative Management is very exciting to me...I can finally 'throttle' some of the known 'bad' users and might not have to restore 3/4 of a TB daily for them to use as reporting sources. |
|
|
|
JasonL
Starting Member
35 Posts |
Posted - 2007-12-14 : 13:23:26
|
| Haywood:If you want more info/(may be training) try www.live.com and do a search for "Declarative Management Framework"tons of info.(FYI: I work for Microsoft) |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-12-14 : 14:13:40
|
| Excellent! Thank you. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-28 : 04:42:05
|
http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
SQL 2008