Filip Holub
Feb 1, 20171 min read
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:
4160
Filip Holub
Jan 30, 20171 min read
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:
6290
Filip Holub
Jan 27, 20171 min read
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, 20171 min read
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, 20171 min read
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, 20171 min read
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, 20171 min read
DBCC CheckDB
One of best practices from Microsoft for SQL Server is a database integrity check. Command DBCC CHECKDB means "Database Consistency Che
720
Filip Holub
Jan 16, 20171 min read
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
