Speaking at SQLSaturday Sacramento – 757!
Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 28th 2018! And wow,...
2018-07-24
279 reads
Blog Posts
SQL Server data flow into Excel template with Power Query function-based parameter
(2018-July-15) Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a...
2018-07-24 (first published: 2018-07-15)
2,498 reads
VMworld 2018 SQL Server Sessions
I hope to see you all at this year’s VMworld 2018 USA conference where I’m lucky enough to have been...
2018-07-24
742 reads
10 SQL Saturdays – and a personal parting of ways
I’ve written many posts on SQL Saturdays , especially the one at Louisville. This one is a bit different. This is...
2018-07-23
240 reads
Book Review – Factfulness by Hans Rosling
I recently bought the book Factfulness – Ten Reasons we’re wrong about the world – And why things are better than you...
2018-07-23 (first published: 2018-07-15)
2,662 reads
Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
823 reads
Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,548 reads
Monitoring Azure SQL Database
There are a number of options to monitor Azure SQL Database. In this post I will briefly cover the built-in...
2018-07-23 (first published: 2018-07-06)
2,437 reads
Off on Holiday
Another break for me. This might actually be the first year I use all my vacation allowance.
In any case, I’m...
2018-07-23
843 reads
Power BI Monthly Digest – July 2018
This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of...
2018-07-23
877 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
Alamat Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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