Always remain updated about current software development trends

Articles in DATABASE

LLBLGen Pro feature highlights: assigning attributes based on rules to properties in generated code.

By FransBouma

(This post is part of a series of posts about features of theLLBLGen Prosystem)One of the things which makes some people hate generated code is that it's effectively 'read-only' code: changing it will make you run the risk that your changes are likely gone...

SQL Server Prefetch and Query Performance

By Fabiano Amorim

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries...

A first look at SQL Server 2012 Availability Group Wait Statistics

By Joe Sack

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize...

Control trigger logic based on user

By Mika Wendelius

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

CRUD Operation in ASP.NET Web Applications Using HTTP Handler and jQuery

By Jigar Bagadai

Easy approach to implement AJAX in ASP.NET without using an AJAX control

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

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

Maximize Availability with Oracle Flashback Database Feature

By margaret hamburger

The calmest IT guy in the world understands what it takes to recover quickly from human errors. Learn more about Oracle Flashback recovery features and Oracle Database 11g maximum availability...