Azure Managed Instances are provisioned by default with a yourname.uniqueid.databases.windows.net DNS fully qualified domain name (FQDN). Even on your private virtual network you will still have to use this...
2022-10-05 (first published: 2022-09-20)
259 reads
Today’s coping tip is to choose to see your mistakes as steps to help you learn. I preach this with the kids I coach. Mistakes will happen, but let’s...
2022-10-05
14 reads
I was reminded this week that I needed to get registered for the Data Community Summit 2022 since I’m speaking. I also needed a hotel, so I took some...
2022-10-05
35 reads
I previously wrote a post on how to convert a SQL Server Docker image to a Windows Subsystem for Linux distribution. I did this because if you tried to...
2022-10-05 (first published: 2022-09-27)
4,803 reads
Today’s coping tip is to free up time by canceling any unnecessary plans. I. Suck. At. This. I don’t like to blow things off, and I do like to...
2022-10-04
6 reads
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
11 reads
If you are like me and still prefer the physical book as your primary reading material, Benjamin Nevarez's book from Packt Publishing is a great book to add to...
2022-10-03 (first published: 2022-09-19)
395 reads
Today’s coping tip is to write down three things you appreciate about yourself. I don’t mind self-evaluation, but I struggle a bit to publicly talk about things I do...
2022-10-03
5 reads
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...
2022-10-03
19 reads
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
547 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;
GO See possible answers