Hey DBAs! Powershell is your friend!

In the last few months I supported several clients to upgrade their “old” SQL Server instances to the last version. I really like the side by side approach for several reasons, top two are the simple rollback procedure and the chance to clean some unsued objects like old logins, unused jobs. I know that DBAs…

0

SQL Server Updates behavior

Recently a client asked me: “We want to place all the fields of the table in the SET clause of an UPDATE, no matter if the values are changed or not. How does it impact the I/O? Does SQL Server update every field, even if the old value matches the new one? What about indexes?”…

0

How to Disable Always Encrypted Feature in SQL Server 2016.

Hello, my name is Stefano Altamura and I’m an Italian PFE dedicated to SQL Server and Data Insights. In my first post I want to talk about an approach that I often use to better understand how new features works. A wonderful new feature in SQL Server 2016 is Always Encrypted. You can find lots…

0