[Video] Office Hours: Hot Dog Fingers Edition
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, and… it’s still pretty weird. Let’s go through your top-voted questions from https://pollgab.com/room/brento and have a laugh at my hot dog fingers. I …
SQL Server 2022 Finally Fixed a SQL Server 2008 Query Plan Bug!
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan from right to left, top to bottom, looking for the place where the estimates vs actuals are suddenly way off.” Here’s an example: …
Working with the MongoDB Database Tools
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. The MongoDB Database Tools are a set of command-line utilities for working with MongoDB instances and their data. You can use the …
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.