Running SQL Server in Docker Swarm
I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...
2023-08-14 (first published: 2023-07-26)
377 reads
Blog Posts
Which Schema is Queried First?–#SQLNewBlogger
I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...
2023-08-14 (first published: 2023-07-26)
391 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-13 (first published: 2023-08-12)
2,319 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-12
37 reads
A New Word: Aubadoir
aubadoir – n. the outworldly atmosphere just before 5 am, when the bleary melodrama of an extremely late night becomes awkwardly conflated with the industrious flourescence of a very...
2023-08-11
208 reads
Exploring limitations of Fabric Warehouse: 3 key observations
Introduction
Fabric Warehouse is a new interesting tool used for data management and analysis. While it offers a wide range of features and functionalities, it is essential to be aware...
2023-08-11 (first published: 2023-07-26)
498 reads
Presenting at PASS Summit 2023 – Atomic Habits
I’m excited to be presenting at PASS Summit 2023, not only because it is PASS Summit but because of the topic. I do a lot
The post Presenting at PASS...
2023-08-11 (first published: 2023-07-26)
150 reads
Webinar: Unlock the Full Potential of Flyway to Achieve Automated Database Releases
On Aug 22, 2023, I’m co-hosting a webinar with Anderson Rangel, Redgate Solution Engineer in Brisbane. You can register here for the 11am AEST webinar. No, I’m not going...
2023-08-11
26 reads
The 2023 Redgate UK DevOps Roadshow
Years ago Redgate did some traveling events under the SQL in the City brand. These were a lot of fun and kind of amazing. One of the longer tours...
2023-08-10
37 reads
Finding Encrypted Stored Procedures–#SQLNewBlogger
I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts...
2023-08-09
297 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