Like timber floating downstream, log shipping moves logs from one server to another. Here is how to read the Transaction Log Shipping Status report in SSMS.
Scalar UDF Inlining: When Old Functions Suddenly Get Fast
Check scalar UDF inlining eligibility, database settings, function options, and execution plans before claiming a performance improvement.
SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038
Andy explains isolation in processes, a basic RDBMS idea, with fresh eggs from his family’s chickens. A fun way to learn the fundamentals.
Top Resource Consumers in Query Store
Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.
Object Dependencies in SSMS: SQL in Sixty Seconds #071
Object Dependencies in SSMS shows the references recorded in SQL Server metadata. This post adds T-SQL queries for both directions, tested on SQL Server 2025, and shows what the dialog cannot see: dynamic SQL, other databases and a table dropped under a view.
Getting Your Employer to Pay for Training
Ask your employer to pay for training with a short proposal that ties the course to work, shows cost, and shares the result with the team.
SQL SERVER – SSMS: Activity – All Blocking Transactions
Bengaluru traffic after a rainy day has a lot in common with blocked queries. I look at the All Blocking Transactions report in SSMS and what it shows.