Wait Statistics #4 LCK_M_xx

In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type you are sure to see in your environment! LCK_M_xx waits As you can guess the LCK_M_xx waits have a relation with locking, they are generated when a query wants to place a lock on an […]

SQL Server column encryption

We use databases to store a lot of information. This can also include sensitive information we don’t want to give everyone access to. While we can use permission or views to ‘hide’ our sensitive information it will still be stored as plain text in our table. We can use column encryption to encrypt that sensitive […]