PROJECTS
SQL Server AlwaysOn Implementation
Client Description:
PUBLIC TRANSPORTATION AGENCY
START DATE
November 2016
END DATE
Ongoing
DESCRIPTION
For this insurance services provider, InclusiveTech upgraded their data warehouse from SQL Server 2008 R2 to SQL Server 2016. This data warehouse aggregates data from more than a dozen sources and provides real-time business intelligence. InclusiveTech performed discovery on the current environment as the architects and implementers were no longer on staff; designed the upgraded architecture (several improvements were made), and defined and implemented the cutover plan.
TECHNICAL ENVIRONMENT
Originally SQL Server 2008 R2; Windows Server 2008 (various versions). Upgraded to SQL Server 2016; Windows Server 2012R2.
TOOLS USED
Redgate. Native tools for SQL Server.
Managed Services
Client Description:
PROVIDER OF HEALTH SELF-MANAGEMENT
PROGRAMS, USED BY MAJOR HEALTH PLANS
START DATE
October 2014
END DATE
Ongoing
DESCRIPTION
For this provider of health self-management programs, InclusiveTech manages its entire IT organization, both for internal operations as well as client-facing systems. We support the software development process and conduct the software release cycle for their product.s More than 50 servers are part of the development, production, and operational environment.
TECHNICAL ENVIRONMENT
Hosted (primarily RackSpace) and on-premise servers including VMware, Hyper-V, Windows, and Linux. SQL Server, IIS, MY*sql, Tomcat, Exchange. Asterisk phone system with Polycom IP phones and video conferencing. Cisco ASA and switches/routers. Aerohive wireless. Quickbooks.
TOOLS USED
GIT, SVN, Ant, Nant, MSbuild. Python Powershell, PRTG, Solarwinds.
SQL Server Upgrade (2008 R2-2016)
Client Description:
INSURANCE SERVICES
START DATE
September 2016
END DATE
Ongoing
DESCRIPTION
For this provider of paratransit services in Los Angeles, InclusiveTech implemented a high availability database environment based on SQL ServerAlwaysOnAvailability Groups. InclusiveTech designed the HA environment, implemented it, and migrated the existing, single-server solution.
TECHNICAL ENVIRONMENT
Originally SQL Server 2012; Windows Server 2008 R2 upgraded to SQL Server 2016; Windows Server 2012 R2; Windows Failover Cluster, SQL ServerAlwaysOnAvailability Groups.
TOOLS USED
Native tools for SQL Server
PowerShell to Automate O365 password changes.
This PowerShell script is something we worked up for a large deployment moving users profiles cross forest with ADMT. Each one needed to be reset to login as ADMT does not keep those credentials. This [...]
Most Common Passwords for 2018
Spashdata released their list of most commonly used passwords recently. While I am not sure where all of this data is collected from I can say I see a number of these in the field [...]
SAAS WEB SERVICES AND DATABASE MANAGEMENT
For this provider of health self-management programs, InclusiveTech manages its entire IT organization, both for internal operations as well as client-facing systems. We support the software development process and conduct the software release cycle for their products.