SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Zora's SQL Tips

Hi! I am Zora Stalin, an IT geek and a passionate learner of technology. Besides my job as an Information Technology Analyst, I love searching and sharing new things that excite me help for others.

Archives: June 2015

How to Restore the Database from MDF File?


As we already know, every component in SQL server is saved in a particular file. If it is a transaction log information then it is saved in .ldf file and if it is not a transaction log information or if it is any other information related to database like… Read more

4 comments, 3,950 reads

Posted in Zora's SQL Tips on 8 June 2015

Fix login issues in SQL server using SQL Server Authentication


For the security of user’s database, SQL server provides some authentication modes by which an unauthorized person cannot access user’s database. In this section we will know about the types of authentication modes provided in SQL server and learn how to deal with login failure issues on SQL server. Read more

4 comments, 1,898 reads

Posted in Zora's SQL Tips on 1 June 2015