SQL SOLVED PTY (LTD)WORKING EXPERIENCE

TECHNOLOGIES WE WORK WITH

• SQL Solved specialises in Microsoft SQL Server and depends on Windows Server and virtualisation technologies like VMWare.

• Redgate and SQLSentry serve as productivity and monitoring tools respectively.

Disclaimer:SQL Solved is not responsible for, and expressly disclaims all liability for, damages of any kind arising out of use, reference to, or reliance on any information contained with this Powerpoint Slide Show. No guarantee is given that the information provided in this slide show is correct, complete and up-to-date.

WORKING KNOWLEDGE Security & Monitoring •Security & Audits•Health Checks•Performance Monitoring

Migration & Upgrades •Migrations•High Availability & Disaster Recovery•Upgrades

Dev Ops•Software Optimisation•SQL Development•Hardware Optimisation

DEV OPS Software Optimisatio

nOptimise, Simplify &

Improve Core business processes

Track SQL code performance (duration, #runs, disk, memory)

Fix worst performers, reiterate process

Index optimisation review:• Index size, Usage stats, Too many or too few indexes, Correct search criteria?

SQL Developme

ntSoftware Development Life Cycle Adherence

Adhere to Change control policy

Hardware Optimisatio

n

Baseline server hardware

Review different CPU, RAM & Disk

configurations with Hammerdb

SECURITY & MONITORING

Security & Audits

Audits•Financial•IT Operations•Change control adherence

PCI Credit Card Accreditation•Code to search database for credit card numbers

•Credit card number encryption code (AES 256)

Health Checks

Drive space

Jobs

Windows & SQL Event logs

Database & Table Growth

SQL Performan

ceServer & SQL CPU

Page Life Expectancy & Cache Hit Ratio

Active Transactions & SQL Locks

Wait Stats per category (CPU,

Memory, Disk and Network)

MIGRATIONS & UPGRADES

Migrations

Datacenter migrations

SQL Solved perform SQL installation and configuration

Done securely, predefined timeline, seamless cutover

High Availability &

Disaster Recovery

Up-scale to High Availability SQL cluster•Secondary servers used for, BI source, secondary hot standby, index stats review

Disaster Recovery•Asynchronous commit partner•Sync Jobs, Linked Servers, Logins

Upgrades

Company wide SQL Server upgrades up until SQL

Server 2014

Business Intelligence (SQL, SSRS, SSAS, SSIS)

Production High availability cluster upgrades

Development Environments (Development, UAT,

Staging)

DTS to SSIS migration

SQL SOLVED CONTACT

 Email: thor@sqlsolved.co.za LinkedIn: https://za.linkedin.com/in/thor-van-der-merwe-5aa226a6 Phone:+27 82 410 3452 Alternatively visit: www.sqlsolved.co.za Managing Director: Thor van der Merwe

Thank you for taking an interest in SQL Solved