Filip Holub
- Dec 10, 2019
- 3 min
Downgrade SQL Server edition by In-Place method!
As SQL Server Administrator you will probably sometimes solve downgrade edition of SQL Server, for example from Enterprise/Standard...
7,7060
Filip Holub
- Mar 7, 2019
- 1 min
How to find out estimated saving space for Data Compression for all tables in the database?
As I wrote, I need to find out for all user tables estimates size for the both types compression, ROW and PAGE. Therefore, I wrote this pret
2940
Filip Holub
- Jan 13, 2019
- 2 min
Resumable Online Index Create in SQL Server 2019
The Microsoft introduced with SQL Server 2019 CTP 2.0 new option in regards to Index Maintenance - Resumable Online Index Create. It allows
2220
Filip Holub
- Jan 10, 2019
- 1 min
SQL Server 2019: New features!
The latest SQL Server 2019 version is SQL Server 2019 (CTP) 2.2 which Microsoft announce at 10.12.2018. What is actually new in SQL Server 2
2090
Filip Holub
- Jan 8, 2019
- 1 min
How to configure Dynamic Data Masking?
DDM doesn't support following:
Always Encrypted columns
Filestream data
Computed columns
You cannot FULLTEXT index where DDM is implemen
1430
Filip Holub
- Jan 6, 2019
- 2 min
How to implement Always Encrypted?
Deterministic - This type always generates the same ciphertext for any plaintext value. This method supports grouping, indexing, joins point
3020