..::EralpErat::..{Embedded Programming}

Tuesday, August 21, 2007

Sql Server 2008 news

Selamlar ; Sql Server 2008 ile hayatımıza MS kanadından girecek olan yeniliklerin listesi ve ilgili linkleri aşağıda.

_{Security and Data Auditing}
- _{Transparent Data Encryption - This is encrypting the data while it is on disk and remains transparent to applications}
- _{External Key Management - This new
  functionality relates to consolidation of key management and
  integration with external products}
- _{Data Auditing - This is one core feature of SQL Server 2008 that will include a number of new features to include:}
  - _{The introduction of first class 'AUDIT' objects}
  - _{Auditing DDL (data definition language) commands}
  - _{Support for multiple logging targets}
- _{Additional information - http://www.microsoft.com/sql/prodinfo/futureversion/datamanage/default.mspx}
_{Availability and Reliability}
- _{CPUs - Support for pluggable CPUs which
  means that a CPU can be added on the fly and recognized by SQL Server
  2008 just like memory in SQL Server 2005}
- _{Database Mirroring - Enhanced Database
  Mirroring to include compression of mirror streams, enhanced
  performance and automatic page-level repair for the principal and mirror}
_Performance
- _{Data Compression - This new feature
  provides the ability to easily enable or disable data compression as an
  online command as well as offer more efficient data storage above and
  beyond traditional data compression}
  - _{http://blogs.msdn.com/manisblog/archive/2007/08/13/data-compression-with-sql-server-2005-sp2-and-katmai.aspx}
- _{Backup Stream Compression - The ability
  to configure compression with server level control or backup statement
  control of all backup types (full, differential, transaction log)}
- _{Performance Data Collection - When you
  are experiencing a performance issue the biggest problem is pinpointing
  the problem, so with SQL Server 2008 Microsoft is introducing a single
  common framework for performance related data collection, reporting,
  and warehousing}
- _{Improved Plan Guide Support - With SQL
  Server 2008 plans can be frozen for permanent query usage as well as
  pull plans directly from plan cache with SQL Server Management Studio
  integration}
- _{Resource Governor - If you have had the
  need to segment your SQL Server resource utilization then you should be
  looking forward to SQL Server 2008 because you will have the
  opportunity to create pools and groups to segment the resources and
  govern them independently}
  - _{http://decipherinfosys.wordpress.com/2007/07/21/new-features-in-sql-server-2008-i/}
_Management
- _{Policy-Based Management Framework - The
  ability to manage objects via policies as opposed to traditional
  scripts with inherent monitoring and enforcement}
- _{Microsoft System Center - Integration with Microsoft System Center which a product from Microsoft to improve operational costs}
- _{Extended Events - Another new feature
  is Extended Events which is a high performance yet light weight tracing
  infrastructure with insight into the core engine independent of SQL
  Trace}
_{New Data Types}
- _{Date Time Data Type - The datetime data type will now be able to support the following:}
  - _{Precision to the 100th nanosecond which is 7 digits past second}
  - _{Time-zone datetime offset to translate the datetimes across numerous time zones}
  - _{Rather than having to parse the
    datatime for just the date or just the time, now SQL Server 2008 will
    have date only support as well as time only support}
- _{HierarchyID - With the introduction of
  the HierarchyID data type this data type will be hierarchical-aware and
  will be accompanied by built-in functions, methods, etc. to support
  complex hierarchies in your data with .NET}
  - _{http://www.sqlskills.com/blogs/bobb/2007/08/02/NewSQLServer2008DateTimerelatedTypesAndADONET.aspx}
_{Development Enhancements}
- _{Entity Data Model - With SQL Server
  2008 will come the concept of a 'business entities' vs. tables, this
  will enable the ability to model more complex relationships as well as
  be able to retrieve entities as opposed to a result set of rows and
  columns}
- _{LINQ- LINQ is a new .NET Framework that encompass language-integrated query, set, and transform operations}
  - _{http://msdn2.microsoft.com/en-us/netframework/aa904594.aspx}
- _{SQL Server Change Tracking - This feature provides the ability to have change data capture without a comparable value}
- _{Table Valued Parameters - Ability to
  create variables of a table value data type and be able to pass this
  variable into a stored procedure}
  - _{http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266498,00.html}
- _{MERGE statement - Another term for this
  new feature is 'upsert'; this commands provides the ability to
  programmatically INSERT data if it does not exist or UPDATE the data if
  it does all in 1 set of logic}
  - _{http://www.sqlteam.com/article/microsoft-announces-sql-server-2008}
- _{Large UDT's - The 8000 byte limit is no longer applicable for on CLR-based UDTs and UDAs}
- _{Spatial data - SQL Server 2008 will
  support GEOMETRY and GEOGRAPHY data types with built-in spatial
  function support and spatial indexes to support more GIS needs}
  - _{http://www.directionsmag.com/editorials.php?article_id=2477}
- _{XML enhancements (support for lax
  validation, office 12 support, xs:dateTime support, lists/union types,
  LET FLOWR support, etc.)}
  - _{http://www.codeplex.com/MSFTXmlProdSamples/Release/ProjectReleases.aspx?ReleaseId=5717}
_{Service Broker}
- _{Interface - A new user interface and
  tools will be released for working with Service Broker in order to add,
  drop or edit Service Broker objects directly in SQL Server Management
  Studio}
- _{Conversation Priority - The ability to set message ordering with a send and receive impact with levels one to ten}
_{Data Storage}
- _{Data Compression - Reference the Performance section above}
- _{FILESTREAM Attribute - With this
  feature get the best of both worlds with functionality from BLOBs in
  the DB vs. BLOBs on filesystem}
  - _{http://blogs.msdn.com/pedram/archive/2007/06/04/store-any-data-in-sql-server-2008-katmai.aspx}
- _{Integrated Full Text Search - With SQL
  Server 2008 Full Text Search is fully integrated into the relational
  engine with no external storage, no external service as well as more
  efficient and reliable costing}
- _{Sparse columns - SQL Server 2008 has
  more efficient storage for 'wide' tables with many columns that repeat
  and do not contain data}
- _{New index types - New indexes include:}
  - _{Spatial indexes}
  - _{Hierarchical indexes}
  - _{FILTERED indexes (indexes on filtered values within columns)}
_{Data Warehousing/ETL}
- _{Partitioned Table Parallelism - This feature eliminates the one thread limit per partition}
- _{Star Join support - SQL Server 2008 now
  supports a star join with no special syntax which is completely
  optimizer based with full backward syntax support}
  - _{https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5562}
- _{Data compression - Reference the Performance section above}
- _{Resource Governor - Reference the Performance section above}
- _{Persistent Lookups in SSIS - There is
  no longer a need for re-querying for lookup operators and cache lookups
  in multiple ways with the ability to persist lookups to disk}
- _{Improved thread scheduling in SSIS - This is accomplished by a shared thread pool and pipeline parallelism}
- _{SQL Server Change Tracking - Reference the Development Enhancements section above}
- _{MERGE statement - The MERGE statement will add a great deal of value with slowly changing dimensions}
- _{Scale-out analysis services - With read-only storage multiple Analysis Services SQL Servers can be leveraged}
- _{Subspace computations}
- _{New tools for cube design}
- _{Best practice design alerting}
- _{Backup cubes with better scalability}
- _{Excel - Data-mining add-ins for Excel}
_Reporting
- _{Reporting Services Deployment - IIS is no longer required to run Reporting Services}
- _{Rich-text support}
- _{Enhanced visualization graphing}
- _{Word - Reports can be rendered to Microsoft Word}
_Deprecation
- _{Many of the 'old' features are removed to include:}
  - _{60, 65 and/or 70 compatibility modes}
  - _{NOLOG and/or TRUNCATEONLY for the BACKUP command}
    - _{http://blogs.technet.com/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx}

8/21/2007 10:41:24 PM (GTB Daylight Time, UTC+03:00)

10/23/2007 9:37:41 PM (GTB Daylight Time, UTC+03:00)

http://www.anecamsp.org/phpBB2/viewtopic.php?p=93227
http://www.interfaculty.nl/forum/viewtopic.php?p=5014

beverlee |cristyAT NOSPAMgmail dot com

10/26/2007 9:59:12 AM (GTB Daylight Time, UTC+03:00)

http://www.metalexpressradio.com/forum/viewtopic.php?p=24450
http://www.slitlampimaging.com/phpBB2/viewtopic.php?p=36481

dee |ashlieAT NOSPAMgmail dot com

10/26/2007 9:59:47 AM (GTB Daylight Time, UTC+03:00)

http://www.metalexpressradio.com/forum/viewtopic.php?p=24450
http://www.slitlampimaging.com/phpBB2/viewtopic.php?p=36481

dee |ashlieAT NOSPAMgmail dot com

10/26/2007 11:06:01 AM (GTB Daylight Time, UTC+03:00)

http://www.worldcastradio.com/mb/viewtopic.php?p=2709
http://www.litebay.org/forum/viewtopic.php?pid=3406

daphne |chunAT NOSPAMgmail dot com

10/26/2007 11:32:12 AM (GTB Daylight Time, UTC+03:00)

http://www.hilleluic.org/board/viewtopic.php?p=46707
http://www.ds-ranch.net/guest_book/viewtopic.php?p=234413

charlie |chiAT NOSPAMgmail dot com

10/26/2007 12:14:03 PM (GTB Daylight Time, UTC+03:00)

http://www.ladyfuzz.com/forum/viewtopic.php?p=34675
http://georgesguetary.net/phpBB/viewtopic.php?p=7486

cathleen |cristinAT NOSPAMgmail dot com

10/26/2007 12:14:09 PM (GTB Daylight Time, UTC+03:00)

http://www.ladyfuzz.com/forum/viewtopic.php?p=34675
http://georgesguetary.net/phpBB/viewtopic.php?p=7486

cathleen |cristinAT NOSPAMgmail dot com

10/26/2007 12:14:44 PM (GTB Daylight Time, UTC+03:00)

http://www.oswaldasia.org/board/viewtopic.php?p=61743
http://www.theblackandwhitecomic.com/forum/viewtopic.php?p=4482

assunta |alysonAT NOSPAMgmail dot com

10/26/2007 3:14:47 PM (GTB Daylight Time, UTC+03:00)

http://www.mysterypartners.com/cgi-bin/ultimatebb.cgi?ubb=get_topic&f=10&t=000543
http://www.internetservices.gr/forums/viewtopic.php?p=7015

cinda |ashlynAT NOSPAMgmail dot com

10/27/2007 4:02:58 PM (GTB Daylight Time, UTC+03:00)

http://hardcreditcreadt.info/secured-credit-credit-find.html
http://fixingcdit.info/establishing-credit-right-away.html

adriana |chanelleAT NOSPAMgmail dot com

10/29/2007 2:27:46 PM (GTB Standard Time, UTC+02:00)

http://fixccritcard.info/payment-making-aspire-credit.html
http://forbad-creidit.info/approval-credit-score-card4840652.html

corrine |cecilAT NOSPAMgmail dot com

11/2/2007 3:20:45 AM (GTB Standard Time, UTC+02:00)

http://www.truecombat.fi/forum/viewtopic.php?pid=3155
http://www.sportzforumz.com/forums/index.php?showtopic=10156

constance |alaynaAT NOSPAMgmail dot com

11/2/2007 5:37:47 AM (GTB Standard Time, UTC+02:00)

http://www.kepi05.de/Forum/viewtopic.php?p=20825
http://www.planetaryuniversity.org/forum/viewtopic.php?p=4113

demetria |dahliaAT NOSPAMgmail dot com

11/2/2007 5:37:54 AM (GTB Standard Time, UTC+02:00)

http://www.kepi05.de/Forum/viewtopic.php?p=20825
http://www.planetaryuniversity.org/forum/viewtopic.php?p=4113

demetria |dahliaAT NOSPAMgmail dot com

11/2/2007 9:56:07 AM (GTB Standard Time, UTC+02:00)

http://www.movies-and-reviews.com/phpBB2/viewtopic.php?p=142985
http://northwesternclassalliance.org/phpbb/viewtopic.php?p=482508

aide |carolinAT NOSPAMgmail dot com

11/2/2007 11:29:53 AM (GTB Standard Time, UTC+02:00)

http://www.macminihacks.org/viewtopic.php?p=42059
http://www.artoparty.dk/forum/viewtopic.php?p=52223

crista |beataAT NOSPAMgmail dot com

11/2/2007 12:27:31 PM (GTB Standard Time, UTC+02:00)

http://infa-redinc.com/musicportal/forum/viewtopic.php?p=41173
http://www.facesforacure.com/forum/viewtopic.php?p=2580

angelique |annettaAT NOSPAMgmail dot com

11/2/2007 12:31:16 PM (GTB Standard Time, UTC+02:00)

http://www.glop.org/forum/viewtopic.php?pid=11814
http://musicaperuana.com/phpBB/viewtopic.php?p=63178

avis |aleaseAT NOSPAMgmail dot com

11/2/2007 12:31:26 PM (GTB Standard Time, UTC+02:00)

http://www.glop.org/forum/viewtopic.php?pid=11814
http://musicaperuana.com/phpBB/viewtopic.php?p=63178

avis |aleaseAT NOSPAMgmail dot com

11/2/2007 2:07:03 PM (GTB Standard Time, UTC+02:00)

http://totallysynthetic.com/forum/viewtopic.php?p=2705
http://www.edfromtheweb.com/forums/viewtopic.php?p=6642

antonina |corrinaAT NOSPAMgmail dot com

Name
E-mail
Home page

	Remember Me
Comment (HTML not allowed)