Hello Dear Reader! Last week was a really busy week with an even busier weekend. We will get to the show recap's in a moment but first let's dive...
2023-04-17
6 reads
While I always configure transaction log backups for every database in non-simple recovery model, and to compliment it I also have monitoring in place if transaction log doesn't get...
2023-04-17 (first published: 2023-03-31)
809 reads
There’s a video of Bill Gates taking a drive in an autonomous car around London. I’ve been to London dozens of times, ridden and cabs and Ubers, and even...
2023-04-14 (first published: 2023-03-31)
233 reads
A few months ago, I wrote a post on how I use voice technology to continue working with my ALS condition. Since that post was written, Microsoft released a...
2023-04-14 (first published: 2023-03-28)
159 reads
In the last post, I created a baseline marker for Flyway in each database. This set the version in the dev and QA databases to v1. However, I also...
2023-04-12
27 reads
Did you know that you can change the browser used by SQL Server Management Studio to authenticate using Azure Active Directory to a SQL database in Azure? I had...
2023-04-12 (first published: 2023-03-28)
527 reads
SQL doesn’t really give us too many tools out of the box to allow us to spot when someone may be up to no good. We can look at...
2023-04-12 (first published: 2023-03-29)
533 reads
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers...
2023-04-11
2 reads
I delivered a session on graph databases, and in it I used RedisGraph to show how you can work with graph data on that platform. This blog shows a...
2023-04-10
56 reads
This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life....
2023-04-10 (first published: 2023-03-24)
527 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
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
Comments posted to this topic are about the item New SQL Server 2022 Functions
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