Articles / SQL Server / Tutorials
by Manzoor Siddiqui · Published August 21, 2015 · Last modified September 24, 2015
1.1kviewsMicrosoft database certification is important for database users as it helps in getting more job calls and short-listing your biodata and it certifies that you have completed almost all the topics of particular curriculum and...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published August 14, 2015 · Last modified September 24, 2015
1.4kviewsTo maintain security and access level of database, SQL Server provides fixed server roles. As the name indicates, you cannot modify or alter server roles hence it helps to manage permissions on the server....
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published August 1, 2015 · Last modified September 24, 2015
949viewsIn 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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 29, 2015 · Last modified September 24, 2015
2.5kviewsThe 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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 27, 2015 · Last modified September 24, 2015
794viewsIf 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...
More
