Romanian SQL Server User Group

• Transparent data encryption

• External key management

• Data Auditing

• Hot Add CPU

• Database Mirroring Improvements

• Transparent failover for Database Mirroring

• Automatic recovery from page corruption

• Log stream compression (Database Mirroring)

• New Performance Counters for Database Mirroring

• Declarative Management Framework

• Server Group Management

• Streamlined installation

• Enterprise System Management

• Performance Data Collection

• System Analysis

• Data compression

• Resource Governor

• Query Optimization Modes

• Extended Events

• Logging Improvements (Minimal Logging = log only what is necessary for rollback)

• Entity Data Model

• Language Integrated Query (LINQ)

• Visual Entity Designers

• Entity Aware Adapters

• SQL Server Change Tracking

• Synchronized Programming Model

• Visual Studio Support

• SQL Server Conflict Detection

• BLOBS in SQL SERVER 2008

• FileStream data type

• Remote BLOB Store API

• Integrated Full-Text Search

• Sparse columns

• Large user-defined types

• Date/Time Data types

• LOCATION data type

• SPATIAL data type

• Backup compression
• Partitioned table parallelism
• Star join query optimizations
• Resource Management
• Grouping Sets
• Change Data Capture
• MERGE SQL statement
• Scalable Integration Services
• SQL Server Integration Services (SSIS) pipeline improvements
• SSIS persistent lookups
• Analysis scale and performance
• Block computations
• Writeback
• Enterprise Reporting Engine
• Better scale-out configuration
• Internet report deployment
• Manage the reporting infrastructure
• Report Builder enhancements
• Built-in forms authentication
• Report Server application embedding
• Office integration
• TABLIX

Add to that:

• FORCESEEK table hint
• New Dynamic Management Views
• Memory Related Dynamic Management Views
• Visual designer, and add nodes to a peer-to-peer replication configuration without stopping system activity
• Performance Studio to troubleshoot, tune, and monitor
• Table-valued parameters
• Transact-SQL Row Constructors (Table-valued constructors)
• Include Scalar Values in Row Constructors (

  INSERT INTO MyTable (ColX,ColY)

         VALUES ((SELECT Top 1 ColZ FROM MyOtherTable),

  (SELECT Top 1 ColW FROM MyOtherTable));

  )
• One statement variable declaration/assignment
• Compound Assignment Operators
• HierarchyID data type
• Deprecation Counters 
• Large User Defined Aggregates
• New versions of ODBC driver, OLE DB provider, and ADO.NET data provider
• SQLCE Version 3.5
• Lock Escalation changes

 Unconfirmed yet:

• Intellisense
• Debug in SSMS 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

Resources:

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• SQL Server 2008: Transparent data encryption feature - a quick overview from Laurentiu Cristofor's blog
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• SQL Server 2008 Transparent Data Encryption from Kimberly L. Tripp's Blog
• White-papers:
• Online Transaction Processing  
• Webcasts:
• Webcast - SQL Server 2008 - First Look
• E-Learning
• Clinic 7045: What's New in Microsoft® SQL Server™ 2008

 

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
  •  Katmai (Sql 2008) - The List of New Features  from Sql Stuff
  • SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• White-papers:
  • SQL Server 2008 Product Overview  
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai (Sql 2008) - Data Compression (including Backup Compression)  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• SQL Server 2008 Data Compression from Shailan - Data for the Masses
• Data Compression: Why Do we need it? from SQL Server Storage Engine
• Data compression techniques and trade offs from SQL Server Storage Engine
• White-papers:
  • SQL Server 2008 Product Overview 
  • Choosing Microsoft SQL Server 2008 for Data Warehousing 
  • Business Intelligence in SQL Server 2008
  • SQL Server 2008 Performance and Scale
  • Online Transaction Processing in SQL Server 2008
  • Server Consolidation with SQL Server 2008
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
  • The Next Release of Microsoft SQL Server: Data Warehousing Enhancements
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai (Sql 2008) - Data Compression (including Backup Compression)  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• SQL Server 2008 Data Compression from Shailan - Data for the Masses
• White-papers:
• SQL Server 2008 Product Overview 
• Choosing Microsoft SQL Server 2008 for Data Warehousing 
• Business Intelligence in SQL Server 2008
• Online Transaction Processing in SQL Server 2008
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
  • The Next Release of Microsoft SQL Server: Data Warehousing Enhancements
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• sys.dm_os_memory_brokers
• sys.dm_os_memory_nodes
• sys.dm_os_nodes
• sys.dm_os_process_memory
• sys.dm_os_sys_memory
  

Resources:

• Articles
• Blogs
• Scale up with SQL Server 2005 / SQL Server 2008 - NUMA from Ravi S.Maniam's Blog
   
• White-papers:
• Webcasts:
• E-Learning
• Clinic 7045: What's New in Microsoft® SQL Server™ 2008

 

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• Declarative Management: Behind Enforce from Dan's Blog
• Declarative Management Performance from Dan's Blog
• White-papers:
• SQL Server 2008 Product Overview
• Server Consolidation with SQL Server 2008
• SQL Server 2008 Manageability
• Online Transaction Processing in SQL Server 2008
• Webcasts:
• Webcast - SQL Server 2008 - First Look
• SQL Server Katmai June CTP: Declarative Management Framework (DMF)
• E-Learning:
• Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• Katmai: Variable Initialization and Assignment Operators from The Zen of Database Development
• Webcasts:
• Webcast - SQL Server 2008 - First Look

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• Store any data in SQL Server 2008 (Katmai) from Pedram Rezaei's Ramblings
• White-papers:
• SQL Server 2008 Product Overview 
• Business Intelligence in SQL Server 2008
• Managing Unstructured Data with SQL Server 2008
• Microsoft SQL Server 2008 and Microsoft Data Platform Development
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
  • TechNet Webcast: Going Beyond Relational Data with Microsoft SQL Server 2008 (Level 200)
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai (Sql 2008) - Data Compression (including Backup Compression)  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• SQL Server 2008: Backup Compression from In Recovery... Paul Randal on SQL Server 
• White-papers:
  • SQL Server 2008 Product Overview 
  • Choosing Microsoft SQL Server 2008 for Data Warehousing 
  • Business Intelligence in SQL Server 2008
  • SQL Server 2008 Performance and Scale
  • Online Transaction Processing in SQL Server 2008
  • Server Consolidation with SQL Server 2008
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
  • The Next Release of Microsoft SQL Server: Data Warehousing Enhancements
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai (Sql 2008) - Data Compression (including Backup Compression)  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• SQL Server 2008: Automatic Page Repair with Database Mirroring from In Recovery... Paul Randal on SQL Server 
• White-papers:
  • SQL Server 2008 Product Overview 
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai (Sql 2008) - Data Compression (including Backup Compression)  from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• SQL Server 2008: Parallelism improvements for partitioning from In Recovery... Paul Randal on SQL Server 
• White-papers:
  • SQL Server 2008 Product Overview 
  • Choosing Microsoft SQL Server 2008 for Data Warehousing 
  • Business Intelligence in SQL Server 2008
  • SQL Server 2008 Performance and Scale
• Webcasts:
  • Webcast - SQL Server 2008 - First Look
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai - Did you know? Inline variable initialization and Compound assignment from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• Katmai: Variable Initialization and Assignment Operators from The Zen of Database Development
• Webcasts:
• Webcast - SQL Server 2008 - First Look

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• Katmai (Sql 2008) - The List of New Features  from Sql Stuff
• Katmai - Did you know? Inline variable initialization and Compound assignment from Sql Stuff
• SQL Server 2008 new features - the list from Bob Beauchemin's Blog
• Katmai: Variable Initialization and Assignment Operators from The Zen of Database Development
• Webcasts:
• Webcast - SQL Server 2008 - First Look
• Screencast - SQL Server 2008: Plus Equals operator in T-SQL

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

• Articles
• SQL Server 2008 - Features, Function and Value 
• Blogs
• SQL Server 2008: Lock escalation changes from In Recovery... Paul Randal on SQL Server
• SQL Server 2008 offers partition-level lock escalation *excellent*, but... from Kimberly L. Tripp's Blog
• White-papers:
  • SQL Server 2008 Performance and Scale
• Webcasts:
• E-Learning
  • Clinic 7045: What's New in Microsoft® SQL Server™ 2008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro