A) Database Engine
ii) Database Design(Designing Tables)
iv) Transact SQL:(Joins,SubQueries,Co-Related Queries)
v) Store Procedure
vi) User Define Functions(UDF)
x) User Define Types(New)
xi) CLR Integration(New) 2005:
We can write same keywords like (System. SqlClient, System.Data) in SQL Server because of CLR but Oracle doesn’t support it.
xiii) XML (Important)
xv) Full Text Search(e.g: google, Alta-Vista)
xvi) Backup & Recovery
C) DISTRIBUTED QUERIES
D) INTEGRATION SERVICES:-
For fetching the data from various types of the file like Notepad, Excel, Word, PDF etc. Manipulation is possible by the Integration Services.
E) REPORTING SERVICES:-
It’s a reporting tool of Microsoft. It comes under the MS SQL only. No need to Install the IIS in 2008.
F) ANALYSIS SERVICES:-
G) SQL AGENT:
Scheduling is possible thought the SQL Agent. Scheduling means Automatic Email Sending and Daily Database Backup.
H) SQL INJECTION
I) SQL PROFILER:- It’ used for the optimization.
J) ERROR HANDLING
K) BCP (BULK COPY PROGRAM)
L) SERVICE BROKER:(For messaging)
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi‑structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored.
SQL Server 2008 enables you to consume your data within custom applications developed using Microsoft .NET and Visual Studio and within your service‑oriented architecture (SOA) and business process through Microsoft BizTalk Server while information workers can access data directly in the tools they use every day, such as the 2007 Microsoft Office system. SQL Server 2008 delivers a trusted, productive, and intelligent data platform for all your data needs.