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.
2026-06-17
18 reads
AI
Stop Prompting Your AI Agent. Give It a Playbook.
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
2026-05-25
3,608 reads
We Are Eating Our Own Seed Corn
Last week I stood in front of a classroom at Washington State University and looked out at a room full of students who had done everything right. They had studied hard, were earning their degrees, built their portfolios, and showed up with genuine enthusiasm for careers in technology. They wanted to know what the industry […]
2026-05-16
214 reads
2025-09-06
142 reads
Shades and Reflecting on SQLBits and the Bright Future of Data
There is something magical about SQLBits. Whether it is the technical sessions, the sense of community and fun, or the relentless commitment to learning about the latest innovation, this event continues to serve as a pulse check for where data is today and where it’s going tomorrow. This year’s SQLBits at the ExCel in London […]
2025-06-21
58 reads
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
As someone who has had the honor of delivering keynotes at both Oracle and SQL Saturday data events, I’ve spent time with professionals on both sides of the database world. I’ve held the title of database administrator, developer, engineer and architect for structured, transactional giants and the analytics-heavy ecosystems of eight different database platforms, (not […]
2025-05-17
101 reads
Throwing Iron at the Cloud and AI
As organizations move to the cloud, the once essential role of the Database Administrator (DBA) as the guardian of system optimization, has been overshadowed, often viewed as a bottleneck to innovation. Yet, as technology evolves, the one thing I know is history repeats itself, and optimization skills are once again emerging as a critical necessity. […]
2025-02-01
102 reads
Meet the new Google AI Assistant Gemini
Learn about the new Gemini AI from Google and how this can be used for common tasks, as well summarizing content.
2024-07-08
2,033 reads
Evolving Role of Data Professionals in Artificial Intelligence Era
Generative Al tools like Gemini and GPT promise to automate and augment knowledge-based work. Data professionals must adapt to this transformation by acquiring new skills and playing a central role in their organization's AI-driven future. Data preparation, curation, ethical sourcing and labeling, and collecting user feedback become crucial as high-quality data is essential for effective LLM based application.
2024-03-04
2,717 reads
2024-02-26
5,683 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
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...
Detecting Characters
Comments posted to this topic are about the item Detecting Characters
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