Is this a SQL Provision Cloned Database?
As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had...
2018-07-18
688 reads
Blog Posts
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the...
2018-07-18
13 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored...
2018-07-18
2,044 reads
Performance Tuning Exercise: Lazy Table Spool
Folks, it’s time for a bit of a performance tuning exercise. Below is a real world situation where a stored...
2018-07-18
23,109 reads
TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends...
2018-07-18
16 reads
TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates...
2018-07-18
241 reads
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,711 reads
Working Hard in Baton Rouge
I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays...
2018-07-18
416 reads
Building Dynamic Table-Driven Queries
This post is a response to this month’s T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for...
2018-07-17 (first published: 2018-07-10)
3,458 reads
New Logo Revealed
I’ve been pondering the creation of a logo for quite some time and I finally decided to go ahead with...
2018-07-17
223 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