sqlserver-kit
dbatools
| sqlserver-kit | dbatools | |
|---|---|---|
| 2 | 5 | |
| 1,980 | 2,337 | |
| - | 0.9% | |
| 5.8 | 9.2 | |
| 28 days ago | 3 days ago | |
| TSQL | 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.
sqlserver-kit
-
Database Project for University - SQL Server Set-up
what i also use quite often is this nice collection of SQL Server related documents: https://github.com/ktaranov/sqlserver-kit
- SQL Server Trace Flags
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.
What are some alternatives?
SQL-Server-First-Responder-Kit - sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
ansible.windows - Windows core collection for Ansible
mssql-docker - Official Microsoft repository for SQL Server in Docker resources
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.
MachineIntelligence-TextAnalytics-TPLDataFlows - Machine Intelligence using OpenAI, Semantic Kernel, Vector Search, SQL Server
aws-tools-for-powershell - The AWS Tools for PowerShell lets developers and administrators manage their AWS services from the PowerShell scripting environment.
utility - Making the world a better place, one utility tool at a time
SqlServerDsc - This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
Sql-Server-DBA-Toolbox - A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.
vscode-powershell - Provides PowerShell language and debugging support for Visual Studio Code
naming-convention - Templates for naming convention - TSQL, JavaScript, C#, R, Python, Powershell
PowerShellForGitHub - Microsoft PowerShell wrapper for GitHub API