Migrating SQL Server to the Cloud: Checklist

Migrating SQL Server to the cloud needs planning so we have put together a checklist for you to consider. The beauty of SQL Server is that it plays well in all cloud environments. If you prepare the environment for security, accessibility, and performance prior to going to the cloud you will save money. Fixing these […]

READ MORE

How to Choose a Cloud Service Provider

Remember the first computer you ever used? Back in the early days, it was common to store information on diskettes. Walking around with one made us feel a bit futuristic. Today, those disks are as anachronistic as pay phones. When you run a business, or your job entails sending and receiving significant amounts of data, […]

READ MORE

Don’t Be Afraid of Database Preventive Maintenance

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

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

What Are The Effects Of Not Maintaining Your Data Environment?

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

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