Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

  •        938

SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

http://sqlspade.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

SQL Server DB & SSIS Powershell Deployment


A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

DbDiff: Database Diff and Database Scripting


Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing

Snippets Generator for SQL Server 2012


Snippets Generator allows the user to easily create T-SQL snippets for SQL Server 2012! You can create a snippet from scratch or by using snippet templates.

dbatools - PowerShell module to help SQL Server Pros be more productive


PowerShell Core (aka PowerShell 6+) went GA (generally available) and supported in January of 2018. Please be aware at this time we do not support this version of PowerShell. It is on the roadmap but at this time there is no estimated time we will be supporting it. dbatools is sort of like a command-line SQL Server Management Studio. The project initially started out as Start-SqlMigration.ps1, but has now grown into a collection of over 400 commands that help automate SQL Server tasks and encourage best practices.

SQL Server Management Studio Add-in for Denali\SQL2012 (SSMS Addin)


Example/Framework of a SQL Server Management Studio Add-in (SSMS Addin) for Denali\2012. The aim of this project is to prove an example of an Add-in. The example add-in shows; * How to take the contents of the query window and format it. * How to use the context menu ...


SQL Server PowerShell Extensions


The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.

SQL Power Doc


SQL Power Doc is a collection of Windows PowerShell scripts & modules that discover, document, & diagnose SQL Server instances & their underlying Windows OS.

PowerShell SQL Developer Tools


Series of PowerShell Functions to assist in the scripting and rebuilding of SQL Server objects through automation.

An Un-sql SQL Database Installer


D.E.M.O.N SQL Database Installer is an Un-SQL(SQL means boring here) Database server installer for many types of Database :MySQL, FireBird, SQLite and others.

RSBuild SQL Server Reporting Service Deployment Tool


RSBuild currently supports two types of tasks: executing SQL Server scripts and publishing SQL Server Reporting Serivce reports and shared data sources. It uses ADO.NET to execute database scripts in batch. Database script can be specified in the configuration file with speci...

PowerUpSQL - PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server


PowerUpSQL includes functions that support SQL Server discovery, weak configuration auditing, privilege escalation on scale, and post exploitation actions such as OS command execution. It is intended to be used during internal penetration tests and red team engagements. However, PowerUpSQL also includes many functions that can be used by administrators to quickly inventory the SQL Servers in their ADS domain and perform common threat hunting tasks related to SQL Server.

SQLDeploy.Net


SQLDeploy.Net is a utility to deploy [run] a set of SQL Scripts on SQL Server. The utility can be integrated with any deployment manager like Marimba , Hudson etc to automate database deployment. The project is developed on .Net Framework 4.0 but it is equally backward comp...

SQL Server Central Management System


The SQLCMS uses and extends a series of features in SQL Server 2008 to manage and monitor SQL Server Instances, from versions 2000-2008. It is a series of modular components that also allows integration with other solutions such as MOM or OpenView installations.

SQL Server FineBuild


FineBuild provides 1-click install and best-practice configuration of SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005

Powershell4SQL


Module designed to simplify working with SQL Server from Powershell

powerTrace - a PowerShell snapin for SQL Server Trace files


This is a snapin for Microsoft PowerShell which allows for the loading and exploration of SQL Trace files using PowerShell. This provider has been initially designed to work with trace files from SQL Server Analysis Services.

GetMsSqlDump - a mysqldump-like tool for MSSQL


GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.

sql-docs - Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc


This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments. You've found the GitHub repository that houses the source for the SQL Server technical documentation published on https://docs.microsoft.com.

SQL Installer.NET


SQL Installer.NET is a toolset which assists in the development, deployment, and maintenance of applications which interface with a relational database management system (RDBMS).