Category Archives: Sql Server

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

Interview Question:Important New Features of SQL Server 2012, 2014 & 2016

Questions may be asked from the DBA prospective so I tried to collect few important features for SQL Server 2012,2014 and 2016 . Next blog will be published with explanation for each feature. SQL Server 2012 Features:- Column store indexes … Continue reading

Rate this:

Posted in Sql Server, Sql Server New Feature | Leave a comment

Blocking caused by -1/Negative SPID

I received a request from my development team for a query which is stuck and not giving any result and no error throwing. I thought for a moment and start troubleshooting by checking the blocking. I caught the issue as … Continue reading

Rate this:

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