Powershell4SQL

  •        46

Module designed to simplify working with SQL Server from Powershell

http://powershell4sql.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

ReportingServicesTools - Reporting Services Powershell Tools


This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. In order to use the scripts included in this project successfully, please download/clone the entire project as there are dependencies between the scripts.All of our scripts were written with the assumption that you will be executing them against SQL Server 2016 Reporting Services default instance (i.e. mssqlserver). However, we understand this may not be the case for you. So for each script, you will see that we have provided a way for you to specify the name and/or version of your SQL Server Reporting Services instance name. Sometimes the version of your SQL Server instance is also required. If you do not provide one, we will assume that you want to execute this against the default instance.

PowerShell Data Processing Extension for SQL Server Reporting Services


Plug this into SQL Server Reporting Services to create reporting based on your PowerShell scripts. The PowerShell DPE transforms your PowerShell output into a DataSet that can be consumed by SSRS.

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.

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 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.



PowerShell-ETL-SQL-Server


PowerShell scripts for more object-oriented ETL than SSIS & remote SQL Server job initiation

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.

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server


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.

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.

Scripts - Repository to store my scripts designed to be reusable in nature (powershell, sql etc….)


Repository to store my scripts designed to be reusable in nature (powershell, sql etc….)

poshsql - Powershell scripts for SQL DBA


Powershell scripts for SQL DBA

Epmf - PowerShell: Enterprise Policy Based Framework for SQL Server


PowerShell: Enterprise Policy Based Framework for SQL Server

sqlBackupRestorePS - My simple MS Sql Server backup and restore Powershell script


My simple MS Sql Server backup and restore Powershell script

Powershell-pasen


My bag of powershell script for miscellaneous purposes. Like backing up all sql server database that starts with eCM or run all sql script recursively in a directory tree.

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.

sqlscripts - Various scripts for Oracle and SQL Server development


Various scripts for Oracle and SQL Server development

SQLSalt - SQL Server DBA Code and Helpful Scripts


SQL Server DBA Code and Helpful Scripts

iSQLPS


iSQLPS stands for Inventory MS SQL Servers with PowerShell. iSQLPS makes it easier for DBAs to inventory and monitor MS SQL Server environments. You will have all server information in one place. It's developed in PowerShell.

PowerRepl


A Powershell script to sync access database table data with SQL Server database tables.

azure-sdk-tools-samples - Samples for Microsoft Azure PowerShell


SharePoint 2013 Automated Deployment Master Scripts allow you to quickly provision a small SharePoint farm for development and testing all the way up to a fully HA SharePoint farm.Scripts are available that will automatically provision Active Directory, SQL Server and SharePoint or for more advanced scenarios you can configure and execute each individual tier.