Johan Bijnens's Avatar

Johan Bijnens

@alzdba.bsky.social

Database fire fighter. Started with SQL7 ;-) Also handling SQL Server flavors in the cloud. πŸŒͺ️ You can also find me at www.sqlservercentral.com/forums/user/alzdba

36 Followers  |  63 Following  |  64 Posts  |  Joined: 19.11.2024  |  1.7525

Latest posts by alzdba.bsky.social on Bluesky

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

10.11.2025 10:37 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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

28.10.2025 13:00 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Phished accademy? :-)

28.10.2025 12:55 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

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

21.10.2025 14:04 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
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…

21.10.2025 13:15 β€” πŸ‘ 9    πŸ” 1    πŸ’¬ 1    πŸ“Œ 0

A peaceful morning today.
#NoDoorbell
#Ring
#AWS

20.10.2025 09:41 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

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.

16.10.2025 08:22 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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

15.10.2025 09:14 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
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! πŸ‘―β€β™€οΈ

14.10.2025 19:11 β€” πŸ‘ 19    πŸ” 9    πŸ’¬ 2    πŸ“Œ 4
A girl kissing a sad looking elephant on the trunk

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.

13.10.2025 07:30 β€” πŸ‘ 2    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Chrissy LeMaire - Beyond Regex: When Data Processing Needs World Knowledge  #DataPopkorn 2025
YouTube video by DataPopkorn Chrissy LeMaire - Beyond Regex: When Data Processing Needs World Knowledge #DataPopkorn 2025

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.

13.10.2025 08:49 β€” πŸ‘ 10    πŸ” 6    πŸ’¬ 0    πŸ“Œ 0
Preview
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,…

13.10.2025 13:16 β€” πŸ‘ 8    πŸ” 4    πŸ’¬ 0    πŸ“Œ 0
Preview
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

29.09.2025 08:00 β€” πŸ‘ 1    πŸ” 2    πŸ’¬ 0    πŸ“Œ 0

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

29.09.2025 08:36 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
A sticker saying You can be anything be kind in rainbow lettering on a black background

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

23.09.2025 07:43 β€” πŸ‘ 8    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Post image

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

#DonaldTrump #Escalator

24.09.2025 00:01 β€” πŸ‘ 3260    πŸ” 1037    πŸ’¬ 70    πŸ“Œ 62
DuPSUG - Dutch PowerShell User Group Created for the Dutch PowerShell User Group (DuPSUG) - a community for PowerShell enthusiasts in the Netherlands.

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/

24.09.2025 09:02 β€” πŸ‘ 3    πŸ” 3    πŸ’¬ 0    πŸ“Œ 0
Preview
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...

09.09.2025 07:59 β€” πŸ‘ 2    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0

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

09.09.2025 08:27 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

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

08.09.2025 05:35 β€” πŸ‘ 9    πŸ” 3    πŸ’¬ 1    πŸ“Œ 0

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

12.08.2025 07:23 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

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

18.06.2025 11:00 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

Very annoying that you have to click '...' to see the attribute length
#DesignSchema #SQLServer
#VSCode

12.06.2025 09:11 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

Did someone forget to use the correct ICON for #SSMS with #SSMS21 ?

10.06.2025 09:16 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Still missing TF: fix performance issues since (2017) 2019

20.05.2025 12:32 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@koenv.bsky.social Looking for this or alike?

19.05.2025 13:39 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

#Congrats Ann Telnaes!
www.pulitzer.org/winners/22684

06.05.2025 07:07 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

using firefox the page doesn't load.
( following the link on your blog page. Blog page is ok, clicking "download" results in a page than doesn't load )
copying that url and load it in Edge did complete the load.

05.05.2025 18:52 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

In the meantime I have been able do download it via your email
#ThankYou

05.05.2025 14:39 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

Using the latest Firefox it still does not work.
Using Edge I get

05.05.2025 14:38 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

@alzdba is following 20 prominent accounts