SQLDBATools

KO | EN

gitlite — search

#javascript #typescript #go #docker #nodejs #macos #java #windows #awesome #kubernetes #awesome-list #security #mcp #open-source

(★ 17)

Powershell Module containing cmdlets for carrying out SQL DBA activities.

SQLDBATools 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# SQLDBATools
Powershell Module containing cmdlets for carrying out SQL DBA activities.

**Functionality** covered includes finding our server properties, disk utilization, discover sql instance in network, find license keys, setup mail profile, setup dba operator, get backup history, audit user/database permissions, maintain inventory, cleanup orphan database files from disk, find resouce consuming queries on server, space consumers, estimate space to add into disk/database files, setup maintenance jobs, perform basic basic server optimization settings etc.

This module also has built-in capability to setup **Monitoring & Alerting** system using PowerShell & SqlServer. The alerting system is designed to *automatically clear alerts* when no longer active, *send email notifications*, *suppress* alert is required, display *alert history* on Grafana. This available alerts include Disk Space, Blocking, Job Failure, High CPU, Memory Issue, and many more.

## How to Install
One way to work with this module is to simply download this github repository at zip file, extract downloaded zip file, and extract it to folder named 'SQLDBATools'. Finally copy/paste it on one of the module folders returned by variable $PSGetPath.

It can also be installed easily from PSGallery using below command -

```
Install-Module -Name SQLDBATools
# Update-Module -Name SQLDBATools
```

## Donation
If this project help you reduce time to develop, you can give me a cup of coffee :)

PayPal |   | UPI
------ | - | -----------
[![paypal](https://www.paypalobjects.com/en_US/i/btn/btn_donateCC_LG.gif)](https://paypal.me/imajaydwivedi?country.x=IN&locale.x=en_GB) | | [![upi](https://www.vectorlogo.zone/logos/upi/upi-ar21.svg)](https://github.com/imajaydwivedi/Images/raw/master/Miscellaneous/UPI-PhonePe-Main.jpeg)

## Help or Documentation
Want to know in details about functionalitires supported by this module, kindly check below documentation -

<b> [Documentation on [SQLDBATools]](https://imajaydwivedi.github.io/SQLDBATools/)</b>

To learn on how to use this script, please watch below YouTube video:-

[![Watch this video](https://ajaydwivedi.com/wp-content/uploads/2021/06/image-3-1024x379.png)](https://youtu.be/vF-EsyHnFRk)

SQLDBATools

SQLDBATools 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

SQLDBATools

SQLDBATools 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README