Answer Posted / adedewe bliss

SQL Authentication :
SQL Authentication is the typical authentication used for
various database systems, composed of a username and a
password. Obviously, an instance of SQL Server can have
multiple such user accounts (using SQL authentication) with
different usernames and passwords. In shared servers where
different users should have access to different databases,
SQL authentication should be used.

Windows Authentication :
When you are accessing SQL Server from the same computer it
is installed on, you shouldn't be prompted to type in an
username and password. And you are not, if you're using
Windows Authentication.

NOTE: AFTER LOGIN USING WINDOS AUTHENTICATION, YOU WILL BE
REQUIRED TO SAVE ANY MODIFICATION INTO A PROJECT FOLDER.
THIS WILL HELP YOU WHEN EVER YOU WANT TO LOGIN USING SAME ID
& PASSWORD. IF YOU FAILS TO SAVE: FOR YOU AND YOUR USERS AT
THE OTHER WORKSTATION TO LOGIN SAME ERROR WILL COME 'Login
failed for user 'sa' because the account is currently locked
out'. IN OTHER WORDS, YOU HAVE TO SAVE YOUR MODIFICATION,
UPLOAD IT AT THE NEXT LOGIN.

Explain in details security in SQL azure?

121

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

---

Explain the phases a transaction has to undergo?

985

---

What is the difference between nvl and nvl2?

897

---

What does normalization do to data?

987

---

What is merge replication?

1064

---

What is dynamic cursor in SQL SERVER?

1000

---

How does clustered and non clustered index work?

848

---

How you can change a cross join into an inner join?

908

---

Explain four layers of abstraction microsoft architectured?

147

---

What is the correct order of the logical query processing phases?

871

---

what are different types of backups available in sql server? : Sql server database administration

889

---

When would you prefer to have a minimum number of indexes?

840

---

Explain what is use of dbcc commands?

987

---

Explain unique key in sql server?

950

---