JoyWorksToo

-DBA_Scripts-

auditing-sqlserver-centralization-scripts

AuditViaLinked

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.

JoyWorksToo/-DBA_Scripts-

JoyWorksToo/auditing-sqlserver-centralization-scripts

AuditViaLinked

JoyWorksToo/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.

JoyWorksToo/GlennBerry_DMV_Queries

SQL Server Diagnostic Information Queries from Glenn Berry

JoyWorksToo/PowerShell

MISC PS

JoyWorksToo/PowerShell-Beautifier

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

JoyWorksToo/sp_help_permissions

JoyWorksToo/SQL

JoyWorksToo/SQL-DBA-SCRIPTS

JoyWorksToo/sql-scripts-for-admins

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

JoyWorksToo/sql-server-maintenance-solution

SQL Server Maintenance Solution

JoyWorksToo/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

JoyWorksToo/SQL-Server-Scripts

My SQL Server Scripts

JoyWorksToo/SQLcmsDailyChecks

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

JoyWorksToo/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.

JoyWorksToo/SQLSecurity

ScriptKittyPerms

JoyWorksToo/SqlServer-DatabaseConfig

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

JoyWorksToo/sqlserver-diag-queries

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

JoyWorksToo/SqlServer-ServerConfig

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

JoyWorksToo/SSASDiag

JoyWorksToo/sspi-client

JoyWorksToo/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.