Managed Instance Impressions
Today Steve asks about your view of Managed Instance. He has found many people like the offering quite a bit.
2024-05-27
229 reads
Editorials
The Costs and Rewards of Speaking
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
2024-05-24
117 reads
Invisible Downtime
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
2024-05-22
173 reads
Kubernetes is Cool, But ...
Steve has a few thoughts on Kubernetes and how much data professionals should care about the technology.
2024-05-20
183 reads
Realities of Predictive Analysis
Or for short, “Why you have to play the game” “Don't tell me the odds”, cried out Han Solo just before doing something that seemed impossible. How on Coruscant did he do that? Well, as a certain director said about a certain floating door in a galaxy we all call home. ”It was in the […]
2024-05-18
79 reads
The Evolving DBA
Steve thinks the DBA job is evolving and we will always need people to manage data.
2024-05-17 (first published: 2019-12-16)
515 reads
2024-05-15 (first published: 2019-11-12)
376 reads
Crazy Interviews
Today Steve has a few thoughts about some of the nightmare interview processes tech workers are going through.
2024-05-13
234 reads
Honeybee Swarms
I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]
2024-05-12 (first published: 2024-05-11)
68 reads
Multiple Display Productivity
How many monitors do you need? Steve notes that having multiple ones seems to be a standard these days for tech workers. Do more make you more productive? Answer the poll today.
2024-05-10
164 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
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