Database Administration
Do you ever skip the vegetables and go straight to dessert? Think of proper database administration as eating your vegetables, while the reporting and analyses are your desserts. If you ignore the proactive administration details for too long you risk data loss and compromised business health.
SQL Server Database Administration Features
SQL Server offers a range of new capabilities to protect your business from data loss, downtime, and security breaches. We can help identify server-related performance issues and assist your in-house application developers with database design and SQL programming tasks.
We are familiar with the latest features in SQL Server and can give you peace of mind that your data is safe and secure.
Database Administration Services
Business Continuity
Protecting our customers from data loss and system downtime involve server health checks, backup planning, and recovery simulation. We can guide you with Azure and other offsite backup storage. We author practical restore procedures to ensure everyone keeps a level head during a data crisis.
The pro-active measures above are the starting point. But when the RAID controller does go up in smoke, we are on-call at any hour and are on-site promptly for our Northwest Georgia customers.
Security
SQL Server offers a highly configurable mechanism for who can view and revise data. We can interview your management staff and translate your needs into a security structure. Much of the work on these tasks involves documenting the system as it relates to permissions.
Performance
A poorly performing application is demoralizing for staff. It is usually a huge productivity drain as well. We can identify performance bottlenecks when they occur on the database server and then optimize your database. This can include RAID/file segment assignment, table/index design, partitioning, stored procedure and view design, etc.
HA / Replication
We design and implement high-availability and replicated databases to ensure maximum up-time. New capabilities in SQL Server offer both redundant / failback safeguards and performance improvements.
Data Architecture
Occasionally we work with frontend application developers to design or optimize the database “backend”. This typically includes: designing table structures, writing stored procedures, user-defined functions and views.
Be Proactive, Stay Healthy
You’ve probably never associated vegetables with database servers before, but I hope the analogy drawn in these paragraphs makes you pause. Your business success depends upon the health of your data systems. Database server health is not an accident, it’s the result of deliberate, skilled and documented actions.
Does your business store critical content in a Microsoft SQL Server database? Then please sit down with your support staff and evaluate your procedures against this database backup horror story.
If you have concerns about the health of your systems, reach out to us. Preserving customer data is central to our company’s mission. We can be a resource for you.
Services Provided
Related Scenarios
Related Tools
Site Info
My goal is to help others measure, report and make sense of the data that drives their organization. Topics include: database tools, visualization techniques, open data sources and anything else that helps you apply data science.