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
|
|
jQuery Three-color Alternating Pattern | |
Learning jQuery Three color Alternating Pattern There may be times when we want to apply more complex striping For example we can apply a pattern of three alternating row colors rather than just two To do so we first need to define another CSS rule for the third row We ll also reuse the odd and even
|
|
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
|
|
|
