Queries Impacting TempDB
The question came up that someone wanted to monitor the queries impacting tempdb using Extended Events. Initially, I was pretty sure that there was no real way to do...
2023-02-13
31 reads
Blog Posts
Tales From The Field Weekly Wrap Up for the Week of 02-06-2023
Hello Dear Reader! We had a great last week on Tales from the Field. This weekend was also a really nice one. On Saturday a group of friends gathered...
2023-02-13
33 reads
Tempdb Performance Improvements in SQL Server 2022 are Dramatic
Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when...
2023-02-13 (first published: 2023-02-01)
2,863 reads
Daily Coping 10 Feb 2023
Today’s coping tip is to send a message to let someone know you’re thinking of them. I reached out a friend the other day, someone I know from the...
2023-02-10
31 reads
Daily Coping 9 Feb 2023
Today’s coping tip is to write down your hopes or plans for the future. Hopes are vague, and plans are easier, so here are some plans: Plan a trip...
2023-02-09
35 reads
Allow a user to only trigger pipelines in Azure Data Factory
Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...
2023-02-08 (first published: 2023-01-25)
224 reads
Creating a Flyway Desktop Shadow Database in PostgreSQL
In order to generate migrations, we need to configure Flyway to use a shadow database. This post looks at that process. This is part of a series of working...
2023-02-08 (first published: 2023-02-06)
130 reads
Recovering data with crash consistent snapshots
When we talk about snapshots of SQL Server there are two types, application consistent snapshots and crash consistent snapshots. Application consistent snapshots require freezing IO on a database allowing...
2023-02-08 (first published: 2023-01-25)
478 reads
Daily Coping 7 Feb 2023
Today’s coping tip is to go to bed in good time and allow yourself to recharge. I need this reminder. Lately I’ve struggled to sleep well, through the night,...
2023-02-07
18 reads
RMOUG Training Days in Denver
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG Training Days. The Rocky Mountain Oracle User Group has put this on for years, and...
2023-02-07
21 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 BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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