I have a shorter post this week, but I reckon it’s an interesting story. As part of the new Intelligent Query Processing improvements introduced in the upcoming SQL Server...
2019-05-01
39 reads
I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...
2019-04-10
19 reads
Jurassic Park was a great film. Steven Spielberg brought technology into the film era in a major way with computer generated dinosaurs and some now-classic film lines, many of...
2019-04-03
41 reads
Heads up for SQL Server on Linux folks using availability groups and Pacemaker. Pacemaker 1.1.18 has been out for a while now, but it’s worth mentioning that there was...
2019-03-27
19 reads
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
652 reads
Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c98bf6b3202b962253620/] Here’s a screenshot of me running mssql-cli on the...
2019-03-13
675 reads
I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of...
2019-03-06
268 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-27
432 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
319 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
174 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
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...
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