the On-Demand (50 Minutes) consultation and the Comprehensive Database Performance Health Check (4 Hours).
Reflections on Fireside Chat about Future of MySQL
I had the honor of participating in the Fireside Chat organized by Idera, where the discussion revolved around many different topics.
SQL SERVER – Count Occurrences of a Specific Value in a Column
Here is the exact question – How to Count Occurrences of a Specific Value in a Column? Well, honestly, the answer is very simple.
Unveiling Behavior-Driven Development (BDD): Bridging the Gap Between Business and Testing
Behavior-Driven Development connects shared examples with tests. Compare BDD and TDD, and see how a banking scenario makes outcomes observable.
Exact Vector Search Cost: Filtering Before VECTOR_DISTANCE
Measure exact vector search with VECTOR_DISTANCE, reduce candidates through indexed filters, and compare plans and measured IO.
Heap or Clustered Index: When a Heap Table Is the Right Choice
The heap or clustered index choice changes the reads of every scan. The demos measure forwarded records in a heap, a range query on both kinds of table, and the size of a nonclustered index on a wide key, and says when a heap is the right choice.
Challenges and Opportunities for DBAs in the Next 5-10 Years: How to Prepare
DBA challenges and opportunities call for skills we can practice now. I focus on recovery, performance and judgment as tools change.