Now that SQL Server 2025 has finally been released to the public, I was finally able to test and learn a lot about this command (named CREATE EXTERNAL MODEL), and I want to share my knowledge with you here. If you’re new to the world of AI, don’t worry, we’ll start with the basics and evolve to where this command fits in!
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
Learn about transaction ID wraparound in PostgreSQL, which caused a problem for the author.
Learn how you can combine Power BI and Excel to share data from your local SQL Server across the Internet to Excel on a client machine.
Microsoft Fabric is a unified platform for data integration, data engineering, real-time intelligence, and advanced analytics. Fabric is known for providing an integrated way of working with your data, connecting to many diverse types of sources and across the data landscape. How do we get started ingesting and analyzing real-time data streamed over the MQTT protocol?
A look back at SQL Server Central after 25 years from founder Brian Knight.
Steve talks about some of the charitable work at SQL Server Central.
A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.
Steve thinks a few lessons on being a software engineer at Google are good items for anyone to think about.
Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
Comments posted to this topic are about the item Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers