(2022-Jun-20) As it takes a village to raise a child, it also takes a team to develop a good SQL Server database project. Previous efforts to maintain manual or custom SQL...
2022-07-13 (first published: 2022-06-20)
1,091 reads
You have decided that snowflake is the technology you want to use to build your next gen data platform, you have decided your cloud provider (Azure, AWS, GCP) then...
2022-07-13
121 reads
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL Server virtual machine performance tuning tips with our friends at Sanity Solutions on July 21st...
2022-07-13 (first published: 2022-06-25)
389 reads
Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...
2022-07-13 (first published: 2022-07-12)
24 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-12
13 reads
Often enough I get questions regarding partitioning to try to help alleviate performance issues with very large tables. A common misconception is that due to the table being large,...
2022-07-12
34 reads
I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...
2022-07-12
104 reads
A great invitation this month from Deborah Melkin. I thought this was very apt, as I use this phrase often. Many of us do. This was a tougher post...
2022-07-12
20 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Deborah Melkin (blog | twitter) asks us for a database-related rant.
I...
2022-07-12
1 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-11
7 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