Bad IT People
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
Midjourney, Healthcare?
Certain announcements in AI tell you more about where an industry is heading than any earnings call or research paper ever could, and Midjourney just made one. The company that spent the last few years as the most recognizable name in image generation, the one whose pictures flooded everyone's feeds and defined what people saw […]
Changes, Happiness, and a Few Tears
Change is unavoidable and always affects us. We can be both happy and sad about it as we move forward. A tribute today to Annabel, who retired from Redgate Software this week.
You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
The LLM layer you’re probably missing (LLM gateway pattern explained)
The LLM gateway pattern is a thin service layer that sits between your app and large language model (LLM) providers, centralizing every AI call through a single entry point. It gives you immediate control over routing, logging, retries, fallbacks, and cost tracking – preventing the chaos of scattered integrations, unclear billing, and provider lock-in as your system scales. Learn all you need to know about the LLM gateway pattern in this article.
Follow Your Hunch
One of the positives of AI is that you can try things on which you might not otherwise have time to experiment.
What Happens When You Ask a Local AI to Query Your Database?
Learn how you can run a simple LLM on your own machine with Python.
Your Database Just Hit One Terabyte: Now What?
You were minding your own business, and all of a sudden it happened.
Calculating the Harmonic Mean in Power BI
Learn how you can add a harmonic mean calculation in Power BI.
The Slow Growing Problems
Not every problem is going to fire off an alert, but it still might be something that you want to track.
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, 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 WISMA ASIA Telp:(0817)866887
??/WA:0817866887 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Alamat kantor BCA KCU PONDOK INDAH ??/WA:(0817)866887
WA:0817866887 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers