Category

SQL Server

5 Lessons Learned with SQL Always Encrypted

By All Posts, Application Development, SQL Server
Microsoft introduced Always Encrypted with SQL Server 2016 as an approach to encrypting data at rest and in transit to protect personally identifiable information and financial transactions. Always Encrypted works by encrypting the data on the client side and hiding the encryption keys from the server. Without explicit permission and configuration, even database administrators cannot read the information stored in an encrypted column. This is obviously a significant step forward in security and allows users...
Read More

Scaling Azure SQL Databases Up and Down

By All Posts, Azure, Power BI & SQL, SQL Server, Tutorials No Comments
Scaling Azure SQL databases up and down   I've recently been working on a project where we push data from an on-premise database to a set of Azure SQL databases daily, and use that Azure SQL database as the source for a Power BI dataset. The dataset gets refreshed once a day. Our Azure SQL data marts are pretty small - all but one of them are under 2 GB, and the largest one is...
Read More
Let‘s Talk.
  • Let's Talk

  • This field is for validation purposes and should be left unchanged.