Converting a Power BI Desktop File from Import to Live Query
A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During...
2018-01-30
1,142 reads
Ten Ways To Help Your BI Consultant Be Successful
I’ve been working in the field of business intelligence for over ten years, as a consultant for over five years....
2018-02-12 (first published: 2018-01-30)
2,767 reads
Managing SQL Prompt Code Analysis Rules
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2018-02-08 (first published: 2018-01-29)
1,609 reads
No Default CONTEXT_INFO()
I was doing a little testing of Row-Level Security (RLS) for the stairway, and one of the ways that some...
2018-01-29
511 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
860 reads
SQL Undercover Podcast – Feb 2018
The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of...
2018-01-29
452 reads
Power BI Data Security – Sharing
Microsoft recently added more sharing capabilities that may change my view on sharing within the enterprise. As with all things...
2018-02-06 (first published: 2018-01-29)
1,647 reads
Youtube Channel Update
Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...
2018-01-29
290 reads
Deleting Azure SQL Database VNETs
This is quite a new feature (currently in preview) but an important one where we now have the ability to...
2018-02-07 (first published: 2018-01-29)
1,034 reads
How To: Install SQL Server on an Azure VM
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is...
2018-01-29
623 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers