The following is an excerpt from Chapter 22 of Jeffrey Garbus’ book Transact SQL which can be purchased here. SQL Code reviews, are much like changing accountants! HUH? Have you ever changed accountants? The first thing the new accountant does is explain to you, in detail, how stupid your previous accountant was, how much the old […]
Jeff Garbus – CEO, Soaring Eagle Data Solutions The single most common problem I see when performing database health checks is a lack of preventive maintenance. There are a few prevalent reasons for this:– DBMS’ are frequently maintained by people other than experienced DBAs. This leads to problems due to lack of knowledge.– Owners (both […]
MS SQL Server is a fabulous product, but it does need some care and attention. We have found that many companies in today’s mid-market tier have grown faster than expected. Thus, they were very worried about their application development and security, but haven’t had the time to tend to their database and Structured Query Language […]
Problems New client had used several MSPs in the past with poor results Client tested us including test night and weekend calls Needed special SLAs and Alerting We made Mistakes! Solutions Our IP – Flight Software, made our MSP offering much more Appealing On Call Team – While we typically have a 30 minute SLA, […]
Ask these questions first! Guarantee You Are Still Getting High Tier Service What Have You Done For Me Lately? What Will You Do Tomorrow? Always the most important questions when discussing continuing with any vendor Make sure there is a clear accounting of where the time has been spent and set goals for future expectations […]
Preventative Maintenance Ensure your DR, Performance, and Data Integrity Failure to backup properly will negatively affect: Recovery Point Objectives (RPO) Recovery Time Objectives (RTO) Could prevent the ability to recover at all! Maintenance Why perform Index Maintenance? Balancing indexes improves seek and update time. Unbalanced indexes, especially when updating, can cause locking, deadlocking, and IO […]
Common Concerns PCI Compliance – Constant Audit and P.I. issues Transactions measured in microseconds – Application speed is critical to core functionality and profitability 3rd Party Software – Numerous apps that you have minimal control over Case Study Financial Services Firm With over $1 Trillion in Assets A query *MUST RUN* weekly took over 48 […]
Evaluate Health of Environment Install proper diagnosis tools Address and resolve Root Cause performance issues Address and implement ‘Best Practices” Improve Immediate and Future Performance Adjust indexes and queries for performance Tune entire environment Reduce errors Consolidate servers to reduce workload and save HUGE $$$$ on licensing costs Ready to Augment Your Team? We’re ready […]
HIPAA Requirements YOU MUST KEEP STRONGER NOTES You WILL Get AUDITED -> Be Prepared Mask ALL data Track all updates and who made the changes Data is a precious thing and will last longer than the systems themselves. Tim Berners-Lee -> Inventor of the Internet PROTECT YOUR DATA Constant security checks Roles are assigned and […]
Backup Everything And we mean EVERYTHING 01 – The Database 02 – Application Code 03 – PEOPLE! Especially those with DR and Restore capabilities Roles and Rules This one can be hard if you don’t have experience Limited Access to Production Servers – ONLY the most trusted and reliable No Changes without Q/A procedures – […]
