Database Fundamentals #17: Learning T-SQL
While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the...
2018-06-18
952 reads
While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the...
2018-06-18
952 reads
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...
2018-06-11 (first published: 2018-05-29)
2,143 reads
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...
2018-06-07
267 reads
I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...
2018-06-04
356 reads
In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...
2018-05-21
704 reads
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,573 reads
Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...
2018-05-14
304 reads
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
228 reads
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,933 reads
Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...
2018-04-27
467 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
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...
Hi everyone My SSIS package does a bulk insert of csv files into a...
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
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