DotNet developers, if you’re using the System.Data.SqlClient, stop. Move over to Microsoft.Data.SqlClient now. It’s easy to do, well, it’s relatively easy to say that. The actual work isn’t that...
2020-04-02 (first published: 2020-03-26)
1,202 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-26
9 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-25
13 reads
Next week is April 1, typically April Fools Day, where we have jokes, pranks, and false stories. I’ve done my share of them, but this isn’t one. With the...
2020-03-30 (first published: 2020-03-25)
323 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-24
51 reads
Travel is limited, or banned, in many cases these days. Events are cancelled or postponed, and there is a limit to how much contact we should have with each...
2020-03-23
6 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-23
18 reads
We’ve got three days of online content coming your way from Redgate on Apr 1-3. There is a great lineup, and you can register for each day here: Wed,...
2020-03-27 (first published: 2020-03-20)
182 reads
I’ve not done much BI work in my career, other than simple aggregates in reports. I’ve wanted to tackle projects, but I’ve rarely had a chance to spend time...
2020-03-16
211 reads
Today is T-SQL Tuesday #124 and I’m dropping a quick post as I’ve had lots of other stuff to do since returning from my sabbatical. Tracy Boggiano is the...
2020-03-10
116 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