This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.

SQL

Oracle

SQL-Server

Design

SysAdmin

Dev

Highly Effective Data Insertion at Case of Oracle DB

31 Oct 2016 by SlavaUtesinov

EF implementation of BulkInsert operation and "Arrays in a Bind" solution at case of absence of EF.

entity-framework

Oracle

Automatically Define the State of All Entities in the Graph in EntityFramework

9 Oct 2016 by Farhad Jabiyev

One of the most popular questions is whether there exists a method which will automatically decide whether to insert, update or delete entity in the Entity-Framework. Now it is possible with EntityGraphOperations library.

Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor

7 Oct 2016 by Paulo Uechi

Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor written and developed in Java and C # for all Linux and Windows platforms. The Uechi.APM.Web offers a complete resource for unlimited monitoring servers in real time. Have full control of the CPU cons

This will not be in BI (Purchasing a BI tool, you do not get this)

17 Apr 2016 by Alex_2979

A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.

Fluent Database Access

1 Mar 2016 by Jörgen Andersson

Fluent database access

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

Hadoop For .Net & AngularJS Developers

29 Dec 2015 by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Javascript

.NET-Compiler-Platform

Oracle 12c Installation on Windows 7 (Step by Step Solution)

5 Sep 2015 by Sadique KT

How to Install Oracle 12c, How to create listener, How to create TablesSpaces and How to restore database

Win7

Windows

Oracle

How to Download and Set Up Oracle Express 11g

11 Apr 2015 by Database Star

This article explains how to download and install Oracle Express and SQL Developer on your own computer, to get started with running SQL queries.

Extending Kerosene ORM for WCF support

2 Mar 2015 by mbarbac

Kerosene ORM support for complete database-alike WCF services and connections

Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#

1 Mar 2015 by mbarbac

The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.

Kerosene ORM Maps In Depth

1 Mar 2015 by mbarbac

A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.

Kerosene ORM Dynamic Records In Depth

1 Mar 2015 by mbarbac

A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library

Quick Introduction to YB.ORM - Object Relational Mapper for C++

30 Oct 2014 by Vaclav Naydenov

How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.

Real-time Oracle Database Monitoring Dashboard in ASP.NET

29 Sep 2014 by Omar Al Zabir

Oracle Performance Dashboard (OPD) is a small ASP.NET website that shows you performance & problems of one or more Oracle instances in near real-time. It uses the Dynamic Performance Views (DPV) and runs some popular DBA scripts in order to get meaningful, easy to understand information out of the s

EpOraLibrary - A lightweight C++ wrapper over Oracle's OCI library

2 Jun 2014 by Chris La

This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"

An Oracle OCI Data Source Class for Ultimate Grid, Part 3, Sample Application

22 May 2014 by djc2032

A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid

An Oracle OCI Data Source Class for Ultimate Grid, Part 2 - Building the OCI Data Source Class

22 May 2014 by djc2032

A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid

Oracle ADF Mobile Tutorial

24 Apr 2014 by FaizanMubasher

This article helps developer to start working with new mobile application development framework Oracle ADF Mobile.

DBTool for Oracle - Part 1

13 Apr 2014 by Espen Harlinn

Enhance productivity and reliability, write your own tools.

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

11 important database designing rules which I follow

25 Feb 2014 by Shivprasad koirala

This article will discuss about 11 important database designing rules.

Building a Framework - Part I (DAL)

5 Feb 2014 by V.

First article on creating a reusable framework

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

Entity Framework 5 vs. NHibernate 3.3 with Oracle 11g

4 Dec 2013 by Alexander Iskhakov

A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.

Simplified ORM with NW.ORM

29 Oct 2013 by Ogwara Rowland

NW.ORM, a helper framework for working Hibernate.

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

18 Oct 2013 by Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!

DBTool – Part 2: Harlinn.Oracle

1 Oct 2013 by Espen Harlinn

A reflection based wrapper for the Oracle Data Provider for .NET – allows your application to dynamically load the Oracle.DataAccess.dll assembly installed on your client’s computer.

Facade to disparate databases

19 Sep 2013 by G3Coder

Details using an ORM model to provide a common facade to multiple disparate databases.

Implementation of Database Assertions

8 Aug 2013 by h_wiedey

An approach using updatable views with check option and deferred constraint checking.

SQL

Oracle

SQL-Server

Comparison of Triggers in MS SQL and Oracle

29 Jul 2013 by h_wiedey

The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.

DBMapper - A New ORM Tool

2 May 2013 by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

Web-based Data Access Object for Unmanaged Application

25 Apr 2013 by In the Face of God

Unmanaged code application accessing data in a database via Web Services without a database provider.

Oracle PL/SQL Cursor

19 Apr 2013 by Girish Yerzal

This article will definitely give you a brief idea about cursor with examples.

Windows

Oracle

Joining Tables in SQL

3 Apr 2013 by Pierre Kellerman

Explaining different ways to join tables

GUIDs as fast primary keys under multiple databases

15 Mar 2013 by Jeremy Todd

Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.

Alternative tnsping utility

3 Jan 2013 by hevesir

Alternative tnsping for Oracle Instant Client.

Oracle data into Excel sheet

3 Jul 2012 by Muammar©

Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value

The Time Machine

9 May 2012 by Petr Ivankov

Long time strategy of software design and development

Logging information in Oracle

30 Apr 2012 by Wendelius

This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.

Examples for Creating Oracle Functions

1 Apr 2012 by Wendelius

The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.

ADO.NET Interview Questions: Part 1

20 Mar 2012 by Shivprasad koirala

Ado Dot Net Interview Question Part 1

Build a customized report using Oracle APEX

6 Mar 2012 by nguyenannhon

This article introduces the steps to create a report with a custom search area.

Encrypt Personal Data in Database using Bouncy Castle and Java Simplified Encryption

13 Feb 2012 by Chinthala Upender

Bouncy Castle provide encrypt/decrypt your personal data such as password, SSN, credit card numbers etc. using Simple JASYPT framework.

Java

Windows

Oracle

DALC4NET: A Generic Data Access Layer for .NET

1 Feb 2012 by Ashish Tripathi

DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel.

Mimicking SQL Server identity column in Oracle

8 Jan 2012 by Wendelius

This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.

Oracle database 11g release 2 installation on suse and Enterprise Linux

3 Dec 2011 by Srivalsalakumar

Oracle database 11g release 2 installation on suse and Enterprise Linux

Oracle

Oracle 11g Report Installation on RedHat Linux 5x

22 Nov 2011 by Srivalsalakumar

Oracle 11g Report Installation on RedHat Linux 5x

Oracle

DBA

Solving performance issues in data migration to SQL Server

10 Nov 2011 by Phani Krishna Kollapur Gandla

How to solve performance issues in data migration to SQL Server.

Migration of Relational Data structure to Cassandra (No SQL) Data structure

10 Nov 2011 by Phani Krishna Kollapur Gandla

Migration of Relational Data structure to Cassandra (No SQL) Data structure

DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV

20 Sep 2011 by Pieter Van Parys

Creating profiling information in our ProxyDbxxx classes

Installing Oracle 11g XE (Express Edition)

14 Sep 2011 by Wendelius

This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer

Export/Import an Oracle database with date range without constraint issues

13 May 2011 by J Chandra Sekhar Achary

Useful tips for Oracle import/export to address constraint issues.

CLOB Comparison Line by Line in PL/SQL

18 Apr 2011 by Manuel Vidigal

An implementation of the Longest Common Subsequence (LCS) diff algorithm in PL/SQL.

SQL

Oracle

Dev

Custom Aggregates in Oracle

19 Mar 2011 by Wendelius

How to create custom aggregates in Oracle using PL/SQL

Oracle PL/SQL collections

3 Mar 2011 by sandip_bhadane

This article briefs about different types of PL/SQL collections, their advantages, how to pass an array to stored procedure from ASP.NET application, etc.

A Small Utility to Generate Cascading Delete SQL Script in Oracle

22 Feb 2011 by ronald.cao@gmail.com

The article is to introduce a utility to generate cascading delete script for an Oracle table.

Interaction between C# Application and Oracle through Custom Object

1 Jan 2011 by Bibhas Paul

Interaction between C# application and Oracle through custom Object

Simple Pattern Matching Technique to Improve the Search Boxes

20 Dec 2010 by Albin Abel

Simple Pattern Matching Technique for Search Suggest Boxes

Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion

9 Dec 2010 by AnupKumarYadav

Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)

Generate Complete .NET Applications in Minutes!

18 Oct 2010 by carl.b.anderson

This article gives you an overview of how you can quickly develop .NET applications using the pragmatic CodeFluent Entities software factory. This tool generates ready-to-use components from a simple model and provides you multiple out-of-the box architecture options.

Audit Trail – Tracing Data Changes in Database

30 Aug 2010 by Petr Kozelek

Logging of data changes in relational databases

SQL Joins

20 Aug 2010 by Vivek Johari

This article is written to describe all the different types of Sql Joins

Oracle

SQL-Server

ADO.NET DataTable as XML parameter to an Oracle/SQL Server Database Stored Procedure

27 Jan 2010 by Bibhas Paul

ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.

Custom Paging GridView in ASP.NET & Oracle.

1 Dec 2009 by Murali Manohar Pareek

ASP.NET Gridview with Default and Custom Paging, Sorting, Export Data, Freeze Header, Column Resizing, Row Hover, Row Selection, Grid Cell Tooltip features for better Performance, functionality and GUI with Oracle Database

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5

19 Sep 2009 by Paul Rony

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application

Very fast test data generation using exponential INSERT

28 Aug 2009 by weilidai2001

Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.

Using User Defined Functions in Table Inserts and Seeding with Stored Procedures

26 Aug 2009 by Andy_L_J

Generate unique column values using UDFs and Stored Procedures

Nullable datetime column in .NET DataGrid with DateTimePicker

17 Aug 2009 by vic_ch2000

A nullable datetime column in .NET DataGrid with DateTimePicker.

WPF INotifyPropertyChanged With CodeDom and Reusing DataReader Code for Oracle and SQL Server

24 Jun 2009 by HarishBhattbhatt

Generic coding with Codedom and IDataReader class usage

Check Database Size with Summary

22 Jun 2009 by Kuldip Rindani

This script calculates size of every user database with summary

Overview of XQuiSoft Data Using the Provider Pattern (Open Source)

16 Jun 2009 by Mike Lang

A data abstraction layer for .NET applications. Write your application code to be database neutral. Swap out the type of database your application uses without updating or even recompiling your business components.

Returning Multiple Ref Cursors from Oracle using DAAB

9 Jun 2009 by himanshu2561

How to return multiple ref cursors from Oracle using DAAB