dbatools
SqlServerDsc
Our great sponsors
dbatools | SqlServerDsc | |
---|---|---|
5 | 2 | |
2,329 | 351 | |
1.1% | 0.0% | |
9.2 | 7.6 | |
11 days ago | about 2 months ago | |
PowerShell | PowerShell | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dbatools
- Python vs Powershell on *nix Systems
- Große SQL Datenbank umziehen
-
Github pipelines/actions for .net build/deployment workflow?
dbatools (for deploying database changes)
- Looking for public powershell projects to learn best practices and as a reference
-
VS Code Syntax Highlighting
It's very rare I open files that big, but just for fun I took the 1k lines here: https://github.com/sqlcollaborative/dbatools/blob/development/dbatools.psm1 copied and pasted the code 37 times into a .ps1 file and opened it in ISE. ISE opened and highlighted it in like 1-2 seconds so the PS parser is clearly able to parse things quick enough for it to not matter.
SqlServerDsc
-
Next Step in Career
For it was : https://github.com/dsccommunity/SqlServerDsc
-
Assigning SQL Server Roles via Group Policy?
I think you should be able to accomplish with DSC, and the SqlServerDSC module. It's a bit involved getting everything set up and configured, but we're currently using DSC with Azure automation to do configurations of MSSQL VM's in Azure after deploying resources with Terraform. But, DSC works on-prem, too.
What are some alternatives?
ansible.windows - Windows core collection for Ansible
WebAdministrationDsc - This module contains DSC resources for deploying and configuring web servers and related components.
PSWriteHTML - PSWriteHTML is PowerShell Module to generate beautiful HTML reports, pages, emails without any knowledge of HTML, CSS or JavaScript. To get started basics PowerShell knowledge is required.
SRDSC - Script Runner DSC Module Extension!
aws-tools-for-powershell - The AWS Tools for PowerShell lets developers and administrators manage their AWS services from the PowerShell scripting environment.
LabBuilder - PowerShell Module for building a Hyper-V Lab environment from a simple XML configuration file.
vscode-powershell - Provides PowerShell language and debugging support for Visual Studio Code
ActiveDirectoryDsc - This module contains DSC resources for deployment and configuration of Active Directory Domain Services.
PowerShellForGitHub - Microsoft PowerShell wrapper for GitHub API
PSWritePDF - PowerShell Module to create, edit, split, merge PDF files on Windows / Linux and MacOS
Install-SqlServer - Powershell script to install MS SQL Server unattended
community.windows - Windows community collection for Ansible