SQLSaturday Orlando Notes – Cupcakes & Ice Cream
For the past few years we’ve had a a local sponsor provide cupcakes as the “sweet treat”. We started with mid afternoon but found it worked well if we...
2019-11-25
21 reads
Blog Posts
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the ... Continue reading
2019-11-25 (first published: 2019-11-14)
1,140 reads
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with the new SQL Server 2019 RTM images. Microsoft changed the way SQL runs within a...
2019-11-25 (first published: 2019-11-18)
3,707 reads
Back for More with SQL, Azure, Machine Learning, Big Data!!!!
Let me start with an apology for being missing so long 🙂 Guess was trying to find where technology takes me as I started my journey with pool of...
2019-11-23
169 reads
I’m Speaking at #SQLSatDC
I am so excited to announce that I will be speaking at SQL Saturday DC on Saturday, December 14, 2019. I am so honored to have been selected. This...
2019-11-23
18 reads
Batch Scripting SQLCMD–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wouldn’t do this anymore, but I ran...
2019-11-22 (first published: 2019-11-13)
423 reads
Power BI Monthly Digest – November 2019
In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson will again guide you through some of the latest and greatest
2019-11-22
36 reads
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
Check out this new series that I’ve started on Power Platform Quick Tips. This series is all about solving problems quick with videos less than
2019-11-22 (first published: 2019-11-14)
348 reads
Resuming Index Operations With Different Options
Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019,...
2019-11-22
19 reads
SQL Saturday Rochester Returns!
We have just published SQL Saturday Rochester 2020. We took last year off but we’re back for 2020 on a very special day - it’s Leap Day, February 29th!
What...
2019-11-22
7 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