Tessera
Folgen

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

71 Posts36 Follower63 Folgt
Brent Ozar@brento.bsky.social · 10mo ago

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…

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.

brentozar.com

Erin Stellato@erinstellato.bsky.social · 11mo ago

🚨 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! 👯‍♀️

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...

techcommunity.microsoft.com

Brent Ozar@brento.bsky.social · 11mo ago

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,…

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.

brentozar.com

Reitse Eskens@2meterdba.bsky.social · 11mo ago

Blog alert! A new installment in the DP-700 certification series, this time on implementing database projects. #DP700 #MicrosoftFabric #CICD #DatabaseProjects #VisualStudio #SSMS

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.

sqlreitse.com

Johan Bijnens@alzdba.bsky.social · 11mo ago

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