✔ SQL Server Environmental Validation
-
Updated
Sep 3, 2024 - PowerShell
Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from the Sybase SQL Server 4.x codebase and Transact-SQL dialect (t-sql), but it has forked significantly since then.
SQL Server is available in multiple versions (typically identified by release year), each of which are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2019 which was released on November 4th, 2019.
✔ SQL Server Environmental Validation
♻ Replicates SharePoint Lists
Main repository from contributions from my blog
🥄 A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server.
PowerShell to publish (deploy) SQL Database using a DACPAC and DAC Publish Profile
🦅 DISA STIG automation module for SQL Server
SQL Server Performance Health Check
Deploy SQL Server using PowerShell Desired State Configuration.
Module for interacting with Redgate command line utilities. This will simplify the work required to use Redgate's tools when writing powershell scripts and cmdlets.
Backup MSSQL Server databases by executing a Powershell script as a Scheduled Task under Windows. Features: Daily rotation, Weekly rotation, Monthly backups. Optional zipping. Logging. Mail notification.
🔵 Github Action to install tSQLt.
This PowerShell module contains two functions that are useful for exporting large amounts of data from tables, views, or queries on an (Azure) SQL Server database into CSV files compliant with the RFC 4180 standard
Docker definition for Microsoft SQL Server 2017 Developer including Full-Text Index enabled based on Windows Server Core 2022 (LTSC)
If you don't want to pay for expensive SQL comparison software...you can use this script to generate .scmp files for all of your databases and servers