Modernizing Your T-SQL: The Sequence Object
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...
2020-03-10
15 reads
alevyinroc
- Website: https://flxsql.com
Modernizing Your T-SQL: The Sequence Object
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...
2020-03-10
1 reads
Appearance: Data Bits #2
Last week (as I write this), Kevin Hill (blog | twitter) released the first episode of his new podcast Data Bits. I enjoyed listening to it and said “hey...
2020-03-05
SQL Saturday Rochester 2020 Recap
Another SQL Saturday Rochester is in the books - our eighth over the past nine years. Unlike past years, I actually am going to recap the event! Ray Kim...
2020-03-03
1 reads
Does dbatools Have a Function for That?
dbatools has a lot of functions. A lot. Over 550. There is a great command index on the website, and the documentation gets updated every time a new version...
2020-02-25
Modernizing Your T-SQL: String Aggregation
This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
SQL Server 2016 gave us the STRING_SPLIT() function,...
2020-02-18
2 reads
T-SQL Tuesday #123: Lifehacks to Make Your Day Easier
This month, Jess Pomfret (blog | twitter) is trying to beat the winter motivation slump by exploring, and asking us to share, our lifehacks that make daily life a...
2020-02-11
Modernizing Your T-SQL: Splitting Strings
This is the first of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL...
2020-02-03
Modernizing Your T-SQL: Splitting Strings
This is the first of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your...
2020-02-03
7 reads
Slides & Links from SQL Saturday Cleveland
Thank you to everyone who came out to see my presentation Keys to a Healthy Relationship with SQL Server at SQL Saturday Cleveland. I had a great time and...
2020-02-02
Blogs
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
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