Category

SQL Server

What is Data Engineering?

By All Posts, Azure, Business Intelligence, Power BI & SQL, SQL Server
When you look at a dashboard or report in Power BI, you are seeing the tip of the iceberg; the data you see has likely taken many steps from its source on its way to Power BI. Data engineering is the work that brings data from one or more sources and shapes it, validates it, cleans it, correlates it, and (often) stores it, and it’s a lot of what we do at Imaginet. Power BI...
Read More

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.