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

SQL Server Overview

I'm a SQL Server DBA. I love to explore my knowledge about SQL Server database and have experience with database administration (installing, configuring, maintenance, transaction log shipping, replication, database mirroring etc) also I like to write blogs about these technologies.

How To Restore Database in SQL Server 2014 From .bak - Step By Step

Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT administrators to ensure the security of data. In order to minimize the risk of data loss, creating a regular backup of the database is such a good practice. These backups… Read more

0 comments, 253 reads

Posted in SQL Server Overview on 10 December 2018

How to Find SQL Server Performance Bottlenecks and Fix These Issues

SQL Server is undoubtedly a popular way to manage database. Due to its efficiency, business organizations largely depend on this for data management. This dependency often causes performance bottlenecks and ultimately hampers the productivity of the organization itself. So, it is important to find the bottlenecks and avoid them at…

Read more

0 comments, 208 reads

Posted in SQL Server Overview on 17 November 2018

Best Trick to Extract Data From SQL Server MDF File Instantly

SQL Server is a relational database management system in technology field it supports more than one transaction processing. MDF is utilized to save information like views, stored information and so on and secondary is .ldf file, that stores transactional information of its related primary database file MDF. Moreover, .mdf is… Read more

0 comments, 501 reads

Posted in SQL Server Overview on 21 September 2018

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, 661 reads

Posted in SQL Server Overview on 11 September 2018

Different Ways 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

0 comments, 423 reads

Posted in SQL Server Overview on 10 September 2018

Best Way to Fix Corrupted SQLite Database

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, 225 reads

Posted in SQL Server Overview on 7 September 2018

SQL Server Error 5123 Attach Database - Resolution

SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This error is a kind of permission error that occurs in SQL Server. As we all know, the .mdf is a primary database file and .ldf file represents the log file… Read more

0 comments, 483 reads

Posted in SQL Server Overview on 21 August 2018

Generate Script in SQL Server With 6 Simple Steps

“I am a new user of SQL Server so I have very limited knowledge of its features. I would like to know how to generate script with data of SQL Server 2016 database. As I have mentioned, I am unaware of this process. Can anyone help me by telling how… Read more

0 comments, 279 reads

Posted in SQL Server Overview on 7 August 2018

Know How Table Variables Different From Temporary Tables in SQL Server

Know What Table Variables are ?

SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the first time with SQL Server 2000 as an alternate option to using temporary tables. Table variable is a type of… Read more

1 comments, 966 reads

Posted in SQL Server Overview on 18 July 2018

How Often Should I Backup my Database - Query Answered

"In recent time, some of our counterpart organizations have faced database corruption. Though our company takes backup every week, we have decided to become more careful. I would like to pose a question to the expert admins here: How often should I backup my database? Our company is a mid-sized… Read more

0 comments, 419 reads

Posted in SQL Server Overview on 18 June 2018

How to Read BLOB data in SQLite in an Efficient Way

SQLite is one of the most commonly used database engine. Its source code is available in public domain which can be used for commercial or private purpose. Common data types used in SQLite are NULL, INTEGER, REAL, TEXT and BLOB. Unlike Blob, all other data types stores a particular type…

Read more

1 comments, 2,811 reads

Posted in SQL Server Overview on 15 June 2018

Understanding the Role of SQL Server Agent in SQL Server

SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. 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 tasks…

Read more

0 comments, 753 reads

Posted in SQL Server Overview on 6 June 2018

Microsoft SQL Server Analysis Services and Its Synchronization

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, 867 reads

Posted in SQL Server Overview on 2 June 2018

Quick Way to Rebuild SQL Server Master Database

All the system-level configuration settings and login account information of SQL server are stored in the corresponding SQL Master Database files. It contains information about other databases that are present in SQL server. Master database consist 2 files – master.mdf and mastlog.ldf. Also other information details which are included…

Read more

0 comments, 421 reads

Posted in SQL Server Overview on 29 May 2018

Tips for Securing SQL Server Database from All Sort of Risks

Securing SQL Server Database 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…

Read more

0 comments, 1,169 reads

Posted in SQL Server Overview on 24 May 2018

Tactics to Find Outdated Statistics in SQL Server

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, 898 reads

Posted in SQL Server Overview on 21 May 2018

Know About SQL Server Error 6401


The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when the database has to be modified by using one or more SQL statements and to make sure the security of the database as well. However, at times, this normal… Read more

0 comments, 722 reads

Posted in SQL Server Overview on 7 May 2018

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, 840 reads

Posted in SQL Server Overview on 30 April 2018

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, 540 reads

Posted in SQL Server Overview on 27 April 2018

Brief Description about SQL Server Encryption

Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the data useless until any decryption key or password is used to unlock it. Encryption makes data secure and prevents data loss, even if access controls are bypassed. Users can use…

Read more

0 comments, 445 reads

Posted in SQL Server Overview on 7 April 2018

Older posts