Microsoft SQL Servers Administration Portfolio of Microsoft Server Administration

MS SQL Server Administration Capabilities:

  • 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.
 

Request for Proposal

Like us on Facebook
Follow us on Twitter
Follow us on Linkedin
Blog
Find us on youtube