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

Forensic analysis for log files in sql server

The Importance of Log Files in SQL Server

On the SQL server every day we perform many transactions and as we know that all these transactions affect the log file. After all, the transactions are stored in the log file so every transaction contains some space in the log file… Read more

3 comments, 5,842 reads

Posted in Zora's SQL Tips on 28 May 2015

Read the Transaction Logs in SQL Server

INTRODUCTION

In this tutorial we will know about, how to read a transaction log in SQL server and also we will learn all the reading methods of a transaction log. From this tutorial you will know why MS SQL permits you to read the transaction logs. As we know very…

Read more

0 comments, 829 reads

Posted in Zora's SQL Tips on 25 May 2015

Compromising with corrupted transaction logs files in SQL server

As we know that without any transaction we cannot perform any task in the database. To maintain every field in the database, we need to perform transactions for a particular change. These transactions are very important for every database and make it interactive for users.SQL server also dealing with these… Read more

0 comments, 691 reads

Posted in Zora's SQL Tips on 19 May 2015

Know about SQL server Objects

Introduction to SQL server Objects

In databases, when we talk about database objects, it means we are talking about SQL Tables. SQL Tables are also known as SQL Objects which manages all the records in a specific order in SQL server database. The data, stored in a Table are managed… Read more

0 comments, 833 reads

Posted in Zora's SQL Tips on 12 May 2015

Know How SQL Server Works Using Stored Procedures & Triggers

Amongst databases, every database has some specific pre-defined functions which are used to execute a particular task on it. SQL server also uses these pre-defined functions to execute any task in its database. Similarly, Trigger is also a special kind of stored procedure .In SQL, Triggers automatically execute whenever an… Read more

0 comments, 2,750 reads

Posted in Zora's SQL Tips on 7 May 2015