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.

Know About Android Database and How to Fix Android Data Corruption

Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter. Similarly, Android SQLite database can be corrupted due to various reasons. Therefore, in this blog, we will introduce a best to for the recovery of damaged Android SQLite database. Before… Read more

0 comments, 162 reads

Posted in Zora's SQL Tips on 9 October 2017

SQL Server Database Corruption: That Might Occur in an Environment using SQL Server

SQL server is the highly employed database service and is a highly advanced relational database management system, which is used on a large scale by the employees and the professionals. The improved user interface and the advanced features of MS SQL server makes it one of the highly used database… Read more

0 comments, 1,454 reads

Posted in Zora's SQL Tips on 6 October 2017

Solved : Microsoft SQL Server Error 3403

From its powerful internal structure, fast performance, and reliability, SQL server is now widely accessed by several enterprise users. It is used to deal with bulk transaction processing, business programs, and content management. The Microsoft SQL server is chosen for its high level security, scalability, and performance. Sometimes, corruption in… Read more

0 comments, 452 reads

Posted in Zora's SQL Tips on 15 June 2017

Top 5 Features of SysTools SQL LDF Recovery Software - Review

An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for viewing transaction log file of SQL Server 2016, 2014, 2012, 2008 R2 database, and 2005. It is so because I personally had used this application for resolving many problems… Read more

0 comments, 529 reads

Posted in Zora's SQL Tips on 17 May 2017

Know How to Find Outdated Statistics In SQL Server Quickly

Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics. But, there are some circumstances in which it does not, in that case, a better understanding of statistics is required. Moreover,… Read more

0 comments, 552 reads

Posted in Zora's SQL Tips on 3 May 2017

A Perfect Solution to Resolve SQL Server Error 211

SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a user to access the database in the more reliable and effective way. However, there are some situations such as destruction in… Read more

0 comments, 759 reads

Posted in Zora's SQL Tips on 28 March 2017

How easy to implement RLS (Row Level Security) in SQL SERVER 2016 (New Feature)

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.
Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your responsibility that one tenant’s…

Read more

0 comments, 1,421 reads

Posted in Zora's SQL Tips on 27 March 2017

SQL Server Deadlock Performance Counter

End users generally face a situation where the SQL server application gets hangs. What users generally do is restart the machine for fixing the problem and then continue with their work. This restarting activity works for two to three weeks and after that, a point comes where the system gets… Read more

0 comments, 1,988 reads

Posted in Zora's SQL Tips on 27 February 2017

Steps to Configure SQL Server to Listen On A Specific TCP Port

Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more

2 comments, 2,457 reads

Posted in Zora's SQL Tips on 18 January 2017

Learn Different Options for Importing Data Into SQL Server

Most of the time users need to import their data into SQL Server for its proper management. Select from the variation of source as well as destination data source types, choose tables for copying or even for specifying own query for data extraction and store the work as SSIS package.… Read more

0 comments, 1,003 reads

Posted in Zora's SQL Tips on 11 January 2017

Learn Uses of log_reuse_wait_desc In SQL Server


Many times, while working on SQL Server, the transaction log files frequently grow due to various reasons. Out of which, one such reason is that there is, already existing assigned space of the file in the SQL Server. This can be happened due to increment in the utilization of… Read more

0 comments, 759 reads

Posted in Zora's SQL Tips on 13 October 2016

Steps to Restore Database from Backup File In SQL Server


In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster, or manage large amount of database onto the SQL server. However, users generally knows the way to create a backup… Read more

0 comments, 1,032 reads

Posted in Zora's SQL Tips on 21 September 2016

How to Prevent SQL Database Corruption in An Efficient Manner


As many companies rely on SQL Server Database for the storage of their data, database administrators need to make sure that the database is made available whenever required without failure. In order to ensure that, he/she needs to make sure that the data integrity is maintained all the time… Read more

3 comments, 2,336 reads

Posted in Zora's SQL Tips on 24 August 2016

Reasons For Backup Failure In SQL Server and their Prevention


The entire idea behind a backup, is to protect any organization from the data loss and corruption. However, the question arises what happen if user will loose the backup. Many times we still hear about businesses breaking down due to data loss. In this article we will discuss the… Read more

0 comments, 3,692 reads

Posted in Zora's SQL Tips on 30 July 2016

Know How to Handle Deadlock in SQL Server

Introduction To Deadlock

Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the resource as the other processes are preventing it from getting the resource. It is a very common issue in SQL… Read more

3 comments, 6,867 reads

Posted in Zora's SQL Tips on 4 July 2016

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It facilitates the function of data storing and retrieving by the applications which either run on the same or different platforms. The dominant reason behind the deployment of SQL Server on… Read more

1 comments, 13,678 reads

Posted in Zora's SQL Tips on 16 May 2016

SQL Server Error 3013: Restore Database is Terminating Abnormally

Overview of SQL Server Error 3013

One of the most frustrating situations that a user experiences while working with SQL Server is when errors are encountered. These errors disrupt the normal functioning of SQL Server and in worst case scenario may even lead to data loss. Sometimes, SQL Server Backup… Read more

0 comments, 5,895 reads

Posted in Zora's SQL Tips on 3 May 2016

What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?

REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL users and even administrators at times get confused about the real functioning of this command. It is to be noted that it contains the term Repair, which signifies that the… Read more

0 comments, 2,842 reads

Posted in Zora's SQL Tips on 19 April 2016

SQL Log File Corruption and Possible Recovery Methods

Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational database management system (RDMS) consisting of data definition language, data manipulation language and a data control language. The SQL database comprises of following three files:

  1. Primary Database files- Primary database file…

Read more

0 comments, 3,051 reads

Posted in Zora's SQL Tips on 21 March 2016

A Guide for Decrypting SQL Server Database Objects


The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from unauthorized access or hacker’s attacks. To make the data accessible, it needs to be decrypted with the use of key or password. It is necessary to encrypt critical SQL Server… Read more

0 comments, 2,036 reads

Posted in Zora's SQL Tips on 16 February 2016

Older posts