Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published August 1, 2015 · Last modified September 24, 2015
937viewsIn previous article we have seen how to backup system databases by creating maintenance plan. Here we will use T-SQL to backup all user and system databases with compression. You can also create SQL...
Articles / Database Administration / SQL Server / SQL Tools / Tutorials
by Manzoor Siddiqui · Published July 31, 2015 · Last modified September 24, 2015
1.1kviewsSQL Server maintenance plan wizard is inbuilt feature which helps in creating automated maintenance jobs for database integrity checks, rebuild and reorganize indexes, update statistics, backup databases and performs maintenance cleanup tasks etc. These...
by Taiba Hamid · Published July 30, 2015 · Last modified September 24, 2015
533viewsORDER BY clause is used to sort the data in ascending or descending order, in SQL Server by default data will not be inserted in any order even if you have an index. Syntax:...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 29, 2015 · Last modified September 24, 2015
2.4kviewsThe role of Database Administrator is very critical and important and DBA has to perform lots of activities and monitoring is one of the important task. A good DBA always tries to minimize his...
Database Administration / SQL Error Messages / SQL Server / SQL Troubleshooting
by Manzoor Siddiqui · Published July 28, 2015 · Last modified September 24, 2015
1.1kviewsThis is very common issue and faced by many database users while connecting to database. When you try to connect to SQL Server, you may get error as: “A network-related or instance-specific error occurred...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 27, 2015 · Last modified September 24, 2015
774viewsIf you want to find out which port is used by SQL Server then you can do the same by T-SQL or from SQL Server Configuration Manager (SSCM). Default port for SQL Server is...
