Filip Holub
Dec 10, 20193 min read
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...
9,4690
Filip Holub
Mar 7, 20191 min read
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
3220
Filip Holub
Jan 13, 20192 min read
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
2580
Filip Holub
Jan 10, 20191 min read
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
2070
Filip Holub
Jan 8, 20191 min read
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
1510
Filip Holub
Jan 6, 20192 min read
How to implement Always Encrypted?
Deterministic - This type always generates the same ciphertext for any plaintext value. This method supports grouping, indexing, joins point
3230