SQL Farm Combine 3.0

SQL Farm Combine 3.0 is created to provide you with a scale-out tool and framework for working with many SQL Servers, instances, and databases in parallel. Combine is a leading SQL Server deployment tool that allows users to execute multiple SQL scripts and push changes to multiple databases and servers in parallel, deploy code to all SQL server instances, automate SQL Server deployments, and move changes from Development to QA and to Production. Combine also offers distributed querying and data collection capabilities to return data from all databases and SQL server instances in a single result set:

Users can query multiple databases and SQL servers or instances, receive one result set from all servers, save results to databases or datawarehouses, and so on. Using Combine, it is easy to query performance metrics and retrieve custom data from all databases and servers in one click, without any remote agents or installations. SQL Farm Combine allows database administrators (DBAs) automate project releases, stop SQL services on all network instances, and administer a farm of SQL Server instances the same way they manage a single database today.

The tool also offers command line executions and deployment to support scheduled deployments and changes. Redistributable components and licenses are available as well. More information is available on SQL Farms, Inc. website. SQL Farm Combine is used extensively in the largest data centers in the work, for deployment, monitoring, reporting, data collection, administration, and automation of daily admin tasks. Based on a patent-pending technology, SQL Farm Combine is designed to scale and manage datacenters and SQL server environments with the same simplicity users manage a single database today.

1. SQL Farm Combine™ offers distributed querying capabilities that allow you to write SQL scripts (or simple SELECT statements) and then execute them against preconfigured groups of databases on any number of servers in parallel. The data returned from all databases and servers is then automatically aggregated by Combine and written to one or more "output" databases or to portable files that can be passed to other users.
2. Sample data collection and monitoring projects are available for download on our website and allow you to monitor the status of SQL jobs on all servers, as well as collect database files statistics and information. Custom monitoring and data collection tasks can be easily built by following the instructions and samples in the user manual.

 Major Features:

1. Get performance metrics from all SQL servers & instances
   
   • SQL Farm Combine™ allows users to write scripts and queries (e.g., to query dynamic management views, system tables, to execute stored procedures or run DBCC statements to collect performance metrics) and then automatically returns a single aggregated and unified result set from all databases and SQL server instances. Users control the SQL code that is executed, the databases and servers on which the queries and scripts are run, as well as the execution order to guarantee fast and easy data collection. Moreover, all aggregated data and results can be automatically stored to databases or to files that can be opened and viewed by other (including remote) users.
2. Easily manipulate collected data or schema
   
   • SQL scripts used to retrieve and auto-store data are part of a Combine project, and projects can contain many other custom scripts. Each script in the project is mapped to a preconfigured group of databases on any number of servers. When the project is executed (either on a scheduled basis or on demand), then every scripts is run against all its associated target databases and servers. In addition, the user has full control over the project and order of code deployment.
3. Auto-store data in your custom schema or configure Combine to automatically create schema in run-time
   
   • SQL Farm Combine™ auto-saves the collected data in one or more "output" databases, which are fully configurable and controlled by the user. In addition, you can either configure Combine to write results and data to existing tables or create new schema in run-time while data is being collected.
4. Scheduled data collection tasks
   
   • Data collection and auto-storage can be run on demand using the SQL Farm Combine™ user interface, or you can schedule the entire data retrieval and auto-storage process using command line utilities and scheduled tasks. Scheduled data collections are defined and created in SQL Farm Combine™, which includes end-to-end schedule management. Samples and user manuals are available for download on our website.
5. Embed data collection capabilities in Web pages, Web applications or custom projects
   
   • SQL Farm Combine™ can be called from Web servers or custom applications to automatically collect and return data to the caller. The tool can also be used (for example) to create a stored procedure that queries data from multiple database and servers, without any remote installations or dependencies. Typical examples of embedding SQL Farm Combine™ data-collection features in custom applications include calling data collection tasks from Web pages to get and display data from a large number of back-end databases, or collecting data from many SQL servers and instances using stored procedures for database applications.
6. Get detailed data collection report and results
   
   • Every time Combine is launched to collects data it saves a detailed report and audit trail. You can open this report in Combine and view each step performed during the data collection task. This report includes messages, SQL statements, execution plans and all other information returned from all databases and servers.
7. Email notifications to track data collection tasks
   
   • Combine can be easily configured to integrate with your SMTP server and automatically send email notifications in response to various events during the data collection task. Furthermore, you can instruct Combine to attach the data collection report & results to this email or only send email in the event of errors or issues.
8. Write custom monitoring tasks or download sample tasks from our website
   
   • Sample data collection projects and manuals are available for download on our website. The sample projects allow you to monitor the status of all SQL jobs across all servers, or monitor the database file size and filegroups on all databases and servers in your enterprise. The provided manuals include step by step instructions and templates to build custom data collection tasks that can be used in many monitoring and reporting applications.

Enhancements:

Smart data aggregation and redistributable components and license offerings to collect performance data or query custom data in remote SQL server environments without remote installations are now available in SQL Farm Combine 1.9.

Requirements:

• 512MB RAM,
• 256MB Free Disk Space

 WareSeeker Editor