Take over Ownership in Microsoft Fabric
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a pipeline …), you are also the owner of the item. There has been an...
2025-02-05 (first published: 2025-01-29)
580 reads
How-To Convert Excel Date & Time to SQL
Hey data friends! This one comes from my personal vault (aka backlog of drafts I’ve been needing to write up) and is a really simple code that I always...
2025-02-14 (first published: 2025-01-28)
1,319 reads
SQL in 2025: Still the King of Data
Data's the new oil, and SQL is your refinery. It's still the go-to language for shaping, analyzing, and making sense of the data that fuels our businesses. In 2025,...
2025-01-28
224 reads
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to it. I had to go fishing to find all the grants to...
2025-02-12 (first published: 2025-01-27)
238 reads
Get a PAT in Azure DevOps
I have a presentation recently on Continuous Integration Using Local Agents in Azure DevOps and one of the things I do in there is get a PAT for Azure...
2025-02-05 (first published: 2025-01-27)
398 reads
The Local OLLAMA Gui
I ran a small ollama model in a container and have been doing some experiments. One of the things I wanted to do was get a GUI so I...
2025-01-27
172 reads
A New Word: Amoransia
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for someone you can never have, wallowing in devotion to some impossible person who could give...
2025-01-24
58 reads
The Data API Builder Start and Add Extensions in VS Code
One of the things that I like about the Data API Builder (DAB) is that there is a lot of CLI work that can be done. However, lots of...
2025-01-22
135 reads
Using OneLake for Excel Files in Microsoft Fabric
Hey data friends! This blog is to discuss an edge case I’ve run into in Microsoft Fabric. I won’t go into all the context, but the goal was to...
2025-02-03 (first published: 2025-01-21)
2,411 reads
Another AI Faux Pax
I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it...
2025-01-31 (first published: 2025-01-20)
416 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
ALAMAT BCA KCU BUKIT BARISAN TLP/WA 08218200174
Telp Cs: 08218200174 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera...
ALAMAT KANTOR BCA KCU MEDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan,...
Alamat Kantor BCA KCP Kartini Tlp/Wa 08218200174
Telp Cs: (0821)8200174 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2,...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers