This module allows SQL Server developers, administrators and business intelligence professionals to automate database development and server administration, as well as both multidimensional and tabular cube processing. For Release Notes, expand the Package Details section on this page. For automation with SSRS & Power BI Report Server, use th... More info

Writes an object into a database table. If the table does not exist it will be created based on the properties of the object. For every property of the object a column will be created. The data type for each column will be converted from .Net data types into SQL Server data types. Not all data types are supported. Unsupported data types will be ... More info

Automation tools for production quality database deployment

The community module that enables SQL Server Pros to automate database development and server administration

Invoke-SqlCmd2

Provides extra functionality for SSRS (SQL Server Reporting Services) and Power BI Report Server. Includes the ability to deploy SSRS Reports, Datasets, and DataSources; as well as Power BI Reports. For more information about the capabilities of this module, please visit the Project Site: https://github.com/Microsoft/ReportingServicesTools/

A single lightweight powershell module with cmdlets to query/update databases with any .net provider: SQL/OLEDB/ODBC/...

Automation tools for production quality database deployment

Query any database!

SQL Server Infrastructure validation Tests to ensure that your SQL Server estate is and continues to be compliant with your requirements

Cross-platform SQL code deployment module with Continuous Deployment capabilities

Dopest dba dashboards ever

This Integration Module provides cmdlets for automating interaction with SQL Server databases without the need to write SQL and is designed to be used with Runbook Studio and Azure Automation. Take the Runbook Studio for a test drive on the Azure Marketplace (https://bit.ly/AzureRBS) or get more information and download from (https://www.kelverion.... More info

The module can parse information about updates with http://sqlserverupdates.com/. Next, it checks build number instance SQL Server in organization (mandatory parameter) and it will return updates required for installation. The script returns objects or report in html format.

SQL Server Desired State Configuration module. Modified from xSqlPs and will contain all custom resources before they are Pulled back into the main xSqlPs repository. Tweet me for questions and bug fixes @matticusau

Deploy a SQL Database DACPAC using a DAC Publish Profile Publish-DacPac allows you to deploy a SQL Server Database DACPAC to a SQL Server instance using a DAC Publish Profile. SSDT (SQL Server Data Tools) is Microsoft's tool to design (declare) the entire database model including tables, views, stored procedures, functions, schemas, etc. etc.... More info

Support for querying SQL Server, SQlite and ODBC sources.

Enable JDBC XA Transactions on SQL Server for enable JDBC XA Transactions on SQL Server

A complimentary DSC Module to add resources and functionality missing from xSqlServer. Over time I will try and move these resources into the official xSqlServer but this gives me a way of supporting these until such time.

To automate the restore of SQL Server database for testing and compliance checking