Category Archives: Uncategorized

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

Microsoft + LinkedIn

REDMOND, Wash., and MOUNTAIN VIEW, Calif. — June 13, 2016 — Microsoft Corp. (Nasdaq: MSFT) and LinkedIn Corporation (NYSE: LNKD)  announced they have entered into a definitive agreement under which Microsoft will acquire LinkedIn for $196 per share in an all-cash … Continue reading

Rate this:

Posted in Microsoft News, Uncategorized | 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

SQL SERVER ERROR- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF

SQL SERVER ERROR- Cannot insert explicit value for identity column in table ‘tablename’ when IDENTITY_INSERT is set to OFF Yesterday I got this error while monitoring the replication status of a server. The actual error is in snapshot as below: … Continue reading

Rate this:

Posted in Database Administration, Replication, Uncategorized | Leave a comment

How to logoff another user from sql server

How to logoff a user from SQL  Server It is obvious that a single server may be accessed by several people at a time. We can logoff active/inactive users from the SQL server as per requirement. It is simple and … Continue reading

Rate this:

Posted in Database Administration, Security, Uncategorized | Leave a comment

MS SQL Server Transaction Log Architecture

SQL Server Transaction Log files are the inherent part of every Microsoft SQL Server files, Also known as database log, transaction journal, binary log file etc. A transaction log contains history of all the activities executed in database. From disaster … Continue reading

Rate this:

Posted in Database Administration, Uncategorized | Leave a comment