Pigeon SQL

10/12/2019

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 to Developer edition. There

21/03/2019

How to Configure Windows Authentication for SQL Server on Linux?
https://www.mssqlonlinux.com/blog/how-to-configure-windows-authentication-for-sql-server-on-linux

07/03/2019

How to find out estimated saving space for Data Compression for all tables in the database?

This website is my blog and knowledge base about MSSQL. You can find my experience with Databases based on Microsoft. FilipHolub

17/02/2019

Passed this month! :)

Passing Exam 764: Administering a Microsoft SQL Database Infrastructure validates a candidate’s skills to perform installation, maintenance, and configuration tasks. Other demonstrated skills include setting up database systems, making sure those systems operate efficiently, and regularly storing,...

14/01/2019

Resumable Online Index Create in SQL Server 2019

11/01/2019

SQL Server 2019: New features!

The latest SQL Server 2019 version is SQL Server 2019 (CTP) 2.2 which Microsoft announce at 10.12

09/01/2019

How to Configure Dynamic Data Masking?

Microsoft introduced with SQL Server 2016 new feature - Dynamic Data Masking. This feature can be useful if you don't want someone to see sensitive data.

07/01/2019

How to implement Always Encrypted?

With SQL Server 2016 was released a new feature called Always Encrypted.Allow encrypt both data in rest and data in flight,we can set encryption on column level

19/12/2018

How to identify memory bottlenecks in SQL Server with DMV?

Most of us already solved some problems in regards to performance of SQL Server. Most often we can find bottlenecks for CPU, Memory and Storage. Today I want to