A New Word: Suente
suente– n. the state of being so familiar with someone that you can be in a room with them without thinking, without holding anything back, or without having to...
2024-12-20
11 reads
The Voice of the DBA
My 2024 in Data: Health and Workouts
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-19
4 reads
My 2024 in Data: Reading
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-18
18 reads
My 2024 in Data: Speaking
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-17
13 reads
My 2024 in Data: Travels
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-16
7 reads
Playing with the Data API Builder
I published an article today on the Data API Builder, which is a way of presenting your database tables as a REST or GraphQL API for developers. You can...
2024-12-27 (first published: 2024-12-13)
407 reads
A New Word: Dolonia
dolonia – n. a state of unease prompted by people who seem to like you too much, which makes you wonder if they must have you confused with someone...
2024-12-13
9 reads
A Very Cool Benefit in SSMS 21
I saw a post from Erin that Preview 2 is available. I’d gotten a message when I started SSMS v21 this morning, but got distracted. I made a short...
2024-12-25 (first published: 2024-12-11)
1,071 reads
AI Helping with an API
Can an AI help me with some database API work? Let’s see. This is part of a series of experiments with AI systems. The Scenario One of the things...
2024-12-11
119 reads
Creating a “Real” Copy of a View: #SQLNewBlogger
I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....
2024-12-23 (first published: 2024-12-11)
592 reads
Blogs
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Get a PAT in Azure DevOps
By Steve Jones
I have a presentation recently on Continuous Integration Using Local Agents in Azure DevOps...
The Local OLLAMA Gui
By Steve Jones
I ran a small ollama model in a container and have been doing some...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Calculating Numerator and Denominator
Good evening, I have a rather peculiar issue while trying to calculate Numerator and...
Select statement with in using multiple columns
I inherited a mess. The previous developer did not understand how to set up...
Question of the Day
The AG Synchronous Replicas
In a SQL Server 2022 Enterprise Edition AG, how many replicas can be configured with synchronous commit mode?
See possible answers