What's new in SQL 2008 Part 2 - The Diigo Meta page

• 07 Jul 08
  

  Mr. DiGi

  mssql 2008 database

  • Dynamic Development

      

    SQL 2008 leverages the new Dot Net Framework 3.0 with LINQ (Language Integrated Query). In addition, there is more efficient support for Business Data Entities along with data synchronization options. Also, there are new ADO and Visual Studio development options.

  • LINQ

        

    LINQ provides a standard development syntax for accessing data, regardless of where the data resides. For example, the same syntax can access either SQL Server or XML data. LINQ is used rather than TSQL inside the application language, such as C# or VB.

  • Data Synchronizing Features

        

    The combination of SQL 2008, Visual Studio, and ADO.NET bring together new methods of creating synchronizing or frequently disconnected applications, making it easier to create client applications that synchronize with a central database. SQL 2005 started by providing support for change tracking by using triggers. SQL 2008 synchronizing is better integrated and optimized.

  • Table Value Parameters

        

    In previous versions of SQL Server, there wasn’t a native way to pass a table to a stored procedure. The usual workaround was to pass a large varchar or XML type and parse through it. Now, in SQL Server 2008, Table Parameters are available. The following provides a simple example of passing a table into a Stored Procedure.

          

    CREATE TYPE PartType  AS Table (PartID varchar(50), Descr varchar(100), createdate datetime);   CREATE PROCEDURE AddPart(@PartList PartType READONLY) AS SELECT * FROM @PartList    DECLARE @PartTable PartType; INSERT INTO @PartTable values('Part1', N'Table Test', '2007-08-20'); EXEC AddPart @PartTable 

  • Full Text Search

        

    There are Full Text Search changes in SQL Server 2008 including native indexes, thesaurus files stored as metadata, and the ability to perform a Backup.

  • Reporting Server

        

    Memory management in SQL Server 2008 Reporting Service is improved. So running large reports will not consume all available memory. In addition, report rendering has more consistency than before.
  • •  Transparent Data Encryption allows for an entire database, all tables and data, to be encrypted on the fly without application programming.
      
    •  Backups can be encrypted to prevent data disclosure or tampering.
      
    •  Data changes and access can now be audited.
      
    •  Fact Tables can be compressed for performance benefits.
      
    •  The Resource Governor can prevent runaway resource usage.
      
    •  SQL 2008 supports Hot Plug CPU.
      
    •  Performance Counters have been greatly expanded.
      
    •  Installation has been simplified.
  • •  Data Integration Features such as the MERGE statement, Parallelism, SSIS multiple processor improvements, and look up performance improvements.
      
    •  Analysis Service Improvements including BI Stack performance, Scale out analysis, Block computations and Perspectives.
      
    •  Microsoft Office 2007 Integration such as Exporting Reporting Service reports as Word docs, SSRS format and font improvements, and the Office Tool Bar.

  6 more annotations...

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.