This weekend is Christmas, and likely many of you are not working hard today and will enjoy a long weekend until Tuesday. There are many other holidays at this time of year as well, and I hope you are enjoying the season with loved ones. I want to take a moment to wish everyone a […]
2022-12-23
62 reads
Does your database server need an upgrade? Steve notes that you might learn a bit about the best hardware to ensure a good ROI. Even if you wouldn't make a change for your own desktop machine.
2022-12-21
142 reads
Steve realizes that he doesn't use physical storage anymore for transferring data.
2022-12-19 (first published: 2022-12-16)
154 reads
It's time to look at an instance upgrade for SQL Server Central. Or is it? Steve shares some thoughts about the process and decision making.
2022-12-14
297 reads
Learning to efficiently manage time in a team is hard. Steve has a few ideas today, based on a book.
2022-12-12
162 reads
If you're an experienced, knowledgeable, seasoned (I won't say old), SQL Server data professional, and you choose to use Trace Events (Profiler), more power to you. That's it. That's all I have to say. Do what you think best. I'm never, ever (again), going to second guess you. Further, my apologies for ever having done […]
2022-12-10
182 reads
Is the stuff we do in our off hours truly relaxing or just taking up time?
2022-12-09 (first published: 2017-03-31)
196 reads
2022-12-07 (first published: 2017-03-21)
164 reads
2022-12-05 (first published: 2017-04-11)
212 reads
Steve reminds us about being charitable if we are fortunate enough to do so.
2022-12-03
44 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...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
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