Free PDF Manual Guide

User Manuals – Owners Manual – User Guide

SQL Server Integration Services

SQL Server Integration Services is an all-new subsystem for SQL Server 2005. With SQL Server 2005 Microsoft has replaced the old Data Transformation Services (DTS) with the all-new SQL Server Integration Services (SSIS). It’s important to understand that SSIS isn’t a reworked version of DTS. Instead, Microsoft rewrote SSIS from the ground up. Microsoft’s goal for SQL Server 2005’s Integration Services was to make it an enterprise ETL platform for Windows on a par with any of the stand-alone enterprise-level ETL products. The new SSIS is completely redesigned and built using managed .NET code, giving it a more robust foundation.
[Read the rest of this entry...]

Leave a Comment

Microsoft SQL Server “Always On” Technologies

The Microsoft SQL Server Storage Solution Review Program is a specific SQL Server program that enables storage solution providers to highlight those storage solutions and configurations, via the SQL Server “Always On” labeling, that they have successfully reviewed against core functional Microsoft SQL Server storage requirements. The core requirements defined herein must be met for reliable, highly available SQL Server storage systems.
[Read the rest of this entry...]

Leave a Comment

Open Source FOD Provider for Microsoft SQL Server 2008

Questions and Answers for the new Open Source FDO Provider for Microsoft® SQL Server™ 2008 Database Software
Autodesk FDO Data Access Technology (FDO) addresses the need for openness and interoperability between traditional geographic information system (GIS) applications and mainstream operational information technology (IT) systems, as well as integration with public or private web mapping services. Incorporated into Autodesk® Geospatial products, and also available as a stand-alone, open source technology for developers, FDO helps increase productivity and save time by enabling users to work on a variety of spatial and non-spatial databases and file formats natively, without the need for translation and risk of data loss.
[Read the rest of this entry...]

Leave a Comment

Configuration best practices for Microsoft SQL Server 2005

Configuration best practices for Microsoft SQL Server 2005 with HP StorageWorks Enterprise Virtual Array 4000 and HP blade servers is a best practices paper that leverages HP servers, storage, and management software by providing the recommended best practices for configuration of an HP StorageWorks Enterprise Virtual Array (EVA) storage subsystem deployed into a Microsoft® SQL Server 2005 environment with HP servers. Additionally, sizing and performance data based on the tested reference configuration is presented. The paper covers guidelines for a total end-to-end deployment of Microsoft SQL Server, encompassing servers, storage, management software, and offline full database backup practices.
[Read the rest of this entry...]

Leave a Comment

Microsoft SQL Server and Oracle® Database – A Comparative Study on Total Cost of Administration (TCA)

As platforms continue to evolve in the technology industry, a central concern for IT executives is implementing the right systems to maximize the return on their investments. Since labor costs dominate most IT budgets, selecting platforms with lower implementation and on-going management costs can significantly improve overall IT efficiency, and allow for the reallocation of resources from basic maintenance and operations to more innovative functions. In this paper, Alinean, an independent IT value analyst firm, examines the Total Cost of Administration (TCA) for two of the industry’s leading database management offerings from Microsoft Corp. and Oracle®.
[Read the rest of this entry...]

Leave a Comment

Siebel Analytics Tuning on Microsoft SQL Server

Microsoft Corporation faced a gap in delivering accurate, timely, & easily consumable information to its sales force community. Sales force data was stored in SQL Server 2000 databases on multiple source systems including Siebel CRM. Those divergent data sources contained different aspects of sales data such as sale quotas in the incentive compensation system and sales opportunity information in the Siebel CRM system. Having the data in separate databases prevented the information from being utilized to its full potential.
[Read the rest of this entry...]

Leave a Comment

Microsoft SQL Server 2005 for the Oracle Professional

This whitepaper explains the key differences between Microsoft® SQL Server™ 2005 databases and Oracle databases. It compares SQL Server and Oracle database architecture and provides information on the newest features in SQL Server 2005. This paper is intended for Oracle professionals who want to leverage their Oracle knowledge to manage SQL Server or prepare to migrate an Oracle database to SQL Server 2005. Other topics discussed in this white paper include backups, database security, management options and high availability options.
[Read the rest of this entry...]

Leave a Comment

Comparing Microsoft SQL Server 2005 Replication and DataXtend Remote Edition

Progress® DataXtend™ Remote Edition and Microsoft® SQL Server™ both provide a set of replication tools for copying, distributing, and synchronizing data from one database to another. DataXtend RE (Remote Edition) provides the most comprehensive and flexible replication and synchronization tools available for software developers and enterprise IT departments to make their applications mobile and available both on-line and off-line. While SQL Server replication technology can be used for replicating data for reporting, backup and recovery, or mobile applications, its features are better suited for non-mobile, non-distributed/connected applications.
[Read the rest of this entry...]

Leave a Comment

Migrating from Microsoft Access to the MySQL database

Microsoft Access is a popular data management application that allows you to store information in tables that it manages directly from the local disk. You can also use Access as a front end, that is, as an interface to information that is located elsewhere and handled by another storage management system. In this case, Access acts as a client that connects to a server that provides the data. The MySQL database system is one such storage manager; if you install the MyODBC driver, Access can make ODBC connections to MySQL database servers over the network. You can still use the contents of your tables through Access, but the tables themselves are hosted by the MySQL server.
[Read the rest of this entry...]

Leave a Comment

Data Conversion between Microsoft Access and MySQL

One of the most popular applications is Microsoft Office Access since it doesn’t require considerable computer knowledge and skills to deal with. Microsoft Access is a relational database management system (DBMS) that provides an effective set of tools that make organizing, accessing, and sharing information easier than ever.Along with actual strengths MS Access has storage management limitations so it is usually used as a personal or single-user application, mostly for managing limited quantity of data.
[Read the rest of this entry...]

Leave a Comment