dbatools
Install-SqlServer
Our great sponsors
dbatools | Install-SqlServer | |
---|---|---|
5 | 1 | |
2,311 | 19 | |
0.9% | - | |
9.2 | 3.6 | |
13 days ago | 20 days ago | |
PowerShell | PowerShell | |
MIT License | GNU General Public License v3.0 only |
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
-
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.
Install-SqlServer
-
Bash_unit – bash unit testing framework
We have tones of PowerShell and it works like a charm, although we have some experienced posh devs
We also test REST backend in PowerShell using Pester.
PowerShell is preferred in this house because
a) you can run it on any Windows OS on the spot and modify it in ad hoc manner, you can even debug it with breakpoints etc easily Also our Linux machines have it.
b) its powerful, you can do anything in it with few lines of code (one case: we did 10 million SOAP requests per day for entire country)
c) many Windows toolsets use it like SqlServer, IIS etc. which makes management way easier (for example we use [1] to install sql server on all dev/prod machines)
d) we find it way easier to keep CI/CD vars in PowerShell hashtables then in yaml, so our yaml fiels are one liners and everything works locally.
---
What are some alternatives?
ansible.windows - Windows core collection for Ansible
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.
aws-tools-for-powershell - The AWS Tools for PowerShell lets developers and administrators manage their AWS services from the PowerShell scripting environment.
SqlServerDsc - This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
vscode-powershell - Provides PowerShell language and debugging support for Visual Studio Code
PowerShellForGitHub - Microsoft PowerShell wrapper for GitHub API
PSWritePDF - PowerShell Module to create, edit, split, merge PDF files on Windows / Linux and MacOS
community.windows - Windows community collection for Ansible
PSKoans - A simple, fun, and interactive way to learn the PowerShell language through Pester unit testing.
EditorSyntax - Syntax highlighting files for editors (VSCode, Atom, SublimeText, TextMate, etc) and GitHub!
au-packages - Chocolatey packages by majkinetor
sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database