Pigeon's Blog

If you want to switch all databases to multi user mode, you can use my cursor script below: HERE! The result should look like this:

If you want to switch all databases to single user mode, you can use my cursor script below: HERE! The result should look like this:

Microsoft released Service Pack 1 for SQL Server 2016 in November. SP 1 is included new feature "CREATE OR ALTER" statement. This

TDE is "Transparent Data Encryption", TDE provide encryption and decryption input and output files with data. TDE uses "Datab

If you need find unused indexes you can try system viewes SYS.dm_db_index_usage_stats.Information is displayed since the last reboot instanc

In Novemeber Microsoft released Service Pack 1 (SP1) for Microsfot SQL Server 2016. In my opinion is very good a step forward for all compan

One of best practices from Microsoft for SQL Server is a database integrity check. Command DBCC CHECKDB means "Database Consistency Che

In this post I would like to show you I solved automation of DBCC CHECKDB. I had a meeting with Microdoft engineer on MS SQL and he told me