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: August 2014

Overview on SQL Server Performance Tuning

SQL Server Performance Tuning is an important subject and it is essential to implement various measures in regular intervals of time to optimize the scalability and performance of the Server.
Several parameters that can be executed for stimulate Server performance are mentioned herein.

Server Level Configuration Check:

For tuning the…

Read more

0 comments, 711 reads

Posted in Zora's SQL Tips on 30 August 2014

Transactional Replication in SQL Server 2014

Transactional replication begins with the help of publication database objects and data snapshots. The subsequent data changes and schema modifications created at Publisher are deployed to the Subscribers in real time. The order of the data changes in the same way it has been applied to the subscriber and exists…

Read more

2 comments, 2,556 reads

Posted in Zora's SQL Tips on 27 August 2014

SQL Server Recovery Models - Specifications and Significance!

SQL Server provides an efficient way of backing up the databases by logging all the transactions in log file but it becomes equally important to decide which data has to be backed up and which not by limiting the logging process. In this section we will discuss about the SQL…

Read more

0 comments, 743 reads

Posted in Zora's SQL Tips on 27 August 2014

Tips for Securing SQL Server from All Sorts of Risks

Securing SQL Server is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we have discussed about all the concepts and the precautions that can be taken to prevent databases and the accumulated components such as…

Read more

0 comments, 1,954 reads

Posted in Zora's SQL Tips on 23 August 2014

Introduction of SQL Server Agent in SQL Server version 2012

SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server 2012. It runs as a Windows service and starts automatically when the system boots. It basically performs the backup task, handles reporting services, log shipping, and user…

Read more

0 comments, 437 reads

Posted in Zora's SQL Tips on 19 August 2014

Synchronization with Microsoft SQL Server Analysis Services

SQL Server Analysis Services (SAAS) serves a broader view of data for analysis so as to make things simpler for business analysts. Implementation of SAAS gives an opportunity to users to ask compound query and convert it into actionable insight where information for better business decision making will be available.…

Read more

0 comments, 529 reads

Posted in Zora's SQL Tips on 15 August 2014

The SQL Server and Its Database Roles in SQL Server

The Role based security is a facility which is available for all editions of the SQL Server. With the help of this security feature multiple permissions can be applied to a Role. Also, various users can grant role with permissions in a group. Instead of applying permissions to individual users,…

Read more

0 comments, 520 reads

Posted in Zora's SQL Tips on 12 August 2014

An Overview of RDBMS (Relational Database Management System) Concept

RDBMS is the basis of all SQL databases like; MS SQL Server, Sysbase, Oracle, MySQL, etc. It works on the base of a relational database model. The RDBMS stores all its data in the form of an object that is called Table. A Table consists of columns, rows, and related…

Read more

0 comments, 1,505 reads

Posted in Zora's SQL Tips on 8 August 2014

Brief Description about SQL Server Architecture

SQL Server architecture is the part where all components work together and independently to process or execute services in a proper or defined manner so that SQL Server could work in a smooth way. The external interface to the SQL Server is created by the protocol layer and all operations…

Read more

0 comments, 1,302 reads

Posted in Zora's SQL Tips on 4 August 2014

Basic Information About SQL Server Versions 2005 to 2014

Nowadays,it’s true to say that Information Technology has changed the world so far and related technologies have given their best contribution in the respective field. In the same way, SQL Server is one among them; used by organizations to maintain their largesized databases in a regular, safe and specified way.…

Read more

0 comments, 300 reads

Posted in Zora's SQL Tips on 1 August 2014