Great minds discuss ideas!
Introduction In the world of SQL Server administration, it’s not uncommon to encounter situations where important data mysteriously disappears from tables. As a database administrator (DBA), it’s crucial to identify the user responsible for deleting the data. This helps ensure…
In this article, we’ll explore some of the most commonly used TSQL queries for DBAs, how to use them effectively, and the benefits they offer. Whether you’re a beginner or an experienced DBA, this article will have something for you.…
Introduction I always very much confused about SQL Server Versions. To check the SQL Server version by TSQL we may run below script. Script 01 SELECT @@VERSION AS ‘SQL Server Version’, SERVERPROPERTY (‘productlevel’) as Product Level Result SQL Server Version…
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 and tables. In a relational database, relationships between data items…
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 the active sessions and their execution details for effective monitoring…
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 noting, however, that there is no built-in role particularly designed…
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 Commands 1) sp_who22) select * from sys.dm_exec_requests where session_id>503) DBCC…
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 synchronization. It is a continuous process in the form of…
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 advisor Under installation menu → in planning → click upgrade…