Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Troubleshooting / Tutorials
by Manzoor Siddiqui · Published September 9, 2015 · Last modified September 24, 2015
2.9kviewsDatabase performance is always a headache for Database Administrators as over the time performance may degrade due to several reasons and DBAs has to identify and fix this issue. In previous articles we have...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published August 31, 2015 · Last modified September 24, 2015
1.3kviewsIn earlier article we have seen Fixed Server Roles, today we will see about fixed database roles in SQL Server. As the name suggests, fixed database roles cannot be removed or modified and performs specific...
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....
SQL Commands / SQL Programming / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published August 12, 2015 · Last modified October 18, 2015
782views IIF() logical function has been introduced in SQL Server 2012. We already know about CASE expression and IF-Else statement in SQL Server so now you can also use IIF() function to get the same...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published August 1, 2015 · Last modified September 24, 2015
965viewsIn 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 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...
