SQL Server 2005 Integration Services Review | |
SQL Server 2005 Integration Services using Visual Studio 2005 A Beginner s Guide SQL Server 2005 A offering of Microsoft Corporation for database management the SQL server 2005 is one of the powerful database management systems in the world Available for integration in almost any system that uses Mi
|
|
Language Enhancements in SQL Server 2005 | |
The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities.
Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression an
|
|
Security enhancements in SQL Server 2005 | |
The trustworthy computing initiative has contributed greatly to help microsoft improve customer experience. A number of customer needs on security have been addressed.
1. Restricting user access to sql server
2. Disabling services and restricting service configuration
3. Reducing the surface are aof
|
|
Application Frameworks in SQL Server 2005 | |
The new application framework of SQL called the Service Broker is a distributed application framework that provides relable asynchronous messaging at the database to database level. It allows internal and external processes to exchange streams of reliable asynchronous messages using extensions of T-
|
|
ADO.NET new Features in SQL Server 2005 | |
The new features of ADO.NET are:
1. Query change notifications
2. multiple active result sets
3. Native type support
4. Notification support for SQL Server queries.
The above features make for greater flexibility and scalability and commands can now be sent to the SQL Server to request that a notifi
|
|
SQL Server 2005 - Configuring Replication | |
SQL Server 2005 Configuring Replication In this tutorial you will learn about SQL Server 2005 Configuring Replication New Types of Replication Peer to Peer Transactional Replication Replication Configuring Replication Configuring Replication Using RMO Referencing the RMO and SMO libraries and Creat
|
|
SQL Server 2005 Replication Enhancements | |
SQL Server 2005 Replication Enhancements In this tutorial you will learn about Overview of Replication Enhancements User Interface Enhancements Merge replication concurrency Enhancements Programming changes The Replication Monitor Performance and Scalability Features Pre computed partitions Updates
|
|
SQL Server 2005 - Mirror Server | |
SQL Server 2005 Mirror Server In this tutorial you will learn about Mirror Server in SQL Server 2005 Preparing the Principal and Mirror Server Establishing a Mirroring Session Establishing a Witness Server Executing Transactions Simulating Principal Server Failure Restarting the Failed Server Termin
|
|
SQL Server 2005 - Introduction to Data Availability | |
SQL Server 2005 Introduction to Data Availability In this tutorial you will learn about Data Availability in SQL Server 2005 Failover clustering Database mirroring Log shipping Replication Introduction to Database Mirroring and advantages of mirroring mosgoogle SQL Server 2005 introduces several hig
|
|
SQL Server 2005 - Backing up a Database | |
SQL Server 2005 Backing up a Database In this tutorial you will learn about Backing up a Database in SQL Server 2005 Backup and Restore operations Restoring System Databases Media Reliability Using Checksums during backup and Restore and Backup Media mirroring mosgoogle Backup and Restore operations
|
|
|
