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

Are SQL Server 2014 Table Variables Different From Temporary Tables?

What are the Table Variables in SQL Server?

In our previous blog we have discussed How to find free space In SQL Server database. Now, in this section we will elaborate about SQL Server 2014 Table Variables. SQL Server support features that allow users to work with temporary data… Read more

1 comments, 3,455 reads

Posted in Zora's SQL Tips on 4 February 2016

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, 22,771 reads

Posted in Zora's SQL Tips on 15 January 2016

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

Posted in Zora's SQL Tips on 26 November 2015

Know More About SQL Server Error number 6401

Introduction

The ACID acronym standing for Atomicity, Consistency, Isolation and Durability is the foundation 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, 1,217 reads

Posted in Zora's SQL Tips on 25 November 2015

Five simple backup and recovery plans for SQL database

Introduction

Creating a good backup and recovery plan for SQL database is a very important task of a database administrator. A Database administrator must have the knowledge about the troubles of SQL Server and also a quick strategy, which is suitable for the trouble. Many organizations hire accidental database administrators… Read more

1 comments, 4,023 reads

Posted in Zora's SQL Tips on 30 October 2015

Atomic Commit In Multiple Files Of SQLite Database

Introduction to Atomic Commit

In my previous post, we have discussed how to view and analyze SQLite BLOB data and know why BLOB data is important in SQLite database. Now, in this blog section we will know the role of atomic commit in SQLIte multiple files. SQLite has become the…

Read more

1 comments, 902 reads

Posted in Zora's SQL Tips on 3 October 2015

How to View and analyze SQLite Blob Data?

SQLite is one of the most commonly used database engine in the world. Its source code is available in public domain and 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…

Read more

0 comments, 9,859 reads

Posted in Zora's SQL Tips on 30 September 2015

Managing SQL Server Transaction Log File

Overview

In our previous section we have discussed about how to create an audit trigger in SQL Server and how it helpful for database security in different aspects and also knows how harmful it is for a database. Now, in this section we will discuss about SQL Server log file… Read more

0 comments, 2,733 reads

Posted in Zora's SQL Tips on 21 September 2015

How to Create an Audit Trigger In SQL Server

Overview

In my previous article, we have discussed about Temporal Tables in SQL Server 2016, and understand much more about it. Now in this article we will discuss about triggers and will know how to create an audit trigger in SQL Server.

In many applications’ database, it is a… Read more

0 comments, 1,909 reads

Posted in Zora's SQL Tips on 16 September 2015

Know About Temporal Tables in SQL Server 2016

Temporal tables were included in SQL Server 2016 as a new feature. These temporal tables are also known as system-versioned tables allow SQL Server for keeping the history of data in table automatically. A temporal table can be defined as a table for which PERIOD definition exists comprising of system… Read more

1 comments, 1,964 reads

Posted in Zora's SQL Tips on 2 September 2015

SQL Server Page Level Corruption And Resolution

SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain hardware, hard disk functioning failure, improper network establishment, or logical level of issues such as malware intrusion on the server storing data, repository being declared as out of limit. These… Read more

2 comments, 976 reads

Posted in Zora's SQL Tips on 2 September 2015

Accomplishing a Strategized SQL Server Disaster Recovery

Introduction

The appropriate SQL Server disaster recovery plan means to be prepared for tackling with physical as well as logical cases of database loss to bring the server back into a running state, and not just the recovery of data once it is already been lost. Different types of disasters… Read more

0 comments, 1,612 reads

Posted in Zora's SQL Tips on 9 August 2015

How to Run DBCC CHECKDB to Check SQL Database Integrity

Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is supported in databases that contain memory-optimized tables but the validation is only supported in disk-based tables. The DBCC repair option is unavailable in memory-optimized tables and therefore,… Read more

5 comments, 12,237 reads

Posted in Zora's SQL Tips on 4 July 2015

How to Restore the Database from MDF File?

Introduction

As we already know, every component in SQL server is saved in a particular file. If it is a transaction log information then it is saved in .ldf file and if it is not a transaction log information or if it is any other information related to database like… Read more

4 comments, 3,947 reads

Posted in Zora's SQL Tips on 8 June 2015

Fix login issues in SQL server using SQL Server Authentication

Introduction

For the security of user’s database, SQL server provides some authentication modes by which an unauthorized person cannot access user’s database. In this section we will know about the types of authentication modes provided in SQL server and learn how to deal with login failure issues on SQL server. Read more

4 comments, 1,898 reads

Posted in Zora's SQL Tips on 1 June 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,845 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,752 reads

Posted in Zora's SQL Tips on 7 May 2015

Newer posts

Older posts