by Grahame Dyce | Mar 24, 2020 | Data, Grahame Dyce
5 Benefits of Performance Tuning and Optimising Your Database Does it seem like there is never enough time to optimise and tune your database? Perhaps it is slipping down your to-do list for that elusive moment when you’ve got enough time to take a step back from the...
by Grahame Dyce | Oct 30, 2018 | Data, Grahame Dyce, SQL Server
General Architecture Planning Network Service Accounts Server Admin Accounts Servers Failover Cluster Storage (Disks) As a Senior Database Consultant with over 20 years experience I’ve configured Always On more times than I can count and I find myself making the...
by Grahame Dyce | Sep 6, 2018 | Data, Grahame Dyce, Oracle
This simple two-part procedure will help to diagnose and fix the most common sqlnet and tnsnames configuration problems. TEST COMMUNICATION BETWEEN THE CLIENT AND THE LISTENER We will use tnsping to complete this step. It’s a common misconception...