Tags » SQL Security

SQL Server Error Messages - Msg 8101

Sometime SQL Server error msg 8101 occurred, when anyone is trying to insert a new record into a table that contains an identity column without specifying the columns in the INSERT statement and trying to assigning a value to the identity column instead of letting SQL Server assign the value. 80 more words

Database Administrator

SQL SERVER - ​Finding Out What Changed in a Deleted Database - Notes from the Field #041

: This is a 41th episode of Notes from the Field series. The real world is full of challenges. When we are reading theory or book, we sometimes do not realize how real world reacts works and that is why we have the series notes from the field, which is extremely popular with developers and DBA. 632 more words

SQL Authority

SQL SERVER - Difference Between Login and User - SQL in Sixty Seconds #070

“What is the difference between Login and User in SQL Server?”

This is a very common question I often receive. Yesterday when I was browsing Facebook, I once again noticed this question once again asked in… 241 more words

SQL Authority

SQL SERVER - What is Biml and How Can it Help Me with SQL Server BI? - Notes from the Field #036

: This is a 36th episode of Notes from the Field series. One of the common question I receive every other day is – I have learned BI but I feel that there is no automation in the BI field, what should I do? 1,654 more words

SQL Authority