SSMS Presenter Mode
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...
2017-02-22
547 reads
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...
2017-02-22
547 reads
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...
2017-02-21
362 reads
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...
2017-02-20
384 reads
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...
2017-02-16
366 reads
Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...
2017-02-15
329 reads
The great thing about new versions of SQL Server is the fact that they are packed full of new features...
2017-02-13
396 reads
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...
2017-02-10 (first published: 2017-02-06)
1,298 reads
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...
2017-02-03
723 reads
Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...
2017-02-02
436 reads
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
782 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; GOSee possible answers