Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a quick description.
SQL Server security on server level
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.
Microsoft SQL Server history
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.
DBA is not that scary
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.
How do you link an SCD Type 2 table in Power Query?
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!
How to easily parse JSON in Power BI Desktop
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.
Power BI reports as monitoring tool
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.
