marcoencina Goto Github PK

alwaysencryptedsample

Sample ASP.NET MVC Application for demonstrating Microsoft SQL Server Always Encrypted Functionality

article-scripts

Companion scripts for solution articles

bigsqlrunner

A small tool that can run HUGE Microsoft SQL Server script files (of several Gigabytes)

dba-scripts

Scripts that I use to manage SQL Server instances

dbachecklist

DBA Checklist Report which can be run to generate an email showing health of SQL Instance.

dbachecks

SQL Server Environmental Validation

dbachecks-expanded

Some scripts and reports to expand your dbachecks experience

dbareports

PowerShell Module to gather, store and report on data about your estate https://dbareports.io

dbascripts

Various scripts used for DBA functions

dbatools

PowerShell module to help SQL Server Pros be more productive

dbatools-scripts

Holds a number of scripts for use with dbatools

dbatools-templates

Templates for dbatools commands

dbatools-traininglab

a nice lil tutorial to help with useful tutorials

dbatoolsmigrate2022

Repo for dbatools migration presentation

dbops

dbops - Powershell module that provides continuous database deployments on any scale

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.

docs

The documentation for dbatools module.

functions

Contains useful functions that I use

generatepermissions

knowledge-base

pdf,txt,djvu, various useful books

olahallengrenrestorescript

Standby restore script output for Ola Hallengren's Maintenance Solution

openquerystore

OpenQueryStore

script_sqlserver_alerts

This is a big project to share scripts to monitor SQL Server if you don't have a tool to do that

sp15docgen

SPDocGen - SharePoint 2013 Documentation Generator

sql-docs

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc.

sql-server-first-responder-kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

sql-server-maintenance-solution

SQL Server Maintenance Solution

sql-server-migration

"SQL Server Migration" consolidates the most important migration tools from the dbatools (from Chrissy LeMaire) into one simple and nice menu. This is useful when you're looking to migrate entire instances from Server A to Server B, but it is less flexible than using the underlying functions.

sql-server-tools

Scripts de SQL server que podem salvar sua vida

sqlcollaborative.github.io

Resources for the SQL Collaborative