Consulting Training Blog Careers About Us Contact Us
All Classes Will Be Held Virtually – Live Online Intertech's Training Division has been successfully instructing professionals through virtual live online training since the advent of the smartboard. It is a proven form and offers the convenience of live questions, group interaction, and labs with an instructor looking over your shoulder. Because of this, we will continue all classes live but virtually, including Agile and Scrum instruction, so businesses and individual’s seeking professional development can keep moving forward during these unexpected times.

SQL Server Consulting

Discuss Project

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

Free One Hour Discovery Call?

Learn More About the Intertech Consulting Team

Free Resources

5 Common Mistakes on Software Engineering

Guide to Selecting & Working with an IT Consulting Firm

Guide to Becoming a Full Stack Developer

Meet Our Dev Center

Making any outsourced project work affordable

Recent Case Studies

Migrates Mortgage Services Firm's Customer Service Application

Identify an electronics component based on an image to lookup replacement parts

Redesigning the User Experience of a National Commodities Contracts Platform

Free One Hour Discovery Call?


Intertech impresses me as a company. I would recommend the individuals I have worked with and indeed the company as a whole because one can tell the results we have gotten are a combination of the company’s culture and the individuals capabilities.

Brian B