Create Calendar Table Using Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
2021-03-03
PowerBI
Power Query or SQL Server? Which, when and why
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
5,181 reads
Staying Current on Power BI Dashboards
Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.
2018-03-01
3,152 reads
Blogs
Modern Data Warehouse & Reverse ETL
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
Daily Coping 12 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Setting up Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data...
Forums
T logs increasing
Hi In one of our servers the t-logs of one of the database which...
A really silly question
Hello. Sometimes when working on SQL server, i accidentally press something on my keyboard,...
how to really patch a 24/7 always on
hi guys, i have a 2 node AlwaysOn. i need some confirmation on the...
Ask SSC