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.

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

YouTube video by DataPopkorn

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.

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.

Created for the Dutch PowerShell User Group (DuPSUG) - a community for PowerShell enthusiasts in the Netherlands.

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