EugeneChiang.com

Bring Offline and Online Database

Note: Bring database OFFLINE / ONLINE should be a fast process, even for a large database. Users must be disconnected from database before setting the database to offline. Else, use ROLLBACK IMMEDIATE clause. If you run into problem with bring the database back ONLINE, try restarting SQL Server service. If part of Availability Group, need... » read more

Check Progress of Current Running Request

Examples:

Cannot drop database “xxxxx” because it is currently in use.

Problem: Solution: When you have tried everything to drop the database but nothing works. Stop the SQL Server service. Manually remove the data files from drive. Restart the SQL Server service. Delete database.

List of SQL Jobs

TeamCity

TeamCity is a build management and continuous integration server from JetBrains. It was first released on October 2, 2006 and is commercial software and licensed under a proprietary license: a freemium license for up to 100 build configurations and three free Build Agent licenses are available.  https://www.jetbrains.com/teamcity/

Custom CommandExecute Script

https://ola.hallengren.com

Custom Index Optimizer Script

Source: https://ola.hallengren.com User Database IndexOptimize Script

Custom Database Integrity Check Script

Source: https://ola.hallengren.com Database Integrity Check: System Database Database Integrity Check: User Database DatabaseIntegrityCheck Script

Custom Backup Database with Script

Source: https://ola.hallengren.com Backup: SYSTEM FULL Backup: USER FULL Backup: USER DIFF Backup: USER LOG [dbo].[DatabaseBackup] Script

Add Table Logging to Stored Procedure

Create table to store log data. Create stored procedure to insert data into log table. Add logging to user stored procedure. dbo.tbMyLog.sql dbo.uspInsertMyLog.sql Logging in uspMySP01 Remove log entries older than 1 month