Profile

Scrapbook photo 1
Mahesh Gupta (DBATAG)
Works at www.sqlServer-Training.com
701 followers|2,429,499 views
AboutPostsPhotosVideos

Stream

Mahesh Gupta

Shared publicly  - 
 
Currently having SQL Server Performance issues? From where should I start troubleshooting ? http://t.co/D5sbrbIN #sql #mssql #sqlserver
1
chetan chaudhari's profile photo
 
dear sir i am having one quiery
I am having two SQL servers 2008 at 2 diff location and connected with Lease line , my quiery is that if i make mirror using both server and suppose my lease line got dissconnected i want to use bot servers from their own location's means server A will be used only by users who seat at loction A and server B database will used BY only location B users
is it possible means in mirrion one detabase is inaccessable it wnat to use both database in lease line failure condition

please help me to solve this issue
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
How to manage SQL Server Transaction Log ? What are the best to manage SQL Server Transation Log Files ? http://t.co/L9qw9HoS
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
101 SQL Server Reporting Services Interview Questions with Answers with Solution and Tutorials.. http://t.co/9iagE0ZG #jobs #interview
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
Can We connect to SQL Server 2012 and higher version using 2008/2008 R2 SSMS ? http://t.co/Xv7hvdMS #msft #sql #dba
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
How SQL Server 2012 Developer Tool "Juneau"helps Developers ? http://t.co/2K9QAf54 #msft #sql #dba
1
Add a comment...
In their circles
1,170 people
Have them in circles
701 people
Nelson John's profile photo
John Rutherford's profile photo
TrainingRite SoapUI LoadRunner Selenium's profile photo
Jagat Anand's profile photo

Mahesh Gupta

Shared publicly  - 
 
What is PowerShell ? What are the benefits for using Powershell, How to use PowerShell in SQL Server ? http://t.co/Mqfj18kU #sql #sqlServer
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
250+ SQL Server Interview Question Answers with Solution and Tutorials.. http://t.co/Ga2vmboG #jobs #interview
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
Tons of SQL Server Video Tutorials FREE - http://t.co/MC1GAfI5 #sql #sqlserver #dba #mssql
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
what are Enhancement has been done in SQL Server 2012 for HIGH Availability ? http://t.co/UvIHXyMC #msft #sql #dba
1
Add a comment...

Mahesh Gupta

Shared publicly  - 
 
What is SQL Server Crescent in SQL Server 2012 ? ?How it benefit business / Developers ? http://t.co/0rtqGBPD #msft #sql #dba
1
Add a comment...
People
In their circles
1,170 people
Have them in circles
701 people
Nelson John's profile photo
John Rutherford's profile photo
TrainingRite SoapUI LoadRunner Selenium's profile photo
Jagat Anand's profile photo
Work
Occupation
SQL Server Database Consultant
Employment
  • www.sqlServer-Training.com
    Founder | Blogger | Database Consultant | Microsoft SQL Server SME, 20011 - present
  • IT Company
    Database Consultant, SQL DBA, Administrator, Architect, Manager, Advisor, Pre Sales Specialist, SME, 2011 - present
  • Dell
    Database Manager Delivery, Pre Sales Consultant, SQL DBA, Administrator, Architect, SME, Specialist, 2008 - 2011
  • Dell
    Database Consultant, Pre Sales Consultant, SME, Delivery Manager, SQL DBA, Administrator, Architect, Database Specialist, 2008 - 2011
  • ibibo Web Pvt. Ltd.
    Database Administrator, SQL DBA, Technical Solution Architect, Consultant, SME, Specialist, Manager, 2007 - 2008
  • Perot Systems
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2005 - 2007
  • Citigroup
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2005 - 2005
  • Citibank
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2005 - 2005
  • BCH Electric LTD
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2003 - 2005
  • HCL Technologies
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2003 - 2003
  • NIIT
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2000 - 2002
  • Microsoft
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2001 - 2001
  • www.callDBA.com
    SQL DBA, Database Consultant, Database Administrator | Consultant | Advisor |Specialist | SME | Delivery Consultant | SQL Server DBA | SQL Server Consultant, 2000 - 2000
Story
Tagline
SQL Server Database Consultant, Founder | Blogger | Solution Architect | SQL Server DBA | SQL DBA | SQL Server Consultant
Introduction
Trained, Certified and Experienced with SQL Server, having 12+ years’ experience in Microsoft SQL Server Database Administration, Designing & Implementing Solutions and Training people on SQL Server 2012, 2008, 2005, 2000, 7.0, 6.5 versions; databases ranging from GBs to TBs in size.

Education / Certifications
======================
• Done my Masters (Degree) in Computer Applications; MCA (Database Management)
• Project Management Professional (PMP Certified) since 2009
• ITIL V3 Foundation Certified
• Quality Management Certification
• MS Certified IT Professional (MCITP-Database Administrator) – SQL Server 2008
• MS Certified IT Professional (MCITP-Database Developer) – SQL Server 2008
• MS Certified IT Professional (MCITP-Business Intelligence Developer)
• MS Certified IT Professional (MCITP-Database Administrator)
• MS Certified IT Professional (MCITP-Database Developer)
• MS Certified Database Administrator (MCDBA)
• MS Certified System Engineer (MCSE)
• Oracle Certified Professional (OCP)

Specialties
=========
• MS SQL 2012 / 2008 / 2005 / 2000 / 7.0 DBA on VLDB Environment
• SQL Server Consolidation & Virtualization
• Production Database Support & Troubleshooting (24*7*365)
• Performance tuning SQL profiler, Query Execution plan
• Finding & Tuning SQL Server hardware Bottlenecks
• Business Continuity Planning & DR Setup
• SQL Clustering (Installation/Maintenance)
• SQL Replication, Log Shipping, Mirroring , HADR, AlwaysON
• SQL Version upgrade
• Server migration


As a Database Consultant performed various activities not limited to 

Database Services
• SQL Server DBA Production Support
• Implementing and Maintaining Log Shipping | Database| Clustering | Mirroring | Always On HADR
• Install, manage & troubleshoot multi node multisite SQL Server clusters
• SQL Server Virtualization & Consolidation
• SQL Server Setup, Installation, Version Upgrade & Architect Setup
• SQL Server Hardening & Best Practice Implementation
• Capacity Planning, Load Balancing & Scaling out SQL Server
• Design and Implement Database Backup Restore & Disaster Recovery Strategy
• Database Archiving / Partitioning (Horizontal / Vertical)
• Database Professional, Performance Tuning, and Disaster Recovery 
• Setting up Base lining and Capacity Planning
• SQL Server Hardware sizing and bottleneck tuning
• Auditing SQL Server Security
• Data Transfer / Transformation
• Plan, Design and Scheduled Database Maintenance & Administrative Tasks
• Configuring Replication / Data Synchronization
• SQL Server Database Monitoring with DDL Triggers | SQL Server Profiler | Event Notifications
• Data Quality and Master Data Service Design and Implementation
• Troubleshooting SQL Server
• Schedule SQL Jobs | SQL Server across multiple Servers
• Performance Tuning – Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor
• Disaster Recovery
• Enterprise Policy Management / Centralized Management

Database Development
• Creating Database, Schemas, Snap shots
• Planning, creating and Optimizing Indexes in SQL Server
• Implementing Data Integrity by Using Constraints and Triggers
• Creating, implementing XML Schemas, Indexes
• Creating, Retrieving and Shredding XML Data | XQuery
• Creating, Managing & Optimizing Performance for Views, Procedure, Triggers, Table & Functions
• Query Performance Optimization - Execution Plans, Exception Handling
• Creating Service Broker Object, Sending and Receiving Messages
• Optimizing distributed Transactions and Locks

Analysis Services / Data warehouse Management (SSAS)
• Installing & Configuring SQL Server Analysis Services on clustered environment
• Memory Management for SQL Server Analysis Services
• Cube Deployment using BIDS, deployment wizard, XLMA Script
• OLAP / CUBE database (s) synchronization 
• Database Backup Restore Strategy design and Implementations for OLAP Databases
• Logging, Monitoring, and Optimizing an Analysis Services Solution
• Backing Up and Restoring an Analysis Services Database (OLAP) 

Integration Services / Data warehouse Management (SSIS)
• Installing and Configuring Integration Services on Clustered Environment for High Availability
• Troubleshooting and Optimizing SSIS package performance
• Deployed and Scheduled DTS | SSIS Packages

Reporting Services / Data warehouse Management (SSRS)
• Installing and Configuring Reporting Services on Clustered Environment for High Availability
• Created basic Reports to meet Ad hoc business requirement
• Publishing / Deploying Report on multiple Report Servers
• Managing Shared Data sources and permissions
• Configured Reports Snapshots, Report Caching for reporting performance
• Created and managed subscriptions for Reports
• Assigning report level permissions to Secure business information
• Upgraded / Migrated SQL Server reporting services
• Creating Subscription for Reports
• Configure Backups for Reporting Services

SQL AZURE / Microsoft Cloud Database Services 
• Subscribe SQL Server Azure Cloud Services.
• Create Database(s) on SQL AZURE
• Setting up SQL Azure Firewall
• Create, manage SQL Server AZURE Databases
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
Contact Information
Home
Phone
+1 260 CALL DBA ; +1 260 225 5322
Email