Most of the time when I talk about or demo Extended Events, I spend more time talking about query tuning (I have a problem). However, there are tons of...
2022-07-05
132 reads
Hello all. I know most of you are still working within SQL Server. However, a few of you are become more like me, hybrid data managers, working in more...
2022-06-13
1 reads
As I’ve been working more with PostgreSQL, I’ve found that I’m basically pretty happy just issuing SQL commands to get work done. However, it’s handy to have an actual...
2022-06-06
1 reads
For the longest time, we didn’t have one of the most useful tools for monitoring SQL Server behavior, but I just found out that, indeed, you can use Extended...
2022-05-11 (first published: 2022-05-02)
183 reads
TLDR: There ain’t one. I was privileged last week to be able to present a couple of sessions at the SQL Server and Azure SQL Conference (great event, I...
2022-04-18 (first published: 2022-04-11)
598 reads
Two years ago at the start of the pandemic, I wasn’t feeling great about things. I saw that quite a few others weren’t all that thrilled about how things...
2022-04-04
29 reads
I’ve watched several people recently go straight to XML when reading execution plans because they didn’t know about the execution plan properties in the first operator. Now, don’t get...
2022-03-14
28 reads
I have long been a fan of Azure Data Studio, but one shortcoming has kept me from truly adopting it: Query Plans in Azure Data Studio. Sure, there was...
2022-03-21 (first published: 2022-03-07)
354 reads
In the last few Fundamentals posts you were introduced to a couple of ways to limit and control the data stored in the tables in your database. A primary...
2022-02-28
17 reads
I recently saw a question about the Azure Data Studio Intellisense: “Why won’t intellisense in Azure Data Studio work with different schemas?” Immediately I thought, “Wait, it does.” But,...
2022-02-22
54 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers