Recent Restore History

This script simply returns the most recent restore information about databases for a server.

Returns the destination database name, the device used to perform the restore and the restore date.

List schemas in a database

This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.

Dynamic Sudoku for 3X3

it is a 3X3 dynamic sudoku

Move database files to another Drive

This script either generates or execute statements to SQL data and log files from C:\ to D:\

Backup All User Databases

Backup all user databases on a SQL Server instance.

Count character matches with DATALENGTH function

https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's

Find the position of all occurrences of an expression within a string

This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.