PowerShell Scripts for SQL Server 6.0

许可: 免费 ‎文件大小: 263.17 KB
‎用户评分: 5.0/5 - ‎1 ‎评分

147 个免费的 SQL Server PowerShell 脚本:89 个用于管理 SQL Server 对象的示例脚本。初始化 PowerShell SQLPS 模块并处理数据库。用于分析、集成和报告服务的脚本。SQL Server 2016 的实验支持。用于探索内存中数据库和查询存储功能的新脚本。 数据库引擎:连接到服务器实例、管理数据库和发布脚本。使用策略和 SQL Server 日志。维护安全性和备份。创建和管理 SQL Server 作业。获取扩展的事件信息。 分析服务:连接到分析服务实例。获取连接信息。获取数据库列表。备份数据库并删除旧备份。还原数据库。 集成服务:启动和停止服务。获取包信息。预配目录。发布项目。修改目录设置。 报告服务:启动或停止服务。获取实例信息。备份和还原加密密钥。获取配置信息。获取事件日志信息。 内存中数据库:获得总体利用率。获取磁盘上的大小。按表获取详细的利用率。获取检查点大小。 查询计划:设置查询计划所需的状态。设置查询计划数据保留最大大小。获取查询计划信息。获取查询存储状态。 互联网安全 (CIS) 基准中心:表面积减少、身份验证和授权、密码策略、审核和日志记录、应用程序开发以及启动和停止 SQL Server 浏览器服务。 Azure SQL 数据库:初始化 PowerShell 模块、设置缩放级别、设置审核和威胁检测、获取数据库属性、获取警报定义、设置和获取警报规则、获取查询结果和获取查询指标数据。

版本历史记录

  • 版本 6.0 发布于 2018-07-12
    这是一个主要的产品更新

软件信息

终端用户许可协议

'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 gener­ally available for the License Software. “Licensed Material” means the Licensed Software and the Licensed Documentation. “Licensed Software” means the machine-readable object code ver­sion of (i) the software specified on each Purchase Order, whether embed­ded 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 repro­duce 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 CON­SEQUENTIAL, INDIRECT, SPECIAL, PUNITIVE, EXEMPLARY OR INCI­DENTAL DAMAGES, WHETHER FORE­SEE­ABLE OR UNFORE­SEEABLE, 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, INTER­RUPTION IN USE OR AVAIL­­ABILITY OF DATA, STOP­PAGE OF OTHER WORK OR IMPAIRMENT OF OTHER ASSETS), ARISING OUT OF BREACH OF EXPRESS OR IMPLIED WAR­RANTY, BREACH OF CONTRACT, BREACH OF ANY INTELLECTUAL PROPERTY RIGHT, MISREP­RESENTATION, NEG­LIGENCE, 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 incor­porate confidential and proprie­tary 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 confiden­tiality of all Confidential Information disclosed by the other party, including those precautions (i) taken by the disclosing party to protect its own Confidential Infor­ma­­tion and (ii) which the disclosing party or its authorized representative may reasonably request from time to time. Neither party shall allow the removal or deface­ment of any confidentiality or proprietary notice placed on the Confidential Information disclosed by the disclosing party. The placement of copy­right notices on Confidential Information shall not consti­tute 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 immed­iately 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 mater­ial, 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 AGREE­MENT WILL BE GOVERNED BY AND INTER­PRETED 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.'