Sometimes, work tasks and questions that come up in the SQL Server Community Slack coincide.
A couple weeks ago, DrData asked
With SET STATISTICS IO ON, is there really no way...
2024-10-07 (first published: 2024-09-22)
266 reads
First Things First Thanks to every who came to my session, Asnwering the Auditor’s Call with Automation. Slides and scripts are posted to my Github.
The Event! This was Syracuse’s...
2024-09-08
7 reads
The Problem While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](https://dbatools.io/). It should have been a simple backup/restore copy of the databases,...
2024-08-16 (first published: 2024-08-06)
253 reads
I’m happy to announce that I will be speaking at the first-ever SQL Saturday Syracuse on September 7th, 2024. I will be presenting Answering the Auditor’s Call with Automation
2024-08-14
5 reads
Earlier this year, I embarked on a bit of a project to tidy up the indexes in a sizeable database. This database has over 900 tables, and there are...
2024-08-12 (first published: 2024-07-29)
410 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mala Mahadevan
(blog) asks how we manage our database-related code.
Where do you keep...
2024-08-12
2 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Kevin Feasel
(blog | twitter) asks us about job interview questions.
What is your...
2024-05-13
5 reads
I will be presenting Answering the Auditor’s Call with Automation at two upcoming events, one virtual and one in-person.
DBA Fundamentals Virtual User Group Tuesday, April 9 2024 at Noon...
2024-04-03 (first published: 2024-03-26)
118 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. I missed out on January 2024’s edition because I didn’t think I had anything...
2024-02-28 (first published: 2024-02-20)
180 reads
The holidays have passed and it’s a new year. You probably have a gift card or two and haven’t decided how to use it yet. Allow me to help:
Buy...
2024-01-30
25 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