Backup databases in an Availability Group

Use this script to backup databases based on their role in an availability group

Powershell Script for regular DBA activities

This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db

It takes care of all the possible failures during these operations, while done manually.

PoorDBA Tools - 1: DB Log Space used

Evaluate and notify if database log file usage exceeds 15%.

Extracting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern

View Autogrowth on a daily basis

Sends an HTML formatted Email with autogrowth Information for the last 24 hours.

Read SQL Server Logs with TSQL

This is a small script designed to read the Contents of the SQL Server log based on None or more criteria.

T-SQL implementation of FizzBuzz

A T-SQL implementation of FizzBuzz consisting of a single SELECT statement.

Query Performance comparison between instances

Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!

Check constraint to prevent insertion of invalid characters.

A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range.

Dynamic sql for convert SQL statement to txt/csv file

Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.