Apparatus
Careers | Support    (317) 254-8488 Contact Us
Consulting Managed Services Workplace Services Design Technologies About Apparatus
Apparatus SQL Server Services

Apparatus Engineers have extensive experience designing, building, and operating Microsoft SQL Server. We currently work with a wide array of clients ranging from Small to Medium-sized deployments of SQL Server Standard to Fortune 500 Enterprise clients running SQL Server Enterprise in highly available configurations distributed throughout the globe. We also have experience deploying SQL Server in a regulated environment, and are confident in making your SQL Server environment cloud ready.

We provide a full complement of SQL Server project and support services including:

Design
  • Requirements gathering
  • Solution design
  • Strategic planning
  • Scalability assessments
  • Proof-of-concept
  • Design documents
  • Architecture diagram
  • Security planning:
    Injection prevention, data Encryption, and auditing
  • Licensing
Delivery
  • Create detailed installation and configuration documentation for hardware and software platforms
  • Implementation of SQL Server Technologies:
    - SQL Server Relational Database Services, Integration Services, Analysis Services, Reporting Services
  • Integration with supplemental technologies (as needed):
  • SharePoint Technologies Project Server,  BizTalk, System Center Technologies, PerformancePoint Server
  • Configuration of Availability and High Availability features, options based on the scope of protection needed:
    - Server scope: Clustering
    - Database scope: Database Mirroring
    - Table or row scope:  Log Shipping and Replication
  • Build and deployment of SQL Server in a virtualized environment:
    Configuration of Processor Affinity /Configuration of Memory requirements / Configuration of storage allocation
  • SQL Server environment administration (services, security, configuration)
  • Preparation of Disaster Recovery plans based on:
    - High Availability Solutions, Backup / Restore strategies, and Database Snapshot
  • Management through data and table partitioning for large scale enterprise grade storage structures by using files and filegroups along with partition schemes.
  • Monitoring of SQL Server services and related technologies
  • Patching and hotfix deployments for SQL Server and related technologies
  • ETL Operations
  • Data Warehousing and OLAP configuration and performance assessment
  • Proactive monitoring of services and data
  • Resource Governor and Utility monitoring
  • Support for Spatial, FILESTREAM, and hierarchical data
  • Guidance in implementation of StreamInsight and supporting technologies
  • Integration of Business Intelligence solutions
Upgrades & Migrations
  • Upgrades from SQL Server 7.0:
    - 2005 to SQL Server 2008 to SQL Server 2008 R2.
  • Migration from Oracle, MySql, flat structures and hierarchical structures.
Credentials & Experience
  • Microsoft Certified Database Administrator
  • Microsoft Certified Technology Specialists (MCTS) in implementing and maintaining SQL Server 2005
  • Microsoft Certified Technology Specialists (MCTS) in implementing and maintaining SQL Server 2008
  • Microsoft Certified Technology Specialists (MCTS) in database development SQL Server 2008
  • Microsoft Certified Technology Specialists (MCTS) in business intelligence development and maintenance SQL Server 2005
  • Microsoft Certified Technology Specialists (MCTS) in business intelligence development and maintenance SQL Server 2008
  • Microsoft Certified IT Professional (MCITP) Database Administrator SQL Server 2005
  • Microsoft Certified IT Professional (MCITP) Database Administrator SQL Server 2008
  • Microsoft Certified IT Professional (MCITP) Database Developer SQL Server 2005
  • Microsoft Certified IT Professional (MCITP) Database Developer SQL Server 2008
  • Microsoft Certified IT Professional (MCITP) Business Intelligence Developer SQL Server 2005
  • Microsoft Certified IT Professional (MCITP) Business Intelligence Developer SQL Server 2008
  • Microsoft Certified Master: SQL Server 2008
Contact Us to Learn More

 
BizTalk
BPOS
ColdFusion
Microsoft Exchange
Firewalls
JBoss
Lamp
Linux UNIX
Load Balancers
Microsoft .Net
Oracle
Project Server
Remote Access
Micrsoft SharePoint
Microsoft SQL Server
Switching & Routing
Team Foundation Server
Tomcat
VMware
WebSphere
Microsoft Windows Server