A guide on integrating PostgreSQL stored procedures and functions with EF Core for complex queries and performance-critical operations.
Explains how to call stored procedures with default parameters using jOOQ and JDBC, covering syntax for Oracle, PostgreSQL, and other databases.
A guide on using jOOQ and Testcontainers to write integration tests for database stored procedures in Java, replacing manual JDBC calls.
Explains how to use jOOQ to call stored procedures from Java, highlighting benefits over raw JDBC for type safety and maintainability.
A guide to writing Azure Cosmos DB stored procedures in TypeScript using async/await by wrapping the callback-based JavaScript API.
Guide to batch inserting data into Azure Cosmos DB using Python and stored procedures, addressing SDK limitations and common errors.
Explores Microsoft's new Columnstore compression estimation in SQL Server 2019, comparing it to a custom system stored procedure.
Explains when to use temporary tables instead of table variables in SQL Server for significant query performance improvements.
Explains a behavioral change in sp_executesql between SQL Server 2005 and 2008 when executing parameterized stored procedure calls.
Explains how to use the SP:StmtCompleted SQL Profiler event to identify slow individual statements within a stored procedure.
Compares three methods for passing multiple IDs to a SQL Server stored procedure: CSV lists, XML, and Table Valued Parameters.
A blog recommendation for posts covering Entity Framework errors, stored procedures, and dynamic LINQ queries with expression trees.
