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...
Filip Holub
Dec 10, 20193 min read
10,065
0
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
Filip Holub
Mar 7, 20191 min read
340
0
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
Filip Holub
Jan 13, 20192 min read
267
0
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
Filip Holub
Jan 10, 20191 min read
209
0
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
Filip Holub
Jan 8, 20191 min read
157
0
How to implement Always Encrypted?
Deterministic - This type always generates the same ciphertext for any plaintext value. This method supports grouping, indexing, joins point
Filip Holub
Jan 6, 20192 min read
331
0
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
Filip Holub
Dec 19, 20182 min read
2,013
0
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
Filip Holub
Dec 17, 20181 min read
145
0
