Then:

-- 4. Restart SQL Server service for changes to take effect

then
-- 2. Drop the old server name entry
EXEC sp_dropserver 'servername'; -- use the OLD short name currently in @@SERVERNAME

-- 3. Add it back with the fully qualified name
EXEC sp_addserver 'servername.location.com', 'local';

Did you try:
-- 1. First, verify the mismatch
SELECT @@SERVERNAME AS [@@SERVERNAME],
SERVERPROPERTY('ServerName') AS [SERVERPROPERTY]

SQL Server 2025 REGEXP_MATCHES Function to Extract Multiple Substrings Learn how to use SQL REGEXP_MATCHES to extract multiple substrings efficiently without loops or cursors in SQL Server 2025.

New article: #SQLServer2025 REGEXP_MATCHES Function to Extract Multiple Substrings #regex #tsql www.mssqltips.com/sqlservertip...

Anyone having issues with #SQLServer 2019 on #WindowsServer2025 (standard edtn)
#SQLHelp

Yes it is!

Department S - Is Vic There?
soundcloud.com/department-s...
#EarWorm

When you download #SQLServer 2025 RTM Std&Dev Edtn, by default it uses #PID "33333-00000-00000-00000-00000"
Is that actually Dev Edtn with only Std features ?
#SQLHelp

Most ( if not all ) of us becoming old farts by now
#MayTheFartBeWithYou

Replacing another #3PAR node.
Hoping it finally works as designed, promissed and guaranteed bij HPE.
#TheoryVSPractice
#SalesVsFieldEngeneers

Phished accademy? :-)

and (original) DBMirroring still works ! ( and in our cases outperforms AG's )
#YMMV

TempDB Filling Up? Try Resource Governor. TempDB is one of the banes of my existence. Anybody, anybody who can query your server can run a denial-of-service attack in a matter of seconds just by filling it up with a simple query: DROP TABLE IF EXISTS #big_problem; CREATE TABLE #big_problem (filler VARCHAR(8000)); WHILE 1 = 1 INSERT INTO #big_problem SELECT REPLICATE('X', 8000) FROM GENERATE_SERIES(1, 100000); This while loop will gradually fill up TempDB, and when one of the attempts eventually fails, that's okay because the session stays open.

TempDB Filling Up? Try Resource Governor.

TempDB is one of the banes of my existence. Anybody, anybody who can query your server can run a denial-of-service attack in a matter of seconds just by filling it up with a simple query: DROP TABLE IF EXISTS #big_problem; CREATE TABLE #big_problem (filler…

A peaceful morning today.
#NoDoorbell
#Ring
#AWS

As you know, DEVs will be tempted to just use it because "MS knows what they are doing".
Hence my concerns.
How many db have we seen with dozens of indexes still having their "index recommendation" name.

Is this #QueryHintRecommendationTool like the index recommendations?
Isn't #SSMS pushing people into bad practices using hints?

Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub The SSMS team is delighted to announce the release of SQL Server Management Studio (SSMS) 22 Preview 3. This latest preview is chock full of exiting new...

🚨 It's another two-for-Tuesday over in the SSMS team!

Announcing the release of SSMS 22 Preview 3 and SSMS 21.6!

SSMS 22 Preview 3 includes:

- GitHub Copilot in SSMS

- ARM64 support for core SSMS scenarios

Start with Makena's post: techcommunity.microsoft.com/blog/sqlserv...

Enjoy! 👯‍♀️

A girl kissing a sad looking elephant on the trunk

Be kind, for everyone you meet is fighting a hard battle.
Your kindness can be someone's light.

Chrissy LeMaire - Beyond Regex: When Data Processing Needs World Knowledge #DataPopkorn 2025 YouTube video by DataPopkorn

Check out my PowerShell session at @datapopkorn.bsky.social! This tutorial shows you how to use local models to answer questions like "Is Beverly Hills part of Los Angeles" with a simple true or false.

Announcing Free MASTERING Week 2025! You’ve been working with SQL Server, Azure SQL DB, or Amazon RDS SQL Server for years. You’re jaded. You’re confident. You’re pretty sure you know what you’re doing. You’ve never taken my Mastering classes because you’ve read the blog, watched the live streams, and figured you’ve pieced it all together. You can’t imagine there’s anything left to learn — no surprises left in the box.

Announcing Free MASTERING Week 2025!

You’ve been working with SQL Server, Azure SQL DB, or Amazon RDS SQL Server for years. You’re jaded. You’re confident. You’re pretty sure you know what you’re doing. You’ve never taken my Mastering classes because you’ve read the blog, watched the live streams,…

DP-700 training: implement database projects Some of you might recognise database projects from either Synapse Analytics or SQL Server. Yay for the latter ;). A long story, very short, database projects are a way to develop and deploy your databases using a CI/CD (Continuous Integration/Continuous Development) approach. For each database, the code you've written is saved in a specific project file and when you need to deploy a database, you don't have to go find all the scripts from the database that's running, but all you need is (yes love, that too) the project file that should be up to date with the latest code.

Blog alert!

A new installment in the DP-700 certification series, this time on implementing database projects.

#DP700
#MicrosoftFabric
#CICD
#DatabaseProjects
#VisualStudio
#SSMS

If anything I want AI to do, it is generating an application ... it still cannot generate a powerbi app based on a provided ddl. All it does is giving me a nice HowTo and the advised steps to keep in mind.
Draw me a nice picture, right

A sticker saying You can be anything be kind in rainbow lettering on a black background

"Well, there's your problem..."

#DonaldTrump #Escalator

DuPSUG is back! 🎤

We're hosting our first edition of 2025 in Leusden at Rubicon, read about it on our new site and sign up to reserve your seat!

#PowerShell #DuPSUG #DevOps
dupsug.github.io/dupsugsite/

SQL Server 2025 REGEXP_COUNT Function to Count Occurrences in Text Learn about the SQL Server 2025 REGEXP_COUNT function and how this could be used in SQL queries to count occurrences in text.

New article: #SQLServer2025 REGEXP_COUNT Function to Count Occurrences in Text www.mssqltips.com/sqlservertip...

So sad to read this ...
#RIP Andrew Clarke a.k.a. #PhilFactor
www.red-gate.com/simple-talk/...

A kind word can make someone’s day.
Be the reason someone believes in the goodness of people.

How to consume a large #sqlserver stored procedure resultset with #Databricks?
Is this product mature enough to handle this?

Why can't #SSMS21 open a solution/project whilst a query is executing?
#sqlhelp
#SSMS