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 […]
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 […]
Usually, we use the term data corruption or attack to talk about data interruption issues. I am using the term Data Disruption to discuss a topic that may surprise you. Most data security issues are self-inflicted by the business’ employees. At least 40 – 50% of system outages are caused by human error, which includes: […]
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 […]
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 – […]
During a Recent Performance and Tuning Engagement One of our DBAs tuned a report that took 10 minutes down to 10 seconds At another company we took a 48 hour report to 23 SECONDS We can work REMOTELY to identify the ROOT CAUSE of your problems Contact us today to see if we can help […]
