T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
439 reads
DataOnWheels
Consumption Based Architecture for Modern Data Analytics
Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data...
2017-02-09
658 reads
North Texas SQL Server User Group – September 2016 Follow
Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you...
2016-09-19
398 reads
Power BI Is Finally in the Azure Trust Center
With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review...
2016-05-11 (first published: 2016-04-28)
2,674 reads
JSON in SQL Server 2016 – The Good, The Bad, and The Ugly
Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see...
2016-04-20
720 reads
SQL Saturday #492 Follow Up – A Window into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-04-16
468 reads
VS Live 2016 – Las Vegas Follow Up
I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were...
2016-04-11
421 reads
SQL Saturday #486 Richmond – A Window Into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-03-19
540 reads
Excel Tip #30: Excel Services Visual Limitations – Displaying Images
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2016-03-14 (first published: 2016-03-04)
1,713 reads
Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
560 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 KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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