1 min read
0
SQL DBA Regular Alerts & Tickets (Service Request and Incident)
Customer Raised Tickets Monitoring Tool/Alerts Raised
Year: 2017
1 min read
0
Important & Handy TSQL Commands
Space Management TSQL Commands 1)sp_spaceused2)dbcc sqlperf(logspace)3)xp_fixeddrives Information TSQL Commands 1) sp_helpdb2) select db_id('DBName')3) select db_name(DBID)4) select * from sys.dm_exec_sessions, dm_exec_connections5)…
6 min read
0
SQL Server Log shipping
What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of transaction log files from the primary server database…
3 min read
2
SQL Server Upgradation
What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version to sql server 2012. Before upgradation we need…
6 min read
1
SQL Server Migration
Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1:…
4 min read
3
SQL Server Automation
Automation refers to scheduling the regular maintenance tasks. Whenever schedule time comes automatically that task will be executed. DBA regular…
9 min read
3
SQL Server Security
Security is the most important tasks for a DBA. we need control the access to sql server as well as…
9 min read
5
SQL Server Restoration Tutorial
Restoration is a process of using backups to recover the exist database (or) to create a new database in another…
9 min read
1
SQL Server Backups
Backup means, saving the exact copy of the current version of database in some other location. Situations where backup can…
6 min read
4
SQL Server Databases
Database: Database is a container which stores data and data objects. It manages data and allows fast storage and retrieval…