Category Archives: Sql Server

Trace Flags in SQL Server

Trace Flags in SQL Server Trace flags plays an important role in database administration. These are frequently used to diagnose performance issues or to debug stored procedures. For example trace flag 1222 is to detect the deadlock and returns the … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server | Tagged , , , , , , , , , , , | Leave a comment

SQL Server High Availability and Database Recovery Model Relationship

There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. … Continue reading

Rate this:

Posted in Always on, Database Administration, Replication, Sql Server, T-SQL | Leave a comment

DBA Daily Tasks

This blog is especially for those people who are preparing to be a Database Administrators or who have just started their career in the database administration field. As a production DBA, we are supposed to perform several tasks on the … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server | Tagged , , , , , , , , , | Leave a comment

10 Most Important handy system stored Procedures for DBA

10 Most Important handy system stored Procedures for DBA This blog contains the most important system stored procedures which are supported by SQL Server and are used on a daily basis by DBA. These stored procedures are used commonly for … Continue reading

Rate this:

Posted in Database Administration, Sql Server | Tagged , , , , , , , , , , , , | Leave a comment

MS SQL Server Version History – Year Wise

MS SQL Server Version History – Year Wise MS SQL Server is a RDBMS (Relational Database Management System) which is developed by Microsoft. Here we will go through a series of different versions of SQL Server with specified year when … Continue reading

Rate this:

Posted in Database Administration, Sql Server | Tagged , , , , , , , | Leave a comment

Resolve Microsoft SQL Server Attach Database Error Code 5120

When the users try to attach a database to SQL server then sometimes it becomes difficult to do this due an error. This error is known as Microsoft SQL Server error 5120 access denied. The error message occurs on the … Continue reading

Rate this:

Posted in Sql Server | Tagged , , | Leave a comment

SQL Injection

SQL Injection (SQLi) refers to an injection attack wherein an attacker can execute malicious SQLstatements (also commonly referred to as a malicious payload) that control a web application’s database server. Such attack affects any website or web application. An attacker can bypass a web … Continue reading

Rate this:

Posted in Database Administration, Other, Security, Sql Server, T-SQL, Uncategorized | Leave a comment