Finding Identity Columns–#SQLNewBlogger
I had to find a set of identity columns recently and through this would make a good blog post. Another post for me that is simple and hopefully serves...
2023-08-25 (first published: 2023-08-02)
1,928 reads
Blog Posts
Open Online Community Hangout During PASS Summit
Are you bummed that you can’t attend the PASS Data Community Summit conference in-person this November during the week of November 13? There’s lots of reasons to be there,...
2023-08-25
21 reads
T-SQL Tuesday #165 Job Titles – What do you need?
My dear friend Josephine Bush a.k.a HelloSQLKitty hosts this month’s T-SQL Tuesday. Josephine’s call to us is to share our understanding of the multitude of job titles available out...
2023-08-25 (first published: 2023-08-08)
189 reads
Using Secrets in Docker Swarm for SQL Server
In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...
2023-08-23 (first published: 2023-08-02)
222 reads
What’s in a SQL Server Managed Instance?
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading
2023-08-23 (first published: 2023-08-03)
476 reads
Creating and Configuring a Power BI VNet Data Gateway
If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can...
2023-08-21 (first published: 2023-08-01)
773 reads
Decrypting Stored Procedures with SQL Compare
I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...
2023-08-21
256 reads
Reflections on the Software Industry
Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...
2023-08-21 (first published: 2023-08-01)
174 reads
A New Word: Rückkehrunruhe
rückkehrunruhe – n. the feeling of returning from an immersive trip only to notice if fading rapidly from your awareness, as if your brain had automatically assumed it was...
2023-08-18
305 reads
Data Types - Does size really matter? - nvarchar vs. varchar
How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...
2023-08-18
6 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
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...
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 JOMBANG Telp:08218154398
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
Alamat kantor BCA KCU MADIUN Telp:08218154398
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
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