Why Other People’s SQL Code Stinks

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 […]

READ MORE

What is MS SQL? Exploring Microsoft SQL

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 […]

READ MORE

Data Disruption

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: […]

READ MORE

Is it Time to Renew Your MSP?

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 […]

READ MORE

Database Administration for the Finance Industry

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 […]

READ MORE

Local Hospital With Overworked Staff

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 […]

READ MORE

How is Supporting a HIPAA Compliant Environment Different?

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 […]

READ MORE

Three Things to Protect Your Data Layer

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 – […]

READ MORE

Case Study – Performance and Tuning Engagement

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 […]

READ MORE