--- title: "Rakesh Kishore (@RakeshKishore) | Hashnode" description: "Sharing a decade of database lessons, failures, and fixes. Read the latest articles by Rakesh Kishore on Hashnode." url: "https://hashnode.com/@RakeshKishore" --- @RakeshKishore # Rakesh Kishore @RakeshKishore · Hyderabad, India · Joined May 2026 Sharing a decade of database lessons, failures, and fixes. ### [SQL Server Log Shipping: Step-by-Step Configuration and Prerequisites Guide](https://tunedinstance.com/sql-server-log-shipping-configuration-step-by-step?utm_source=hashnode&utm_medium=feed) Building a resilient warm standby: A complete implementation blueprint covering folder security mappings, transaction pipeline initialization, and automated secondary staging. 5 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-log-shipping-configuration-step-by-step?utm_source=hashnode&utm_medium=feed) [1](https://hashnode.com/posts/sql-server-log-shipping-configuration-step-by-step/6a5798a3182c76a715942717) [Jul 15](https://hashnode.com/posts/sql-server-log-shipping-configuration-step-by-step/6a5798a3182c76a715942717) ### [Always On Availability Groups: How to Fix Synchronization Lag and Stop REDO Thread Starvation](https://tunedinstance.com/ql-server-alwayson-availability-group-sync-lag-redo-fix?utm_source=hashnode&utm_medium=feed) Guarding the failover perimeter: Why secondary database replicas fall behind during heavy data loads, how to trace redo queue bottlenecks, and how to optimize recovery speeds. 7 min read · [tunedinstance.com](https://tunedinstance.com/ql-server-alwayson-availability-group-sync-lag-redo-fix?utm_source=hashnode&utm_medium=feed) [Jul 9](https://hashnode.com/posts/ql-server-alwayson-availability-group-sync-lag-redo-fix/6a4fa29d191eb4f21ac8d74b) ### [The ASYNC\_NETWORK\_IO Myth: Why Your Database Is Waiting on Slow Application Code](https://tunedinstance.com/sql-server-async-network-io-wait-type-fix?utm_source=hashnode&utm_medium=feed) Unclogging the data consumption pipeline: Why the network team isn't to blame for network wait states, how data buffers choke processing threads, and how to accelerate streaming throughput. 7 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-async-network-io-wait-type-fix?utm_source=hashnode&utm_medium=feed) [Jul 6](https://hashnode.com/posts/sql-server-async-network-io-wait-type-fix/6a4b77811905d812dd690018) ### [UNION vs. UNION ALL: How Hidden Sort Operators Slow Down Your Combined Datasets](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed) Unmasking the duplicate check penalty: Why combining queries can trigger unexpected disk grinding, how to trace performance plan warnings, and when to drop the distinct filter safely. 7 min read · [tunedinstance.com](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed) [Jul 2](https://hashnode.com/posts/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets/6a45ab7eaa47703809ba593c) ### [Hidden CPU Burn: How Scalar User-Defined Functions Trap Your Queries in RBAR Loops](https://tunedinstance.com/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops?utm_source=hashnode&utm_medium=feed) Unwrapping row-by-row bottlenecks: Why modular code kills database performance, how to track hidden UDF execution penalties, and how to convert functions into high-speed inline expressions. 6 min read · [tunedinstance.com](https://tunedinstance.com/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops?utm_source=hashnode&utm_medium=feed) [Jul 1](https://hashnode.com/posts/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops/6a4559d98141cde67a842b91)