Different Ways to Find Recovery Models in SQL Server
Today I was going through recovery models so thought to share different ways how we can find recovery models in SQL Server 2012. Option 1: Execute below query in query editor and find the...
Category: SQL Tips and Tricks
SQL Server Wait Types – Trace and Tune Database Performance Issues
398viewsIt is a big challenge for database administrators to trace performance issues, tune and maintain database server effectively. I receive many queries regarding database performance issues, some issues come after migration, some issues are...
Create Automated Maintenance Jobs with SQL Server Maintenance Plan
SQL Server maintenance plan is a very useful and simple way to create automated maintenance plans to optimise and backup your database regularly. You can perform database maintenance and optimised your database by creating...
How to Identify and Fix Orphaned Users in SQL Server
We know about logins and users in SQL Server, to connect to instance and database we have to go through a defined principals. This principal is defined by Microsoft SQL Server to authenticate and...
SQL Server Database Migration Checklist – For Successful DBAs
1.1kviewsMigrating a database is very critical and time bound process, if anything goes wrong then its very difficult to rollback things and move back to existing environment again. So its very important to prepare...
Activity Monitor in SQL Server 2012
Activity Monitor is an inbuilt monitoring tool which comes with SQL Server Management Studio. This monitoring tool provides real-time information about processes, resource waits, data file I/O and recent expensive queries etc. If you...
