Function to count set bits in a signed integer

This function counts the number of 1's in the binary representation of an integer.

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.

Monitor SQL Server and Service

To monitor SQL service and the host server is up and running, if down send e-mail to DBA

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