Top 10 New Features in SQL Server 2016
Microsoft is releasing new and exciting features with new versions over the time. SQL Server 2016 also has lots of new features for database users and it has been reformed and made database users...
Category: Tutorials
Different Types of SQL Server Locks
Sometimes conflicts occurs in SQL Server due to concurrent transactions which can be resolved by using lock modes. Locking is a very common problem and its a logical issue which means you cannot solve...
Configure SQL Server Memory To Optimize Performance
Database 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...
Fixed Database Roles in SQL Server
In 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...
Database Certification Path – SQL Server 2012
Microsoft 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...
Fixed Server Roles in SQL Server
To 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....
