Category: SQL Tips and Tricks
690viewsDatabase 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...
486viewsIn 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...
442viewsTo 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....
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 output in...
552viewsIn 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...
1.7kviewsThe 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...