--- title: "#database-administrator articles | Hashnode" description: "Explore 31 articles tagged #database-administrator on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/database-administrator" --- Tag # #database-administrator 31 posts · 0 followers [Tech Vidya](https://hashnode.com/@techvidya0726) · [Aug 28](https://hashnode.com/posts/sql-server-performance-tuning/6a91b84bec3883583130cd26) ### [Sql Server Performance Tuning](https://techvidyaaim.hashnode.dev/sql-server-performance-tuning?utm_source=hashnode&utm_medium=feed) SQL Server is slow. What do you check FIRST? 2 min read · [techvidyaaim.hashnode.dev](https://techvidyaaim.hashnode.dev/sql-server-performance-tuning?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 15](https://hashnode.com/posts/sql-server-log-shipping-configuration-step-by-step/6a5798a3182c76a715942717) ### [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) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 9](https://hashnode.com/posts/ql-server-alwayson-availability-group-sync-lag-redo-fix/6a4fa29d191eb4f21ac8d74b) ### [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) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 6](https://hashnode.com/posts/sql-server-async-network-io-wait-type-fix/6a4b77811905d812dd690018) ### [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) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 1](https://hashnode.com/posts/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops/6a4559d98141cde67a842b91) ### [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) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 30](https://hashnode.com/posts/the-identity-crisis-how-to-fix-arithmetic-overflow-error-8115-and-prevent-database-crashes/6a43ebb05d7c4aa688b3d498) ### [The Identity Crisis: How to Fix Arithmetic Overflow Error 8115 and Prevent Database Crashes](https://tunedinstance.com/the-identity-crisis-how-to-fix-arithmetic-overflow-error-8115-and-prevent-database-crashes?utm_source=hashnode&utm_medium=feed) Defusing the 2-billion-row time bomb: Why auto-incrementing integer keys suddenly hit an invisible ceiling, how to audit your system limits, and how to migrate to BIGINT safely. 7 min read · [tunedinstance.com](https://tunedinstance.com/the-identity-crisis-how-to-fix-arithmetic-overflow-error-8115-and-prevent-database-crashes?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 30](https://hashnode.com/posts/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing/6a43ebc9eb3d2d20c1c66c25) ### [The Local Variable Trick: How to Stabilize Stored Procedures and Bypass Parameter Sniffing](https://tunedinstance.com/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing?utm_source=hashnode&utm_medium=feed) Tuning execution plans at the code level: Why hiding parameter values from the query optimizer stops performance spikes and creates rock-solid query consistency. 7 min read · [tunedinstance.com](https://tunedinstance.com/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 27](https://hashnode.com/posts/mass-data-imports-how-to-stop-transaction-log-bloat-during-bulk-inserts/6a40177efcbd311cf8d23c54) ### [Mass Data Imports: How to Stop Transaction Log Bloat During Bulk Inserts](https://tunedinstance.com/mass-data-imports-how-to-stop-transaction-log-bloat-during-bulk-inserts?utm_source=hashnode&utm_medium=feed) Unclogging the ETL pipeline: Why inserting millions of rows crashes your drive storage, how to unlock minimal logging, and how to load datasets at hardware line speeds. 7 min read · [tunedinstance.com](https://tunedinstance.com/mass-data-imports-how-to-stop-transaction-log-bloat-during-bulk-inserts?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 27](https://hashnode.com/posts/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions/6a4017a145aa485e4880058b) ### [SQL Server Deadlocks: How to Track Down Error 1205 and Stop Query Collisions](https://tunedinstance.com/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions?utm_source=hashnode&utm_medium=feed) Breaking the ultimate database gridlock: Why transactions violently collide, how to extract hidden XML deadlock graphs, and how to rewrite code patterns to eliminate victim states. 7 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 26](https://hashnode.com/posts/non-sargable-queries-how-function-wrapped-columns-force-full-table-scans/6a3ebcf811e9626c5e25dbe5) ### [Non-SARGable Queries: How Function-Wrapped Columns Force Full Table Scans](https://tunedinstance.com/non-sargable-queries-how-function-wrapped-columns-force-full-table-scans?utm_source=hashnode&utm_medium=feed) Unwrapping your indexes: Why passing database columns into functions kills search speeds, how to write SARGable code, and how to keep lookups lightning fast. 6 min read · [tunedinstance.com](https://tunedinstance.com/non-sargable-queries-how-function-wrapped-columns-force-full-table-scans?utm_source=hashnode&utm_medium=feed)