| 10 ویژگی و امکانات جدید sql server 2008
the top 10 new developer features in Microsoft’s new SQL Server 2008 release.
1. Language Integrated Query (LINQ)—From a database developer’s perspective, undoubtedly the most signifi cant new feature in SQL Server 2008 is support for LINQ. LINQ is an evolutionary step forward for database developers. LINQ simplifi es the database development process by enabling developers to write queries directly in either native VB or C#. This speeds up application development by providing the developer with immediate feedback through IntelliSense as well as compile time error checking that wasn’t possible using the older ADO.NET and T-SQL development paradigm. 2. IntelliSense in SQL Server Management Studio (SSMS)—Another very welcome enhancement is the addition of IntelliSense to SSMS. The new IntelliSense support in SSMS provides T-SQL statement completion. It can also automatically display the names of database objects and provide parameter prompting for stored procedures and functions. 3. New FILESTREAM Data Type—Designed to solve the problem of unstructured large object (LOB) storage, the new FILESTREAM combines the performance of the native NTFS fi le system with the transactional integrity of the relational database. The FILESTRAM data type enables unstructured data to be stored in the NTFS fi le system. The SQL Server relational engine manages the link between the columns defi ned using the FILESTREAM type and the fi les in the fi le system. SQL Server is responsible for all transactional integrity including backing up and restoring fi le system data.
44. New Date/Time Data Types—Although the old DATETIME data type offered basic date and time data storage formatting the data was always a problem; plus, it introduced diffi culties in converting data from other database systems that used discreet date and time column values. The new DATE data type is a native SQL Server data type that’s ANSI compliant. It uses the format YYYY-MM-DD and can contain values from 0001-01-01 to 9999-12 The TIME data type, complements the DATE data type. TIME uses the format hh:mm:ss[.nnnnnnn] and can contain values from 00:00:00.0000000 to 23:59.59.9999999. 5. New DataTime2 and DateTimeOffset Data Types—DATETIME2 and DATETIMEOFFSET are designed to address the need for more precise date/time storage and time-zone-aware date values. DATETIME2 uses the format YYYY-MM-DD hh:mm:ss[.nnnnnnn]. It can store values ranging from 0001-01-01 00:00:00.0000000 through 9999-12-31 23:59.59.9999999. DATETIMEOFFSET enables the same date/time storage as DATETIME2 but it’s also time-zone aware. 6. New Spatial Data Types—The new GEOGRAPHY and GEOMETRY spatial data types facilitate the development of mapping applications. GEOGRAPHY uses a geodetic (round earth) model. It stores points, lines, polygons, and collections of latitude and longitude coordinates. GEOMETRY uses a planar (fl at earth) model, unlike GEOGRAPHY, which is primarily designed for navigation and mapping. GEOMETRY complies with Open Geospatial Consortium standards for the representation of geographic features. 7. T-SQL Merge—The MERGE statement also allows you to merge the rows from multiple tables. You can choose to update matched rows, insert unmatched rows, or delete unmatched rows from the primary table. When the MERGE statement runs it can check whether a row exists and then execute the required INSERT, UPDATE, or DELETE statement. The schema of the merged tables does not have to be identical and the MERGE statement can specify columns to match and update. 8. Table-valued Parameters—Another cool new developer feature in SQL Server 2008 is support for passing tables as parameters to stored procedures. Table variables have been supported since SQL Server 2000. However, you were never able to use them as parameters. Using table variables as parameters can help simplify your code and eliminate the system overhead otherwise required to create and manage temporary tables. 9. Support for Sync Services—SQL Server 2008’s support for Sync Services in the .NET Framework 3.5 enables mobile applications to provide mobile users with the same application experience whether they are connected or disconnected. Mobile applications use SQL Server Compact edition as a local data store. Sync Services then periodically connects the mobile application to SQL Server 2008, providing bi-directional updates with from the mobile application. Sync Services handles the connection and synchronization between SQL Server and the mobile data store. 10. PowerShell Integration—PowerShell is Microsoft’s newest object oriented scripting language. SQL Server 2008 provides a new SQL Server Relational Engine provider that enables PowerShell scripts to access SQL Server database objects. In addition, a new SQL Server Policy Management provider enables you to use PowerShell to manipulate SQL Server’s new policy-based management framework.
|