Some databases may show a NULL collation in the sys.databases DMV
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the...
2018-12-12
221 reads
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the...
2018-12-12
221 reads
My friend Michael J. Swart has a rule of thumb he calls Swart’s Ten Percent Rule. If you’re using over...
2018-12-05
207 reads
On 1 December 2018, Microsoft is increasing Azure subscription prices in Canadian dollars by 5%. The following is taken directly...
2018-11-28
234 reads
Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see...
2018-11-21
369 reads
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
235 reads
This scheduled post is coming to you from Seattle, where the PASS Summit 2018 has just kicked off. Because it...
2018-11-07
188 reads
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
497 reads
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
224 reads
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
290 reads
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....
2018-10-10
313 reads
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