SQL Server 2016 Row-level Security and SSRS a perfect match
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
8,833 reads
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
8,833 reads
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
925 reads
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked...
2016-01-25
2,555 reads
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they...
2015-12-17 (first published: 2015-12-14)
1,836 reads
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted...
2015-12-09 (first published: 2015-12-02)
4,186 reads
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
899 reads
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturdayfor the first time...
2015-07-24 (first published: 2015-07-20)
2,094 reads
After a few years away, the Baton Rouge SQL Saturday group has finally allowed me back at their annual event...
2015-07-15
1,340 reads
Join me for a full day of Power BI in Baton Rouge, LA and Downers Grove, IL, where I will teach...
2015-04-13
1,394 reads
2015-04-10
1,105 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers