آموزش تخصصی کامپیوتر

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.