PowerHour - Online PowerShell Lightning Talks!
Earlier this week, the PowerHour was announced. What is it? It’s kind of like a virtual user group. One hour, 6(ish) lightning demos (10 minutes or less), centered on...
2018-08-03
2 reads
Earlier this week, the PowerHour was announced. What is it? It’s kind of like a virtual user group. One hour, 6(ish) lightning demos (10 minutes or less), centered on...
2018-08-03
2 reads
This month’s T-SQL Tuesday is hosted by Bert Wagner and he asks us to write about code we’ve written that we would hate to live without.
First off, “hate” is...
2018-07-10
3 reads
This week, I had the opportunity to be the moderator for Joseph Barth’s (blog|twitter) 24 Hours of PASS Summit Preview session about Azure Data Factory V2. It was fun,...
2018-06-15
I really enjoy my job. I became a full-time production DBA about 14 months ago and it has been an overwhelmingly positive move. I work for a good company...
2018-06-06
Triggers can be really useful in your database but you have to be careful with them. We often use them to record history to a separate table (at least,...
2018-05-29
3 reads
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
2 reads
Every year, I spend the Sunday after SQL Saturday Rochester scanning & processing raffle tickets for our wonderful sponsors. Here’s how the system works:
Attendees get tickets (one ticket per...
2018-04-10
3 reads
A couple weeks ago Carlos L. Cachon (blog|twitter) put out a call on Twitter looking for SQL Saturday organizers to join him on the SQL Data Partners Podcast. When...
2018-03-08
This month’s T-SQL Tuesday from Aaron Bertrand gives us a choice:
Life beyond the technical in a search for what Drew with the Burdensome Name calls #sqlibrium Your own T-SQL...
2018-02-13
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
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...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
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
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; GOSee possible answers