AdventureWorks2016CTP3 - JSON Sample scripts

Geting the JSON Sample Scripts to run

Find Text in All Databases

Search all databases for a particular string.

Query details about objects allocated in TEMPDB.

TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.

Powershell Script to find a SQL\Windows login in SQL Server

This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server

TDE Decryption Timer Script

Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.

Generic, parameterised, create DB script

A script to be used as part of development deployments where new databases are required, so as to provide standardisation.

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