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: January 2015

Types of SQL Server Commands

SQL commands are used as an instruction to communicate with the database to perform specific tasks like create database, delete, update records, alter etc. These commands perform different types of task to execute within the database. With the help of these commands user can create different objects. There are four…

Read more

1 comments, 1,128 reads

Posted in Zora's SQL Tips on 31 January 2015

Find the Location of SQL Server Error Log File

This post is all about SQL Server error log files where they reside on the system. It will help those users who are not aware of the error log file.

SQL Server maintains its error event or information about error logs related messages are kept in the error log file.…

Read more

2 comments, 8,557 reads

Posted in Zora's SQL Tips on 16 January 2015

An Overview of the SQL Server System Databases

The endowment of Microsoft’s extensive data storage platform, SQL server carries out breakthrough efficiency in storing and maintenance of data. It is a highly featured database that is primarily designed to cope with the business environment. The SQL server supports ANSI-SQL and T-SQL query languages. The query languages are used…

Read more

0 comments, 1,882 reads

Posted in Zora's SQL Tips on 10 January 2015

How to configure SQL Server Database Mail in 2014

SQL Server database mail keeps ail copies of the sent or outgoing email messages and user can see them in the MSDB database views section like sysmail_allitems, sysmail_unsentitems, sysmail_faileditems and sysmail_sentitems etc. User can view the sysmail_event_log for log details and to check the email message status run the query…

Read more

0 comments, 1,013 reads

Posted in Zora's SQL Tips on 2 January 2015