|

Services

SQL Server Associates brings together database professionals with more than 50 years of combined experience in Business Continuity, Disaster Recovery, Performance Improvement, Business Intelligence, Process Automation, Training and Development Services.

Our Associates build enterprise class redundant database environments using Windows Server Failover Clusters, AlwaysOn Availability Groups, and Replication Technologies.

Founded in 2012, SQL Server Associates was formed from a partnership of senior level database experts. Based in the Alpharetta, Georgia area, we service the United States, and are available to travel to international locations.

 

Development

 

Assessments

SQL Server Associates' consultants will supplement your database development workload onsite or offsite from project inception to completion. SSA consultants are well versed in development best practices for SQL Server. We can assist in the implementation of source control, automated build processes as well as unit testing standards. 

The SSA architects are experts at translating the business requirements in to an enterprise database solution. With more than 50 years combined experience in database design, development and implementations in enterprise development environments the SSA architects will create an effective data model for an efficient application implementation .

 

 
 SQL Server Associates will complete a thorough assessment of your SQL Server architecture, security, performance, and configuration. The assessment will be a comprehensive analysis of your environment against industry best practices. 

Is your hardware sized correctly, do you have enough CPU and memory? Can your disk infrastructure handle the current and projected future I/O load?

Are you preparing for a data security audit? SQL Server Associates will help you prepare for your PCI DSS audit, SOC 1 report or internal security assessment.

The SSA security experts will help plan, and recommend solutions for your upcoming audit.

 Training

 Remote DBA Services

 SQL Server Associates are experienced trainers and presenters, with years of experience presenting at the Professional Association for SQL Server events such as the annual PASS Summit, PASS SQLRally and many SQL Saturdays.

SSA have training subjects including performance tuning, PowerShell training, SQL Server failover clustering, replication and advanced business continuity planning. Training in SSIS, SSAS and Business Intelligence is one of our specialties.

SSA trainers have been involved in SQL Server 2012 as authors for books as Microsoft Most Valuable Professionals.
 SQL Server database administration for a small to mid size corporation can be expensive in many circumstances. Using the SQL Server Associates remote DBA services, highly experienced DBAs are available to monitor, performance tune and ensure maintenance jobs are in place to avoid an expensive disaster recovery process. 

SSA database professionals will come into your location, complete a full assessment of the current configuration, performance and environment. They will complete a health check report detailing what the current status of the database(s) is.

 

Performance Tuning

 

Enterprise Implementations

 SSA are experts in performance tuning specializing in performance tuning and optimizations of T-SQL, analysis and modifications of configuration affecting performance. Database performance becomes increasingly important as your database gets larger and more complex and as your information management plays a bigger role in your business operations.  Installations of SQL Server, all versions and editions, following best practices with experiences with WSFC, AlwaysOn Availability Groups, Snapshot, Merge and Transactional Replication.

Satisfied Customers

   
   
   
   

 

Mike Lawell