In this blog, we’re going to look at the options we have for server level security. In SQL Server we can add security on many different levels.
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations’ data infrastructure. As data has become increasingly valuable, the security of this infrastructure is more important than ever.
Often when talking to people who are looking for a career path in the data world I feel like there are a lot of misconceptions about being a DBA and they don’t know what we do.
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to a fact table. We show you how to easily recreate this!
Sometimes you want to use JSON data in Power BI. And sometimes Power BI doesn’t exactly do what you want it to do with the information. This blog will explain how to easily make your JSON data readable with Power BI Desktop.
Who has not created monitoring reports or beautiful dashboards in Power BI? Would it not be great to show off your work on the big screen in the office? But one static page is not very useful, and you do not want to manually refresh. So we found a solution.