147 free SQL Server PowerShell scripts: 89 example scripts for managing SQL Server objects. Initialize PowerShell SQLPS module and work with databases. Scripts for Analysis, Integration, and Reporting services. Experimental support for SQL Server 2016. New scripts for exploring In-Memory databases and query store features. Database engine: Connect to a server instance, manage databases, and publish scripts. Work with policies and SQL Server logs. Maintain security and backups. Create and manage SQL Server jobs. Get extended event information. Analysis Services: Connect to an Analysis Services instance. Get connection information. Get a list of databases. Backup databases and remove old backups. Restore a database. Integration Services: Start and stop services. Get package information. Provision a catalog. Publish a project. Modify catalog settings. Reporting Services: Start or stop services. Get instance information. Backup and restore encryption keys. Get configuration information. Get event log information. In-Memory Databases: Get overall utilization. Get size on disk. Get detailed utilization by table. Get checkpoint size. Query Plan: Set Query Plan desired state. Set Query Plan data retention maximum size. Get Query Plan information. Get Query Store status. Center for Internet Security (CIS) benchmarks: Surface area reduction, authentication and authorization, password policies, auditing and logging, application development, and start and stop SQL Server browser service. Azure SQL Database: Initialize PowerShell module, set scaling level, and set auditing and threat detection, get database properties, get alert definitions, and set and get alert rules, get query results, and get query metric data.
VERSION HISTORY
- Version 6.0 posted on 2018-07-12
This is a major product update
Program Details
- Category: Business > Databases & Tools
- Publisher: IDERA, Inc.
- License: Free
- Price: N/A
- Version: 6.0
- Platform: windows
EULA
'FREEWARE EDITION SOFTWARE LICENSE AGREEMENT Idera, Inc. 2950 North Loop Freeway West Suite 700 Houston, Texas 77092 Ph: (713) 523-4433 Fax: (713) 862-5210 BY PROCEEDING TO INSTALL OR USE THE SOFTWARE IN WHICH THIS AGREEMENT IS ELECTRONICALLY EMBEDDED, YOU HEREBY ACKNOWLEDGE AND AGREE TO BE BOUND BY THE FOLLOWING TERMS AND CONDITIONS. IF YOU DO NOT AGREE WITH THESE TERMS AND CONDITIONS, THEN CLICK “DO NOT ACCEPT,” DO NOT INSTALL OR USE THE SOFTWARE. BY CLICKING ON “ACCEPT” YOU ACKNOWLEDGE AND AGREE THAT ON BEHALF OF YOURSELF AND YOUR EMPLOYER YOU HAVE READ THIS SOFTWARE LICENSE AGREEMENT (THIS “AGREEMENT”) CAREFULLY, THAT YOU AND YOUR EMPLOYER AGREE TO BE BOUND BY THIS AGREEMENT AND THAT IF APPLICABLE YOUR EMPLOYER HAS INFORMED YOU OF THE RELEVANT PROVISIONS OF THIS AGREEMENT WHICH MAY BE APPLICABLE TO YOU. THIS AGREEMENT, SHALL GOVERN YOUR INSTALLATION AND USE OF THE SOFTWARE IN WHICH THIS AGREEMENT IS ELECTRONICALLY EMBEDDED UPON YOUR AGREEMENT TO PURCHASE SUCH SOFTWARE. IDERA URGES YOU TO CAREFULLY READ THIS AGREEMENT AND ASSESS YOUR USE OF THE SOFTWARE PRIOR TO INSTALLING OR USING THE SOFTWARE. THIS SOFTWARE LICENSE AGREEMENT, dated as of the date of Customer’s installation of the Licensed Software, between Idera, Inc., a Texas corporation (“Idera”), and the person installing or using the Licensed Software or for whose benefit the Licensed Software is being installed or used (“Customer”), sets forth the terms and conditions whereby Idera agrees to provide to Customer and Customer agrees to acquire from Idera one or more limited licenses to use certain software and documentation in which this Agreement is embedded. In consideration of the mutual promises and agreements contained herein, the parties hereto also agree as follows: GENERAL TERMS AND CONDITIONS Definitions - “Agreement” means this Freeware Edition software license agreement. “Confidential Information” means all technical and non-technical information in both tangible and intangible form, including, but not limited to, product design information, software code, technical information, customer information, cost and pricing information, financial information, the terms of this Agreement and the results derived from or methodology employed by Customer in conducting any benchmark testing of the Licensed Software; provided that the term “Confidential Information” shall not include information which the recipient can show by reasonable proof (i) to have been known by the recipient prior to the time of disclosure by the disclosing party, (ii) to have become part of the public domain through no fault or breach of this Agreement by the recipient, (iii) to have been disclosed to the recipient in good faith by a third party who is not under any obligation of confidence or secrecy to the disclosing party at the time such third party discloses the information to the recipient or (iv) to have been compelled to be produced by a court of competent jurisdiction, provided that the recipient shall first give notice to the disclosing party of any such request or order of the court to give the disclosing party an opportunity to contest or limit said request or order of the court. “Customer” means the person installing or using the Licensed Material or for whose benefit the Licensed Material is being installed or used. “Effective Date” means the date upon which Customer installs the Licensed Software. “Licensed Documentation” means the published user manual that Idera makes generally available for the License Software. “Licensed Material” means the Licensed Software and the Licensed Documentation. “Licensed Software” means the machine-readable object code version of (i) the software specified on each Purchase Order, whether embedded on disc, tape, internet download site or other media and (ii) all Updates, revisions, enhancements, improvements and modifications to and programming fix for the Licensed Software that Customer is entitled to receive. LICENSE -Subject to the terms and conditions of this Agreement and Customer’s full compliance herewith and according to the scope, time period and other terms indicated herein, Idera hereby grants Customer during the Term (as defined in Section 6 below) and Customer hereby accepts from Idera, a limited, terminable, non-exclusive and non-transferable right and license to install and use the Licensed Material on computer hardware that is owned or operated by or on behalf of Customer solely for Customer’s internal business use and to copy the Licensed Material as permitted by this Agreement. Customer may install and use one copy of the Licensed Software on one instance per license provided by Idera to Customer. Customer’s right to use the Licensed Material shall extend to use by third parties under contract with Customer to provide outsourcing services for Customer's own internal business use; provided, such third parties have agreed to abide by the terms of this Agreement, including the confidentiality provisions contained herein. Customer shall reproduce all confidentiality and proprietary notices on each of the copies permitted hereunder and maintain an accurate record of the location of each of the copies. Customer shall not otherwise copy or duplicate the Licensed Material. Customer shall not reverse engineer, disassemble, translate, modify, adapt, or decompile the Licensed Material or apply any procedure or process to the Licensed Material in order to ascertain, derive, and/or appropriate the source code or source listings for the Licensed Software or any trade secret or other proprietary information contained in the Licensed Software. Customer acknowledges that all use of the Licensed Material by Customer is restricted to “internal business use” only. The term “internal business use” means that the Licensed Material only be licensed to and used by and for the benefit of Customer on computer hardware that is owned or operated by or on behalf of Customer and may not be used for the benefit of or in connection with any other person, corporation, partnership, limited liability company or other business entity. PROPRIETARY RIGHTS - Customer shall not acquire, by virtue of this Agreement, any right or license other than as expressly provided herein. Customer shall not reproduce the Licensed Material or other confidential or proprietary information of Idera, except as provided in this Agreement. All proprietary rights in and to the Licensed Material, all derivatives, translations, modifications, adaptations, improvements, enhancements or developments thereof and all confidential or proprietary information of Idera, including without limitation, all rights under and with respect to patents, copyrights, trademarks and rights under the trade secret laws of any jurisdiction shall remain the property of Idera or its applicable licensor, whether recognized by or perfected under applicable local law. Customer shall promptly notify Idera of any infringement of Idera’s proprietary rights of which it becomes aware. NO WARRANTY WARRANTY - CUSTOMER ACKNOWLEDGES AND AGREES THAT THE LICENSED MATERIALS ARE PROVIDED ON AN “AS IS” BASIS WITHOUT ANY WARRANTIES OF ANY KIND. IDERA MAKES NO WARRANTIES THAT THE USE OF THE LICENSED MATERIAL WILL BE ERROR-FREE OR UNINTERRUPTED, OR ANY OTHER WARRANTIES, WHETHER EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. NO CONSEQUENTIAL DAMAGES - UNDER NO CIRCUMSTANCES WILL IDERA OR ITS AUTHORIZED REPRESENTATIVES BE LIABLE FOR ANY CONSEQUENTIAL, INDIRECT, SPECIAL, PUNITIVE, EXEMPLARY OR INCIDENTAL DAMAGES, WHETHER FORESEEABLE OR UNFORESEEABLE, BASED ON CLAIMS BY CUSTOMER OR ANY THIRD PARTY (INCLUDING, BUT NOT LIMITED TO, CLAIMS FOR LOSS OF DATA, GOODWILL, PROFITS, USE OF MONEY OR USE OF THE PRODUCTS, INTERRUPTION IN USE OR AVAILABILITY OF DATA, STOPPAGE OF OTHER WORK OR IMPAIRMENT OF OTHER ASSETS), ARISING OUT OF BREACH OF EXPRESS OR IMPLIED WARRANTY, BREACH OF CONTRACT, BREACH OF ANY INTELLECTUAL PROPERTY RIGHT, MISREPRESENTATION, NEGLIGENCE, STRICT LIABILITY IN TORT OR OTHERWISE. IN NO EVENT WILL THE AGGREGATE LIABILITY INCURRED IN ANY ACTION OR PROCEEDING BY IDERA OR ITS AUTHORIZED REPRESENTATIVE EXCEED ONE HUNDRED DOLLARS. CONFIDENTIALITY - Customer acknowledges that the Products incorporate confidential and proprietary information developed or acquired by or licensed to Idera and that all results of testing of the Products, whether performed by Customer or another third party, are confidential. In no event will Customer publish or disclose the results of any testing or performance specifications of the Product without Idera’s express prior written consent. Each party shall take all reasonable precautions necessary to safeguard the confidentiality of all Confidential Information disclosed by the other party, including those precautions (i) taken by the disclosing party to protect its own Confidential Information and (ii) which the disclosing party or its authorized representative may reasonably request from time to time. Neither party shall allow the removal or defacement of any confidentiality or proprietary notice placed on the Confidential Information disclosed by the disclosing party. The placement of copyright notices on Confidential Information shall not constitute publication or otherwise impair their confidential nature of such information. If an unauthorized use or disclosure of the disclosing party’s Confidential Information occurs within the recipient party’s enterprise, the recipient party will immediately notify the disclosing party or its authorized representative and take, at recipient party’s expense, all steps which may be available to recover such Confidential Information and to prevent its subsequent unauthorized use or dissemination. TERMINATION - This Agreement and all licenses granted hereunder shall commence upon the Effective date and terminate immediately upon the earliest of (i) the date upon which Customer violates or breaches any term or condition of this Agreement and (ii) the date upon which either party notifies the other party of its termination of this Agreement (the “Term”). This Agreement will terminate automatically if Customer becomes insolvent, goes or is put into receivership or liquidation, makes an arrangement for the benefit of his creditors or enters into bankruptcy, suspension of payments, moratorium, reorganization or any other proceeding that relates to insolvency or protection of creditors’ rights or takes or suffers any similar action in consequence of debt. Upon the termination of this Agreement for any reason, all rights granted to Customer hereunder will cease, and Customer will promptly purge the Licensed Software from all of Customer’s computer systems, storage media and other files and destroy the Licensed Material and all copies thereof. U.S. EXPORT RESTRICTIONS - Customer acknowledges that the Licensed Materials and all related technical information, documents and materials are subject to export controls under the U.S. Export Administration Regulations. Customer covenants and agrees to comply with all import and export control regulations of the United States with respect to the Licensed Material. Customer acknowledges that it may not re-export or divert the Licensed Material or any related technical information, document or material, or direct derivatives thereof, to any country set forth on the U.S. Department of Commerce’s list of T-5 countries (currently, Cuba, Iran, North Korea, Sudan and Syria), including any future changes to the government’s list of T-5 countries. EQUITABLE RELIEF - The parties recognize that Sections 3 and 5 are necessary for the protection of the business and goodwill of the parties and are considered by the parties to be reasonable for such purpose. The parties agree that any breach of such Sections would cause the other party substantial and irreparable damage and therefore, in the event of any such breach, in addition to other remedies which may be available, the non-breaching party shall have the right to seek specific performance and other injunctive and equitable relief in a court of law. ENFORCEABILITY - If for any reason a court of competent jurisdiction finds any provision of this Agreement, or portion thereof, to be unenforceable, void, invalid or illegal, that provision shall be enforced to the maximum extent permissible so as to effect the intent of the parties, and the remainder of this Agreement shall continue in full force and effect. ENTIRE AGREEMENT - Customer acknowledges that it has read this Agreement, understands it and agrees to be bound by its terms. Customer and Idera further agree that this Agreement is the complete and exclusive statement of the agreement between Customer and Idera and supersedes all proposals, oral or written, and all other communications between the parties relating to the subject matter of this Agreement. This Agreement may not be amended, modified, supplemented or altered except by a written agreement that is signed by both parties. MISCELLANEOUS - Customer may not assign, delegate or otherwise transfer this Agreement or any of its rights or obligations hereunder to any other person or entity without Idera’s prior written consent. This Agreement shall be binding upon the parties hereto and shall inure to the benefit of the parties hereto and their respective permitted successors and assigns. The waiver of compliance with or breach of any term or condition of this Agreement or the failure of a party to exercise any right under this Agreement shall in no event constitute a waiver as to any other failure to comply or breach, whether similar or dissimilar in nature, or prevent the exercise of any right under this Agreement. THIS AGREEMENT WILL BE GOVERNED BY AND INTERPRETED IN ACCORDANCE WITH THE LAWS OF THE STATE OF TEXAS WITHOUT GIVING EFFECT TO ANY CHOICE OF LAW RULES. IDERA AND CUSTOMER HEREBY AGREE ON BEHALF OF THEMSELVES THAT THE SOLE AND EXCLUSIVE JURISDICTION AND VENUE FOR ANY LITIGATION ARISING FROM OR RELATING TO THIS AGREEMENT OR THE SUBJECT MATTER HEREOF SHALL BE IN AN APPROPRIATE FEDERAL OR STATE COURT IN THE STATE OF TEXAS LOCATED IN HARRIS COUNTY. This Agreement is not intended to be nor shall it be construed as a joint venture, association, partnership or other form of business organization or agency relationship. Headings used in this Agreement are for reference purposes only and shall not be used to modify the meaning of the terms and conditions of this Agreement. In consideration of the mutual covenants contained herein, including the rights and licenses granted to Customer herein, the parties hereto do hereby agree that for a period of two years following Customer’s most recent purchase of any licenses or services, including Maintenance Service, from Idera or its authorized representative, Customer shall not solicit, induce, hire, engage, or attempt to hire or engage any employee of Idera, or in any other way interfere with Idera’s contractual or employment relations with any of its employees, nor will Customer hire or engage or attempt to hire or engage any individual who was an employee of Idera at any time during such two-year period.'