-->
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.

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, 63 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, 146 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, 804 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, 319 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

0 comments, 390 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, 608 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, 725 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, 239 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,013 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, 459 reads

Posted in SQL Server Overview on 21 May 2018

Know About SQL Server Error 6401

Introduction

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, 430 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, 276 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, 311 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, 303 reads

Posted in SQL Server Overview on 7 April 2018

7 Steps to Repair Database from Corruption

SQL Server Database is an advance relational database management system, which is widely used by business professionals. But one of the serious issue one faces is SQL Server Database Corruption.

It is estimated that 99% of Database Corruption in SQL Server is caused due to the problem in IO subsystem… Read more

0 comments, 319 reads

Posted in SQL Server Overview on 4 April 2018

Using Stored Procedures in SQL Server For Better Performance

Intoduction to Stored Procedures in SQL Server

SQL Server uses Different types of stored procedures. They are the quickest method of accessing and manipulating database on the server. SPs are codes and scripts that are predefined for repetitive tasks to be performed on the server involving a database/its table/pages,… Read more

0 comments, 547 reads

Posted in SQL Server Overview on 13 March 2018

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server Database

In our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using them in SQL Server. Now, In this article we will discuss about how to check free space in SQL Server…

Read more

0 comments, 347 reads

Posted in SQL Server Overview on 5 March 2018

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, 1,263 reads

Posted in SQL Server Overview on 17 February 2018

A Guide for Decrypting SQL Server Database Objects

Overview

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

Posted in SQL Server Overview on 16 February 2018

Forensic Analysis of 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

0 comments, 442 reads

Posted in SQL Server Overview on 5 February 2018

Older posts