Creating a SQL Clone Image from a SQL Clone Database
A customer asked if a new image could be created from a database that was itself a SQL Clone. It can, and I’ll show that in this post. This...
2023-10-27 (first published: 2023-10-16)
225 reads
Blog Posts
Suppressing the FOMO
I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...
2023-10-27
28 reads
Handling physical deletes from the source and continue populating your analytical data store
(2023-Oct-15) When something important disappears, it's natural to start asking questions and looking for answers, especially when that missing piece has had a significant impact on your life.Similarly, when data...
2023-10-25 (first published: 2023-10-16)
336 reads
The Evolution of Database Administration: From Administration to Database Reliability Engineering
In the fast-paced world of IT, where trends like DevOps and Infrastructure as Code (IaC) dominate the landscape, the concepts of Reliability and Observability have seamlessly woven themselves into...
2023-10-25 (first published: 2023-10-10)
509 reads
T-SQL Tuesday #167 – Encryption and Data Protection
I missed September since I was gone half the month in Europe and busy with a roadshow. And, I missed October, since I was busy this month and lost...
2023-10-25
48 reads
Common Mistakes in SQL Server – Part 4
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-23 (first published: 2023-10-09)
930 reads
Common Mistakes in SQL Server – Part 6
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-10-23
23 reads
Speaking at #DataWeekender 6.5
Super excited to share that I have been selected to speak at Data Weekender 6.5 on Saturday, November 4, 2023. I will be presenting my session, Can Microsoft Purview...
2023-10-23
33 reads
Using the Pure Storage PowerShellSDK2 - Part 2 - Working With Data
Welcome back to the second installment of our series using the Pure Storage PowerShell SDK2. In this post, we’ll dive into working with object data using Pure Storage PowerShell...
2023-10-23 (first published: 2023-10-05)
181 reads
A New Word: Gobo
gobo – n. the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...
2023-10-20
32 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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 BCA KCP Pejaten Tlp,Cs:0821-8154-393
WA:08218154393 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F &...
Alamat kantor BCA KCP Galuh Mas Telp:0818751777
WhatsApp:0818-751-777 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
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