Episode 11 of Simple Talks: Oracle
The 11th episode is now live, recorded a few weeks ago at the PASS Data Community Summit. This was a lot of fun, us grabbing a space in the...
2024-12-06 (first published: 2024-11-22)
199 reads
Blog Posts
Microsoft Ignite Announcements Nov 2024
Announced at Microsoft Ignite last week were some new product features related to the data platform and AI. Check out the Major announcements and Book of News. Below are...
2024-12-06 (first published: 2024-11-26)
343 reads
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful applications on Kubernetes.Even though almost no one questions using Kubernetes (K8s) to manage container applications...
2024-12-04 (first published: 2024-11-23)
494 reads
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a company? appeared first on Joyful Craftsmen.
2024-12-04 (first published: 2024-11-25)
304 reads
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file would be. In QA, I have (relatively) large dbs (compared to prod). Enter the pgstattuple...
2024-12-02 (first published: 2024-11-21)
194 reads
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless) Availability Group to seed a database from a Windows SQL instance into a pod in...
2024-12-02 (first published: 2024-11-19)
256 reads
AI Step 1
As this is an Artificial Intelligence (AI) World, things are changing. We can see that everywhere you look, even now, when writing a blog, I could feel it today :)....
2024-12-01
39 reads
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user interface, while Rust delivers performance and safety on the backend.A Dockerized todo app is a to-do...
2024-11-30
70 reads
A New Word: Nachlophobia
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty shallow, that although your relationships feel congenial in the moment, an audit of your life...
2024-11-29
142 reads
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance Best Practices (Amazon link), which means I got a copy for free. The book is...
2024-11-29 (first published: 2024-11-19)
207 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers