SQL Server Consulting

Intertech provides expert consulting on SQL Server.  Our seasoned professionals can help you:

• Understand and use new SQL Server 2012 enhancements including new offerings and features in availability, scalability, performance, manageability, security, and programmability
• Select, install, and configure the correct SQL Server edition for your environment including Enterprise, Standard, and Business Intelligence (BI) versions
• Upgrade and migrate from previous versions of SQL Server
• Migrate from different database platforms including Oracle and IBM DB2
• Understand and leverage SQL Server AlwaysOn including AlwaysOn Availability Groups, Active Secondaries, and AlwaysOn Failover Cluster Instances
• Correctly use Server Message Block and Database Recovery Advisor
• Define and implement a plan for and upgrade and patch management
• Use Columnstore Index including creating a Columnstore Index by Using SQL Server Management Studio and creating a Columnstore Index Using Transact-SQL
• Understand and leverage security including default schema for groups and user defined roles, contained databases, record filtering, and user-defined audit events
• Configure semantic search
• Understand SQL Server Integration services (SSIS) including using the toolbox, shared connection managers, data flow, Change Data Capture (CDC) as well as  packages design using expressions and variables
• Understand SQL Server Analysis Services (SSAS) and PowerPivot including the Server Modes, Analysis Services Projects, Tabular Modeling, Multidimensional Model Storage and Server Management. 
• Understand SQL Server Reporting Services (SSRS) including Power View’s data sources, design environment, data visualization as well as use sort order, filters, and multiple views to clearly represent data
• Implement and administer Data Quality Services for cleansing and mataching by leveraging Data Quality Server and Client
• Understand and use Master Data Manager including explorer, integration management, and user and group permissions
• Integrate and use SQL Server with SharePoint and Windows PowerShell
• Leverage and use PowerPivot for Excel and SharePoint
• Use Data Alerts including leveraging the Data Alert Designer and Manager
• Perform an exhaustive SQL Server security audit
• Target SQL Server performance issues