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
|
|
Data Warehouses Non Technical Issues | |
Data Warehouses Non Technical Issues When companies get ready to implement a data warehouse few of them pay attention to the political issues that may surround it It must be emphasized that politics can reduce the chances for success with a data warehouse project and I want to warn companies against
|
|
Technical Aspects of CRM | |
Technical Aspects of CRM While it must be emphasized that CRM is not a technology there are a number of technical issues that need to be considered when a company decides to implement a CRM system The first technical issue that needs to be analyzed is scalability In a nutshell the CRM system must be
|
|
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
|
|
|
