joyworkstoo Goto Github PK

-dba_scripts-

diagmanager

Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems. This is the same tool Microsoft SQL Server support engineers use to for data collection to troubleshoot customer's performance problems.

glennberry_dmv_queries

SQL Server Diagnostic Information Queries from Glenn Berry

powershell

MISC PS

powershell-beautifier

A whitespace reformatter and code cleaner for Windows PowerShell and PowerShell Core

sp_help_permissions

sql

sql-dba-scripts

sql-scripts-for-admins

Useful TSQL scripts for DBA's repeatable and diagnostics tasks.

sql-server-maintenance-solution

SQL Server Maintenance Solution

sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge

sqlcmsdailychecks

A simple framework for handling morning checks in large environments using CMS, TSQL, PS, and HTML

sqlnexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

sqlserver-databaseconfig

Crawls over a CMS for 'Production' servers for their database inventory, config, etc

sqlserver-diag-queries

Some diagnostic queries that I use to get information on the host that run my target SQL Server services.

sqlserver-serverconfig

Crawls over a CMS for 'Production' servers for their SQL instance(s) configurations, etc

ssasdiag

sspi-client

tsql-scripts

:frog: Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.