Meta AI by Facebook: A New Contender in the AI Battle
Introduction Meta AI from Facebook is one of the last big technology giants’ contenders in the AI battle. In our first article, we created a demo about ChatGPT. Secondly, we talked about Bing from Microsoft, who is now Copilot. Thirdly, we mentioned Ba …
Using try catch in SQL Server stored procedures
The post Using try catch in SQL Server stored procedures appeared first on SQLServerCentral.
Retrieving Data Using the REST API in Data API Builder
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this product works and how to start using it. That was a basic look, but it gives data professionals an idea of how this might help them work more closely with fron …
[Video] Office Hours: Hello Kitty Porsche Edition
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:56 TheWorstDBA: I have a large table with 50 billion rows …
How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article (don’t worry; they’re not rel …
Introduction to SQL Commands, Part 3: Retrieving and Sorting Data
In the final part of this series, learn how to use SQL Server’s SELECT command to retrieve, filter, and sort data efficiently from a database table.
Using the CASE expression instead of dynamic SQL in SQL Server
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Building AI Calls into the First Responder Kit
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your throat, but I can think of a few ways I actually want to get quick, easy advice from large language models (LLM) when I’m calling the sp_Blitz scripts: sp_BlitzCach …
Sponsoring PGDay Chicago this week
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This will be the second year in a row that we sponsor this event, but the first time one of the Simple Talk staff will be in attendance as the Simple Talk editor will be …
Exploring the SQL Server CHOOSE Function
I preface a lot of what I write with whether or not it is for a “practical” use. One of the Simple Talk authors used this function in a forthcoming article. and I realized I hadn’t heard of it before (or I forgot about it… which …
It’s Time for Fundamentals Week! Register for Tomorrow’s Classes.
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and they’ve whetted your appetite for serious SQL Server learning. You enjoy my laid-back, humorous approach to sharing what I’ve learn …
Introduction to SQL Commands, Part 2: Adding, Updating Data
This installment of our three-part series on SQL commands explores essential SQL commands for inserting, modifying, and deleting data within a SQL Server table.
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible ways to enhance SQL queries. While these operators might seem complex at first, understanding how they function can s …
SQL Saturday Richmond Roundup
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived for 5 years in the Virginia Beach (and worked for a company there for 20 more), Richmond events have long been a staple of my SQL Server community i …
Using the Default Trace in SQL Server
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.