I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
121 reads
DataOnWheels
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
14 reads
Welcome to 3Cloud …
A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....
2020-10-30 (first published: 2020-10-23)
225 reads
Welcome to 3Cloud …
A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....
2020-10-23
6 reads
Azure SQL Database Elasticity – Presentation Notes
This blog covers the content and points to the code used to create the demos in my Azure SQL Database Elasticity presentations. As of today, I have presented this...
2020-10-27 (first published: 2020-10-20)
348 reads
New Logo, More Family Contributions
Kristyna and I were looking for an update to our logo prior our sponsorship and speaking at the Minnesota SQL Server User Group (PASSMN) in September 2020. I had...
2020-09-03
54 reads
Your First Databricks Notebook
On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series. You can view that presentation here. As part of that presentation, I committed to give...
2020-08-26 (first published: 2020-08-13)
900 reads
Congratulations to Pragmatic Works – Microsoft Partner of the Year Finalists, Again
Pragmatic Works has done it again. Microsoft has recognized us for our work this year with two finalist awards — Power BI and PowerApps and Power Automate. This recognizes...
2020-07-14
50 reads
PASSMN June 2020 – Data Classification with SQL Server and Azure
I presented at the virtual Minnesota SQL Server User Group meeting on June 16, 2020. The topic was data classification with SQL Server 2019 and Azure SQL Database. Data...
2020-06-17
57 reads
Power BI DAX Dynamic Measures
Dynamic measures are an effective way to avoid crowding your report with different versions of the same visual without using bookmarks. No disrespect to the versatility of bookmarks, but...
2020-06-29 (first published: 2020-06-16)
2,903 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCU JOMBANG Telp:08218154398
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
Alamat kantor BCA KCU MADIUN Telp:08218154398
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers