You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.
SQL SERVER – Information Related to DATETIME and DATETIME2
A reader comment explains the precision issue between DATETIME and DATETIME2: values lose precision when converted between types. Here is the workaround.
SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use
Error 3702: cannot drop database because it is currently in use. Set it to SINGLE_USER WITH ROLLBACK IMMEDIATE, then drop it. Best kept for demo servers.
SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database
Reducing CXPACKET wait stats on a high transactional database: what CXPACKET means, and when lowering the degree of parallelism really helps.
SQL SERVER – Get All the Information of Database using sys.databases
A handy script from Matteo that uses sys.databases to show plenty of database information, like status, data and log file counts and their sizes in MB.
SQL SERVER – Get Database Backup History for a Single Database
A reader script by aasim abdullah to get database backup history for a single database: backup file, size, time taken, LSNs and the type of each backup.
SQL SERVER – Recycle Error Log – Create New Log file without Server Restart
A client’s DBA restarted the server just to start a fresh Error Log. There is no need: you can recycle the log and create a new file without a restart.