-->
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: September 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,787 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,731 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,886 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,957 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, 974 reads

Posted in Zora's SQL Tips on 2 September 2015