SQL Server Services
SQL Health Check
A complete review of your server. This review is essential uncover issues that could be causing performance issues or preventing you from fully leveraging the power of SQL Server. Similar to formula race cars, an out of the box install of SQL server will get you most of what you want, that is if you are standing up this server for Dev & Test.
A health check will review all the server settings and report and recommend all the tweaks you should perform in order to push out ahead of standard performance. For more information and added benefits click below.
Database tuning
Database tuning is Step 3 of 3 of our first 90 days with you. As outlined in our health check, this is a full review of your server for missing or incorrectly configured settings both on the SQL and Windows server. The final step to fully optimized is to review your server on a database level.
This review will look at many items that could be performance hits that are costing you. Our scripts and method for review are thoroughly tested and guaranteed for results and precision. Click below for more information and details.
Installation and Configuration
Save time and money by having us install and configure your new server. Missed settings and improper configurations can cost time and money in getting your next project up and running.
If you are migrating from previous versions, you may want us to review and report and issues that will have compatibility problems. If you are a critical workload, you definitely want us to stress test your new server to ensure smooth transitions.
SQL replication
SQL replication comes in many flavors. From High Availability ( HA) to the classic log shipping.
SQL monitoring
We do provide a lightweight monitoring tool at no cost. But generally, after we perform our 3 step cleanup, your server should be well out of dev and test and therefore a monitoring tools is just icing on the cake.
Power BI
Again, our experience we bring to the table will save you years of Dev & Test when implementing an analytics solution in your shop.
Data warehousing
Wow. We love data warehousing. Do you have piles of data just sitting around that needs to get organized? We love to organize, and we have tips and tricks that will help keep even the most complex projects organized.
F.A.Q.
No, a health check is a series of scripts and snapshots to show settings and metrics.
Usually, it takes 3 days to collect and compile your reports.
Phase I, we will do a health check and work through those issues.
Phase II, we will install scripts and jobs that will perform the proper housekeeping chores.
After Phase I, Health check and Phase II, basic housekeeping chores are in-place, we will begin fine tuning your databases with weekly meetings and upgrades. Usually this runs for the next 3 months.