Year: 2017
SQL DBA Regular Alerts & Tickets (Service Request and Incident)
Customer Raised Tickets 1) Unable to connect to SQL Server 2) Unable…
SQL DBA Important & Handy Commands
Space Management: 1)sp_spaceused 2)dbcc sqlperf(logspace) 3)xp_fixeddrives Information Commands: 1) sp_helpdb 2) select…
SQL DBA Checklist/Activities
Daily Checklist 1) Backups 2) SQL Server Error Logs 3) SQL Server…
14. Log shipping
What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of…
13. SQL Server Upgradation
What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version…
A Guide to SQL Server Migration
12. SQL Server Migration Migration means moving one (or) set of databases…
SQL Server Automation Tutorial
11. SQL Server Automation Tutorial Automation refers to scheduling the regular maintenance…
10. SQL Server Security
SQL Server Security Security is the most important tasks for a DBA….
9. SQL Server Restoration Tutorial
SQL Server Restoration Tutorial Restoration is a process of using backups to…
8. SQL Server Backups
SQL Server Backups Backup means, saving the exact copy of the current…
7. SQL Server Databases
SQL Server Databases Database: Database is a container which stores data and…
6. SQL Server installation
Installation Whenever we want to start the installation of the SQL server…
5. SQL Server Transaction Log Architecture
Transaction Log Architecture SQL Server uses LSN (Log Sequential Number) in identifying…
SQL Server Database Architecture
4. SQL Server Database Architecture SQL Server data mainly in 2 types…
SQL Server Storage Architecture
3. SQL Server Storage Architecture In an SQL server all the data…
SQL Server Architecture
2. SQL Server Architecture SQL Server follows a client-server architecture. Whenever the…
SQL Server Database Administration
1. SQL Server Database Administration A database administrator is a person responsible…