Intertech provides expert SQL Server consulting. Our seasoned professionals, experienced in SQL 2012, 2014, and 2016 can help you:
- Understand and use new SQL Server 2016 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
