Always remain updated about current software development trends

Articles having tag: DBA

About transaction log and its truncation in SQL Server

By Mika Wendelius

Article describes basic information about transaction log behavior and truncation of the log.

Building an N-Tier Application in VB.NET, in 8 Steps

By Vuyiswa Maseko

This article will show you how to build an N-Tier application in VB.NET.

Control trigger logic based on user

By Mika Wendelius

This article describes a mechanism how trigger actions bypassed based on database user information

How to guarantee a fixed amount of rows in a table in Oracle

By Mika Wendelius

This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle

How to guarantee a fixed amount of rows in a table

By Mika Wendelius

This tip describes how to guarantee a fixed amount of rows in a table by using triggers

ASP.Net page partial rendering

By J.Jash

ASP.Net page partial rendering using Response.Flush() method

Generating INSERT statements in SQL Server

By ilorgat

This is an alternative for "Generating INSERT statements in SQL Server"

Retrieving failed records after an SqlBulkCopy exception

By David Catriel

How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation

Corel Paradox Seach Technique

By doug433

An alternate solution for a Corel Paradox query that fails to yield accurate results due to a huge number of records in a data table.

RaptorDB - the Document Store

By Mehdi Gholam

NoSql, JSON based, Document store database with compiled .net map functions and automatic hybrid bitmap indexing and LINQ query filters