Sql dba
We have a well equipped consulting team with production server experience of more than 20 years in SQL Server tools.
The SQL Server Professionals are certified in SQL Server Development and Administration.
Our sql dba offerings
Server consultancy
- Auditing of Servers
- Best Practices Implementation
- Optimize Installation and Configuration of H/W, O/S, Database Engine
- Code Reviews
- Performance Optimization
- Trouble Shooting
- Error Fixing
- Debugging
- Documentation
- Feature Implementation
- Tips and Tricks etc.
Server administration
- H/W configuration, O/S configuration, SQL Server Configuration for Optimization
- Auditing of existing Server,
- User Authorization and Authentication (Login, Database user, Role) , Access ( Grant, Revoke, Deny),
- Optimum Placing of files (mdf,ldf), tempdb placement, Use of appropriate RAID, database file size optimization ( initial size, incremental size),
- Policy based management, auditing
- Index de-fragmentation ( reorganize, rebuild)
- Backup and Restore, Report tools
- Central management Server, Registered Servers
- Clustering, Always-on, Replication, Mirroring, Log Shipping.
- Performance Monitoring & Tuning (Profiler, Extended Events, Performance Monitor)
- Infrastructure Purchase
- General Check includes auditing of the existing server
- Trouble Shooting
- Health Check
- Remote DBA Service
- Advanced T-SQL Development Service
- Stored Procedure optimization, Index Auditing, Fixing Index Issues , Execution plan analysis , wait analysis
- High Availability and Disaster Recovery
- Feature Implementation like CDC, Encrypt database, Resource Governor, Always-on, Clustering, Policies, Extended Events, Memory OLTP, Columnar Indexing, Compression , Import /Export etc.
Development
- Normalization, Entities, Attributes, Data Modeling (Logical and Physical),
- Table Creation, Constraints( Check, Unique, Default, Foreign Key) , Appropriate data types,
- Indexes (Clustered, Non Clustered, Filtered, Include, Columnar)
- T-SQL Development : Select, Joins (Inner, Outer, Full, Cross) , GROUP BY,ORDER BY,UNION,INTERSECT,EXCEPT,CROSS APPLY,OUTER APPLY
- Predicates (Sargable & NON Sargable), Conditional (IF … ELSE, CASE), Looping ( While)
- Locks ( Blocking and Deadlocks), Transaction Isolation levels ,
- RANKING Functions , CDC, Change Tracking, Auditing, XML, Execution plan analysis
- Tracing and Extended Events
- Optimized Code Development delivering right code first time and all the time ,
- Memory OLTP, Columnar Index, Temporal Tables, Row level Security, Encrypt Database, Query Cost, Query Statistics, Stretch Database
- DO’s and DONT’s, Tips and Tricks SSMS configuration and optimization
SQL server capabilities
- Infrastructure Purchase
- H/W configuration, O/S configuration, SQL Server Configuration for Optimization
- General Check includes auditing of the existing server
- Performance Tuning
- Trouble Shooting
- Health Check
- Remote DBA Service
- Advanced T-SQL Development Service
- Stored Procedure optimization , Index Auditing, Fixing Index Issues , Execution plan analysis , wait analysis
- High Availability and Disaster Recovery
- Performance Baseline
- Feature Implementation like CDC, Encrypt database, Resource Governor, Always-on, Clustering, Policies, Extended Events, Memory OLTP, Columnar Indexing, Compression , Import /Export etc.
Case studies
Previous
Next