Tag: Tech And Productivity
Simple, jargon-free overviews of useful apps, software tools, and workflows to help you work smarter—minus the tech overwhelm.
How to Determine the Last Run Time of a Stored Procedure in Microsoft SQL Server
Discovering when your stored procedure was last executed can be a game-changer for optimizing performance and troubleshooting in Microsoft SQL Server. Dive into effective techniques—ranging from using SQL Server Profiler to custom logging—that will empower you to unlock essential execution insights effortlessly!
Continue reading
Modular Development for SQL: Must-Have Best Guide
Make your SQL easier to build, reuse, and scale with modular development—using views, CTEs, stored procedures, and macros to turn complex queries into clean, manageable pieces. Discover how this approach boosts maintainability, simplifies updates, and helps teams work faster with fewer errors.
Continue reading