Power BI Monthly Digest – August 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-08-14
141 reads
Blog Posts
Power BI, Dataflows, CDM, and Dynamics 365 – My Journey
My company, Pragmatic Works, is working through a Dynamics 365 migration. As part of that migration, we need reports. We have made the decision, seemingly obvious given who we...
2019-08-14
126 reads
See you Saturday in Baton Rouge!
See you in Baton Rouge this weekend! We have 13 tracks of professional development and training, from entry-level to expert, for SQL Server Administrators, Business Intelligence Developers, Data Analysts,...
2019-08-14
21 reads
SQL Server Management Studio is as Relevant as Ever
After almost fifteen years of heavy usage by developers and database administrators (DBAs), it might seem like Microsoft’s free tool, SQL Server Management Studio (SSMS), is about to go...
2019-08-14
10 reads
Allow SQL Server Agent jobs management for non sysadmins
I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...
2019-08-13
12 reads
Check Out the Updated Violin Plot Power BI Custom Visual
I wrote about the violin plot custom visual by Daniel Marsh-Patrick back in February. I thought it was a good visual then, but version 1.3 has recently been released...
2019-08-13 (first published: 2019-08-01)
811 reads
Collecting Server Performance Metrics: PowerShell
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-08-13 (first published: 2019-07-30)
3,087 reads
How do we prove our ETL processes are correct? How do we make sure upstream changes don't break our processes and break our beautiful data?
ETL Testing Part 2 - Operational Data Testing
This is the second part of a series on ETL testing, the first part explained about unit testing, and in this part,...
2019-08-13
4 reads
How do we prove our ETL processes are correct? How do we make sure upstream changes don't break our processes and break our beautiful data?
ETL Testing Part 2 - Operational Data Testing
This is the second part of a series on ETL testing, the first part explained about unit testing, and in this part,...
2019-08-13
199 reads
SQL Saturday Boston: I’m Speaking!
It feels like SQL Saturday Albany just wrapped up, but I have another announcement to make. I am proud to announce that I have been selected to speak at...
2019-08-13
5 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Mal Taman Anggrek Telpon/WA:087768193341
BCA KCP Mal Taman Anggrek Telpon/WA:087768193341.Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot....
Cs Lion Air Tower Tlp/ Chat 087757643837
WhatsApp 087757643837 Jl. Kartika Plaza, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80361 <!--more-->
BCA KCP KS Tubun,Telpon/Wa 0821-8200-239
Jalan Letjen. S. Parman Kav. 28, L No.216-217, RT.12/RW.6, Tj. Duren Sel., Kec. Grogol...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers