SQL Saturday Jacksonville Slide Decks
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous Integration Using Local Agents Adopting a DevOps Process for Your Database
2022-05-14
59 reads
Power BI connectors to Azure Synapse
When using Power BI and pulling data from Azure Synapse, you will use the “Get Data” feature in Power BI. There are now three connections that you can use...
2022-06-08 (first published: 2022-05-13)
271 reads
Snowflake + Azure Privatelink
Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such as Snowflake. This secures the connection between client endpoint and Snowflake(more...)
The post Snowflake + Azure...
2022-05-13
208 reads
Daily Coping 13 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-13
14 reads
Installing the mssql-cli on Ubuntu 22.04
I really like the mssql-cli tool. I use it pretty much everyday however it seems like it’s not being maintained anymore and as such, there are issues when trying...
2022-06-08 (first published: 2022-05-13)
513 reads
Azure Synapse Explained
In this article we would like to give you a high level summary on Azure Synapse.
What it is, what are its strengths and weaknesses observed through our project implementations...
2022-06-06 (first published: 2022-05-13)
493 reads
SQL Saturday Jacksonville – May 14th, 2022
Hi Everyone, This is your Austin SQL Server Consultant and I will be speaking at SQL Saturday Jacksonville. I am happy to get back out and, on the road,...
2022-05-13
18 reads
Cross DB Access With Module Signing
Foreword
I’ve recently had to revisit this topic and spent a lot of time recalling the details. So I’m writing this blog post mainly as a reminder for myself.
The most...
2022-05-12
20 reads
Power BI Adding Dynamic Hierarchies – XMLA, TOM, C#
This post is a continuation of my adventure into the Tabular Object Model and how we can use it to make Power BI scalable and incorporate it into existing...
2022-06-06 (first published: 2022-05-12)
255 reads
Two Percent, Five Percent, More?
I was reading Seth Godin today and he makes this claim: If 2% of a population takes coordinated action, it makes a difference. If 5% do, it can change...
2022-06-03 (first published: 2022-05-12)
303 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers