How to get Power BI RLS to work with external users
Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this...
2016-10-06
3,250 reads
SQLDownSouth
Happy Birthday Power BI
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product...
2016-07-24
792 reads
Join me at SQL Saturday 531, Louisville, KY
So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday...
2016-07-21
617 reads
Using Power BI to list Enterprise Only SQL Features
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
638 reads
What’s wrong with the Power BI KPI Visual?
Over the past couple of weeks I have been asked several times about the KPI Visual that is native to...
2016-07-06
1,982 reads
Higher Education Retention Analytics using Power BI
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This...
2016-06-06 (first published: 2016-06-01)
2,312 reads
SQL Saturday 486: Richmond, VA Precon
Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend...
2016-03-14
1,048 reads
Refreshing KPI Data in SSRS 2016
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,111 reads
More SQL Saturday Precon News(Real-time Dashboards)!!!!
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...
2016-02-19
1,212 reads
Creating KPIs in SQL Reporting Services
In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016. Let’s...
2016-02-22 (first published: 2016-02-17)
6,781 reads
Blogs
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Forums
Dropping a PK constraint.
I will have to test this next week, but will not have a chance...
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers