What is RDBMS? Relational Database Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data…

Introduction SQL Server is a powerful relational database management system used by organizations to store and manage their data. As an administrator or developer, it’s crucial to have visibility into…

Fixed database roles in SQL Server include db_datareader, db_datawriter and other. These roles grant users read and write access to the database, allowing them to interact with tables. It’s worth…

Customer Raised Tickets Monitoring Tool/Alerts Raised

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) select * from sys.databases6) select * from sys.database_files Monitoring TSQL…

What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of transaction log files from the primary server database to second server database to get both database in continuous…

What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version to sql server 2012. Before upgradation we need to run upgrade advisor tool. Microsoft sql server 2012 upgrade…

Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1: As a part of launch, deployment in the production server…

Automation refers to scheduling the regular maintenance tasks. Whenever schedule time comes automatically that task will be executed. DBA regular activities can be automated we can get the status f…

Security is the most important tasks for a DBA. we need control the access to sql server as well as provide security to the datal. Levels of SQL Server Security…