WHAT IS IN NEW AND OLD MS SQL SERVER (2008 TOPICS)

A)   Database Engine

i)                Architecture

ii)               Database Design(Designing Tables)

iii)            Constraints

iv)             Transact SQL:(Joins,SubQueries,Co-Related Queries)

v)                Store Procedure

vi)             User Define Functions(UDF)

vii)           Triggers

viii)          Cursors

ix)             Indexes

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.

xii)             Transactions.

xiii)           XML (Important)

xiv)          Security

xv)            Full Text Search(e.g: google, Alta-Vista)

xvi)          Backup & Recovery

B)   REPLICATION

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.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s