Filip Holub
- Feb 1, 2017
- 1 min
How to Change All User Databases to Multi User Mode?
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:
4010
Filip Holub
- Jan 30, 2017
- 1 min
How to Change All User Databases to Single User Mode?
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:
6240
Filip Holub
- Jan 27, 2017
- 1 min
Create Or Alter in SQL Server 2016 Servcie Pack 1
Microsoft released Service Pack 1 for SQL Server 2016 in November. SP 1 is included new feature "CREATE OR ALTER" statement. This
300
Filip Holub
- Jan 24, 2017
- 1 min
How to enable TDE?
TDE is "Transparent Data Encryption", TDE provide encryption and decryption input and output files with data. TDE uses "Datab
320
Filip Holub
- Jan 22, 2017
- 1 min
How to Identify Unused Indexes?
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
450
Filip Holub
- Jan 20, 2017
- 1 min
Service Pack 1 for SQL Server 2016
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
400
Filip Holub
- Jan 17, 2017
- 1 min
DBCC CheckDB
One of best practices from Microsoft for SQL Server is a database integrity check. Command DBCC CHECKDB means "Database Consistency Che
710
Filip Holub
- Jan 16, 2017
- 1 min
How to automate DBCC CHECKDB in MS SQL 2016?
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
2850
