Sign in

Uwe Ricken

@sqlbambi.bsky.social
121 followers 79 following 30 posts

Data Addicted SQL Server expert. International Speaker Dad of two beautiful daughters….

PostsRepliesMedia
Uwe Ricken @sqlbambi.bsky.social · 25/08/2026
SQL Server’s Execution Phase explained with a construction‑crew analogy. See how the engine “builds” your query’s result. youtu.be/zyVl991Ga8U #SQLServer, #ExecutionEngine, #SQLChallenges, #sqlfamily
youtu.be
SQL Server Query Execution
YouTube video by Uwe Ricken
000
Uwe Ricken @sqlbambi.bsky.social · 25/08/2026
SQL Server’s Plan Cache explained with an architect analogy. See how plans are stored, reused and cleared under pressure. youtu.be/pKAEg8dIZQU #SQLServer, #PlanCache, #SQLChallenges, #sqlfamily
youtu.be
SQL Server Plan Cache
YouTube video by Uwe Ricken
000
Uwe Ricken @sqlbambi.bsky.social · 25/08/2026
SQL Server execution planning explained with a simple architect analogy. See how Parsing, Compilation and Optimization work. Great for anyone wanting clear SQL Server internals. youtu.be/bKhPq_Z5GdQ #SQLServer, #ExecutionPlan, #SQLChallenges
youtu.be
SQL Server Execution Planning
YouTube video by Uwe Ricken
000
Uwe Ricken @sqlbambi.bsky.social · 25/08/2026
SQL Server’s Task Queue explained with a fun Dance Club analogy. See how worker threads, scheduling and waiting tasks act like people lining up outside a club. Perfect for juniors, managers and consultants. youtu.be/iSqkAIFsdNk #SQLServer, #TaskQueue, #SQLChallenges
youtu.be
The SQL Server Task Queue
YouTube video by Uwe Ricken
000
Uwe Ricken @sqlbambi.bsky.social · 22/08/2026
You want to know more about the creation of an Execution Plan in Microsoft SQL Server? I'm using Analogies to keep it simple. youtu.be/bKhPq_Z5GdQ
youtu.be
SQL Server Execution Planning
YouTube video by Uwe Ricken
010
Uwe Ricken @sqlbambi.bsky.social · 22/08/2026
The next video in my SQL Server internals series is now live. What does an architect and his archive have in common with the SQL Server Plan Cache? Thanks again to everyone who supported the previous videos. Your feedback and engagement keep this project moving forward. youtu.be/pKAEg8dIZQU
youtu.be
SQL Server Plan Cache
YouTube video by Uwe Ricken
010
Reposted by Uwe Ricken
Chrissy LeMaire @funbucket.dev · 20/01/2025
For those of you looking to avoid the news today, check out @mutesky.app, which mutes political and distressing keywords. Temporarily set it to Complete filtering which adds about 1500 mute keywords. Performance will be impacted a bit but worth it. After the hubbub, set it back to Minimal.
mutesky.app
MuteSky — Mute in Bulk on Bluesky
MuteSky helps you efficiently manage your Bluesky experience by providing powerful bulk muting capabilities. Filter your feed, manage content, and customize your experience with ease.
63113
Uwe Ricken @sqlbambi.bsky.social · 06/01/2025
You work with partitioning and know the advantages of this technology? You use this technology in DWH to improve workloads or in OLTP to optimize scaling? It should be avoided or optimized for a specific type of workload. www.db-berater.de/2025/01/is-s... #sqlserver #partitioning #optimization
db-berater.de
Is SWITCH PARTITION a bad idea?
How can SWITCH PARTITION be a bad idea? Do you work with partitioning and know the many advantages that this technology offers? Do you use this technology in DW
010
Uwe Ricken @sqlbambi.bsky.social · 30/12/2024
Trust me, DBCC FREEPROCCACHE is definitely NOT executed every time an INDEX REBUILD is performed. This doesn't get any more true than some well-known SQL Server "expert" says. The plan cache is not even touched! #sqlfamily #sqlserver #fail
100
Uwe Ricken @sqlbambi.bsky.social · 12/12/2024
You often read on social networks that a DBA’s job is to optimize databases, among other things. I think that’s a misinterpretation of the – important – role of a DBA. #sqlfamily #sqlserver www.db-berater.de/2024/12/the-...
db-berater.de
The role of a DBA is NOT Tuning but Operations
You often read on social networks that a DBA's job is to optimize databases, among other things. I think that's a misinterpretation of the - important - role of
430
Uwe Ricken @sqlbambi.bsky.social · 09/12/2024
Do you know that Foreign Key Constraints can help to improve your queries? JOIN Elimination is a technique which might be useful in high transactional OLTP systems. #sqlfamily #sqlserver www.db-berater.de/2024/12/fore...
db-berater.de
Foreign Key Constraints - JOIN Elimination
JOIN Elimination in Microsoft SQL Server is an optimization technique with foreign key constraints where the query engine removes redundant JOIN operations duri
030
Uwe Ricken @sqlbambi.bsky.social · 26/11/2024
Me, when tuning was successful. jealous of my wife. She’s in Norway for whale watching. Awesome! #sqlfamily
170
Uwe Ricken @sqlbambi.bsky.social · 25/11/2024
Database don't need Foreign Key constraint; the application is taking care of it. Standard arguments are: - to slow - limit my handling of data I took the time to run a few tests with and without Foreign Key Constraints. Surprising results... www.db-berater.de/2024/11/use-... #sqlfamily #sqlserver
db-berater.de
Use Foreign Key Constraints in your Databases - Part I
When revising one of my popular sessions on scenarios in which indexes no longer help, one of the topics covered was foreign key constraints for data integrity
062
Uwe Ricken @sqlbambi.bsky.social · 24/11/2024
Are you using the correct data types for parameters in your queries? If not, you should know what consequences this can have. #sqlserver #sqlfamily www.db-berater.de/2024/11/cons...
db-berater.de
Consider the correct data type in queries
Although an index should provide a fast query, Microsoft SQL Server either does not want to use that index at all or does not want to use it optimally. The caus
081
Uwe Ricken @sqlbambi.bsky.social · 24/11/2024
is it possible to filter on [attach_activity_id_seq] = 0 when i create an xevent? Example: CREATE EVENT SESSION ... WHERE attach_activity_id_seq = 1 #sqlhelp #sqlserver #sqlfamily
010
Uwe Ricken @sqlbambi.bsky.social · 23/11/2024
Hey SQL experts, don’t use ISNULL() to search in your tables. You can do it better, don’t you? www.db-berater.de/2024/11/isnu... #sqlserver #sqlfamily
db-berater.de
ISNULL() and SARGable queries
Database developers like to use the ISNULL() function to check two conditions and compare them with a search value. This is often done with the intention of fin
241
Uwe Ricken @sqlbambi.bsky.social · 21/11/2024
Why not in Germany, too? www.spiegel.de/auto/italien...
spiegel.de
Neue Straßenverkehrsordnung in Italien: Handy am Steuer, 1000 Euro
Wer in Italien am Lenkrad mit dem Mobiltelefon hantiert, muss künftig mit drastischen Strafen rechnen. Auch Fahrern, die ihr Auto unter Alkohol- oder Drogeneinfluss steuern, drohen deutlich härtere Ko...
000
Uwe Ricken @sqlbambi.bsky.social · 20/11/2024
Unit Tests / Demos - do you need a random key value from a large table very quick? Optimize the process significantly... www.db-berater.de/2024/11/opti... #sqlserver #sqlfamily
db-berater.de
Optimize search for a random key value from a table
Unit tests/demos in workshops and conference sessions sometimes require a random key value from an existing table. In this article I present a solution that acc
000
Uwe Ricken @sqlbambi.bsky.social · 19/11/2024
Although my workshop is at the #sqlkonferenz in February, I'm already preparing the labs. I'm wondering if it won't be more of a comedy event. So many bad examples that I've collected over the years suggest a lot of fun. #sqlserver #performance #tuning #sql #sqlfamily
160
Uwe Ricken @sqlbambi.bsky.social · 19/11/2024
Don’t let the asterisk (*) make you think it has the same use as in "SELECT *" statement. NO! COUNT(*) will not go through the whole table before returning the number of rows, making itself slower than COUNT(1)! #sqlserver #Performance #SQL #sqlfamily
020
Uwe Ricken @sqlbambi.bsky.social · 19/11/2024
Note! If your SQL Server is suffering from "Tempdb Latch Contention" is is NEVER a problem of SQL Server! It's your application! Want to learn more about it? In February 2025 I will be doing a workshop at #sqlkonferenz in Hanau (Germany). sqlkonferenz.de/precon-works... #sqlserver
030
Uwe Ricken @sqlbambi.bsky.social · 18/11/2024
I like database gurus who immediately recognize that databases have nothing to do with normalization. Why else would you allow up to 2 GB for a phone number, for example? #sqlserver #rdbms #development #EF
010
Uwe Ricken @sqlbambi.bsky.social · 18/11/2024
I wonder why so many people ask silly SQL Server quiz questions on LinkedIn. What is the point of this nonsense? Can you win something? (asking for a friend). #sqlserver #dataplatform
020
Uwe Ricken @sqlbambi.bsky.social · 17/11/2024
Dear community, moved from Twitter (@dbberater) to BlueSky. I hope that things are more civilized and respectful here. I look forward to interesting tweets and a friendly exchange with followers and those I follow.
480