Dive Into SQL Server Transaction Log — Part 2

Total: 3 Average: 4

This is the second article in a series of articles about SQL Server transaction log file architecture. In this article, we will have a look at two SQL Server statements that allow examining transaction log details. If you would like to get an introductory information about how SQL Server transaction log works, read Dive Into SQL Server Transaction Log — Part 1 Read More

Iterating Over JavaScript Arrays

Total: 5 Average: 3.8

Arrays in JavaScript are tremendously helpful. Multiple values stored in a single variable that is possible with arrays make the codes organized and condensed. Therefore, it is easier to read it and to work with it. Besides, there can be any types of data in arrays – numbers, strings, objects. Programming in JavaScript can’t get without arrays – they are a fundamental part of the entire programming process.

To work with arrays efficiently, we can use several built-in methods. Among them, the iteration methods deserve special attention. Their distinguishing feature is operating every array item one by one. Developers used default iteration methods but constantly needed more functionality. Thus, for now, enough approaches are present to choose from.

The current article is dedicated to ES5 and ES6 approaches to iterate over javascript arrays and array-like objects.

Read More

Dive Into SQL Server Transaction Log — Part 1

Total: 1 Average: 5

Chances are you already know that every SQL Server database contains one or more transaction log files, in addition to data files, that records all the transactions and database modifications made by each transaction. The transaction log is an essential part of any database, and the database administrator must keep it under observation. One of the most important tasks for the database administrator is to truncate the transaction log file to keep it from overflow. Why? Because the transaction log plays the most important role when it comes to the database recovery. Read More

Retrieving SQL Server Metadata with Help of T-SQL

Total: 3 Average: 4
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and catalog views. Metadata queries are really helpful in discovering information for a given database schema. You can copy all the T-SQL scripts that are listed in this article and use for your own purposes. However, please do some tests before apply to a production database.

Read More