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...
4,8310
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
2210
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
1660
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
1770
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
1220
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
2140
Filip Holub
- Dec 19, 2018
- 2 min
How to identify memory bottlenecks in SQL Server with DMV?
Page Life Expectancy(PLE) - This is number of seconds a when pages will stay in the buffer pool without references. In general, the minimal
1,2430
Filip Holub
- Dec 17, 2018
- 1 min
How to increase data and log files by 25% of their total size for all databases?
So, I wrote little script which based on table sys.database_files where we can find out a couple of informations for example size and name o
970
