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: Articles
Find SQL Server Last Restart Time and Resource Information with Useful DMV sys.dm_os_sys_info
SQL Server provides DMVs and system tables to find out when SQL Server was last restarted. We may need this information many times to troubleshoot or trace issues which occurs on database servers. So,...
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...
