Looking ahead to 2020
This week all I want to say is Happy New Year, and may 2020 be the start of a successful decade for you. Live, love, learn. Remember to take...
2020-01-01
12 reads
This week all I want to say is Happy New Year, and may 2020 be the start of a successful decade for you. Live, love, learn. Remember to take...
2020-01-01
12 reads
Long time readers will know I’m a big fan of Temporal Tables since their introduction in SQL Server 2016. Thanks to my friend Erik Darling (blog | Twitter), I...
2019-12-25
313 reads
On Twitter recently, I asked: Does anyone I know use the COMPRESS and DECOMPRESS features in T-SQL? To those who replied in the affirmative, I asked: What made you...
2019-12-18
135 reads
Here’s a list of some technical terms, acronyms, and abbreviations you may have heard, and what they mean. Some of the definitions are taken from Wikipedia. This list is...
2019-12-11
29 reads
Immutability In many programming languages, strings of text are immutable, meaning they don’t change. When you modify a string, a new string is created in memory by copying the...
2019-12-04
110 reads
TL;DR: No. A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the edit feature, that the...
2019-11-27
1 reads
A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author for a Microsoft Press...
2019-11-20
46 reads
SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned out. All the content...
2019-11-13
34 reads
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I presented this year at...
2019-11-06
3 reads
Behold! There’s a scary monster called skip-2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to any MSSQL account by...
2019-10-30
1 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...
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