System-versioned ledger tables: the next step
In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates...
2021-09-29
60 reads
Blog Posts
Daily Coping 28 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-28
30 reads
SQLSaturday Orlando 2021 – September Update
Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today to catch up on event tasks. That’s deliberate on my part, I knew I was...
2021-09-28
69 reads
SQLSaturday Orlando 2021 – September Update
Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today to catch up on event tasks. That’s deliberate on my part, I knew I was...
2021-09-28
7 reads
#PowershellBasics: Running a .sql script file.
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
556 reads
A Successful Blogger on Making the Switch
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and brand that she never thought was possible.
2021-09-27
45 reads
Book Review: Lights Out
I have always been interested in GE since I was a kid. My best friend in high school had a parent that worked for the company for a bit...
2021-09-27
47 reads
Daily Coping 27 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-27
43 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
6 reads
My upcoming Online Trainings and Speaking Engagements
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...
2021-09-27 (first published: 2021-09-15)
178 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...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
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