Filip HolubDec 10, 20193 minDowngrade 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...
Filip HolubMar 7, 20191 minHow 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
Filip HolubJan 13, 20192 minResumable Online Index Create in SQL Server 2019The Microsoft introduced with SQL Server 2019 CTP 2.0 new option in regards to Index Maintenance - Resumable Online Index Create. It allows
Filip HolubJan 10, 20191 minSQL 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
Filip HolubJan 8, 20191 minHow 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