#PerformanceTuning
I am currently looking for a new project. If you have a project that needs my skill set, or know someone who does, please reach out. I'd love to connect!
#SQLFamily #SQLServer #SQL #Data #AzureSQLServer #Azure #MicrosoftFabric #Fabric #Analytics #PerformanceTuning #AI #MVP #MicrosoftMVP #DataPlaform
November 2, 2026 at 8:01 AM
Running vector search directly alongside core business transactions can quickly degrade performance.

CYBERTEC helps tune database configurations so AI queries execute fast while operational workloads stay stable.

#PostgreSQL #CYBERTEC #PerformanceTuning #TechOps
November 4, 2026 at 8:49 AM
every UPDATE writes a new row version, and usually a new entry in every index. unless it's a HOT update: no indexed column changed and the new version fits on the same page. then the indexes don't get touched at all. fillfactor is how you leave that room.
#PostgreSQL #PerformanceTuning #databases
October 19, 2026 at 5:02 PM
Storage latency can easily bottleneck application performance.

PostgreSQL Asynchronous I/O capabilities boost read throughput under heavy concurrency, keeping system backends responsive.

#PostgreSQL #PerformanceTuning #DevOps #DataOps #TechStrategy
September 29, 2026 at 11:01 AM
A slow database query doesn't always need a bigger instance. Adding an index can make a query almost 300 times faster! #DatabaseOptimization #Indexing #PerformanceTuning 🐘🔍
Why Is My SQL Query Slow? Check These 3 Causes First
Why is my SQL query slow? Watch EXPLAIN ANALYZE turn a million-row scan into ten block reads with one index, and count an N+1 loop in the act.
kodekloud.com
September 24, 2026 at 10:39 PM
Don't let runaway queries fry your CPUs. ⚡️

Catch long-running sessions and blocking locks early so DBAs can act before app response times drop. Our team at CYBERTEC uses proactive monitoring to keep Postgres pools running smooth.

#PostgreSQL #PerformanceTuning #DevOps #DataOps
September 4, 2026 at 12:43 PM
August 27, 2026 at 4:01 PM
I started surveying hundreds of Ecommerce sites via PageSpeed Insights, and found...

...well, the simulated findings are almost useless predictors of how real shoppers experience your site.

lnkd.in/p/g3gYabdE
#pagespeedinsights #ecommerce #shopify #performancetuning | Roy Steves
PageSpeed Insights tuning is like a game to me, but after I pulled a few hundred Ecommerce sites' data from it, the simulated reports don't correlate with the Core Web Vitals real user measurements on...
lnkd.in
August 25, 2026 at 6:38 PM
A PGConf presentation showed that properly tuned PostgreSQL can outperform Oracle at scale for a fraction of the licensing cost. The usual bottlenecks were checkpoint tuning, parallel query settings, and WAL configuration rather than raw hardware. #PostgreSQL #Database #PerformanceTuning
August 20, 2026 at 3:06 AM
This month, I have the honor of hosting T-SQL Tuesday #201, and I picked a topic that comes up on almost every client engagement I do: temp tables in tempdb. Should you use them?

www.jefftaylor.io/post/t-sql-t...

#tsql2sday #SQLServer #tempdb #performancetuning #performance
August 4, 2026 at 4:02 AM
I am honored to have been selected to speak at SQL Saturday Boston. Join me for my session on tuning multi-terabyte databases! sqlsaturday.com/2025-09-27-s...

#SQLSaturday #SQLServer #SQL #Azure #PerformanceTuning #Performance #Terabyte #LargeDatabases #VLDB #SQLSatBoston @sqlsatboston.bsky.social
August 4, 2025 at 6:16 AM
I'm happy to announce that two of my sessions were accepted for SQL Saturday Orlando! Come join us on October 4th, 2025! sqlsaturday.com/2025-10-04-s...

#SQLSaturday #SQLServer #SQL #Azure #ADF #AzureDataFactory #PerformanceTuning #Performance #Terabyte #LargeDatabases #VLDB #SQLSatOrlando
August 4, 2025 at 3:51 AM
June 18, 2025 at 5:02 AM
June 17, 2025 at 9:28 PM
Due to recent corporate direction changes from tariffs, my current project was halted. I'm now available for contract work immediately!

If you have a project or know of one, please reach out.

#SQLFamily #SQLServer #SQL #Data #Azure #MicrosoftFabric #Fabric #Analytics #PerformanceTuning
April 4, 2025 at 7:26 PM
#QueryFolding is a very important concept when it comes to #PerformanceTuning of #PowerBI and #PowerQuery solution

In today's video, I explained what it is and how it is important, using a demo

Watch the video here:

youtu.be/OAoWet1NmeM
Power BI Performance Tip Query Folding in Power Query
YouTube video by RADACAD
youtu.be
September 30, 2025 at 5:18 PM
Today, In part 5 of #Aggregation set up in #PowerBI in the #PerformanceTuning series, I talked about how to set up multiple layers of aggregations.

watch the video here:

youtu.be/8HMQTPtDKKQ

#Analytics #DataAnalytics #BusinessIntelligence #BigData #MicrosoftFabric #Microsoft #Fabric #Performance
Power BI Performance Tuning Aggregations Multiple Layers Part 5
YouTube video by RADACAD
youtu.be
February 21, 2025 at 4:47 AM
Today in the 4th video of the #PowerBI #PerformanceTuning #Series

I explained how #AggregationAwareness works in Power BI and how to set up and manage aggregation. Then, I tested the process of querying data from the aggregated table.

Watch the video here:

youtu.be/RCGllABm7HM
Power BI Performance Tuning Part 4 Aggregation Awareness
YouTube video by RADACAD
youtu.be
February 11, 2025 at 3:29 AM