Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 6, 2015 · Last modified September 24, 2015
411viewsIt 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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 4, 2015 · Last modified September 24, 2015
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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / SQL Troubleshooting / Tutorials
by Manzoor Siddiqui · Published July 2, 2015 · Last modified September 24, 2015
300viewsWe 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...
Articles / Database Administration / SQL DBA Interview Q&A / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published June 30, 2015 · Last modified February 12, 2021
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...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published June 28, 2015 · Last modified September 24, 2015
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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published June 27, 2015 · Last modified September 24, 2015
SQL Server Credentials are used to access external resources of windows by enabling SQL Server login. Credentials creates an internal connectivity with SQL Server login to outside resources so that by using SQL Server login...
More
