2 min read
0
Create User Defined db_executor database role
Fixed database roles in SQL Server include db_datareader, db_datawriter and…
Category: MSSQL
1 min read
0
SQL DBA Regular Alerts & Tickets (Service Request and Incident)
Customer Raised Tickets Monitoring Tool/Alerts Raised
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)…
6 min read
0
SQL Server Log shipping
What is LOG SHIPPING in SQL Server DBA? Log shipping:…
3 min read
2
SQL Server Upgradation
What is SQL Server UPGRADATION? Upgrading means, migrating sql server…
6 min read
1
SQL Server Migration
Migration means moving one (or) set of databases from one…
4 min read
3
SQL Server Automation
Automation refers to scheduling the regular maintenance tasks. Whenever schedule…
9 min read
3
SQL Server Security
Security is the most important tasks for a DBA. we…
9 min read
5
9 min read
1
SQL Server Backups
Backup means, saving the exact copy of the current version…