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

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

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.

Facade to disparate databases

19 Sep 2013 by G3Coder

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

Oracle 11g Report Installation on RedHat Linux 5x

22 Nov 2011 by Srivalsalakumar

Oracle 11g Report Installation on RedHat Linux 5x

Oracle

DBA

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

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

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

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

Calling Oracle's Stored Procedures and Mapping User Defined Types (UDTs) from ASP.NET

26 Sep 2018 by MattiLindroth

An example on how to call Oracle stored procedures with UDTs from ASP.NET MVC / REST API

Data Visualization using Matplotlib

24 Apr 2019 by Azim Zahir

This article demonstrates Data Visualization using Matplotlib library of Python.

Using CURSOR in Different Databases

27 May 2019 by DiponRoy

Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases

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.

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

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

BigDL: Distributed Deep Learning on Apache Spark

19 Apr 2017 by Intel

This article introduces BigDL, shows you how to build the library on a variety of platforms, and provides examples of BigDL in action.

Alibaba Cloud Object Storage vs. IBM Cloud and Oracle Cloud Equivalent

5 Jan 2018 by Brien M. Posey

In this article, we compare the object storage offerings of each of these cloud providers.

cloud

Oracle

Prepare (Oracle) SQL for Spooling

16 Aug 2019 by Marijan Nikic

An HTML tool written in JavaScript to convert a regular Oracle SQL query into a spooling script

Deploy Arm Instances on Oracle Cloud Infrastructure (OCI) using Terraform

N 11 Apr 2024 by Frédéric -lefred- Descamps

How to deploy Arm instances on Oracle Cloud Infrastructure (OCI) using Terraform

Deploy MySQL and WordPress on an always free tier Arm shape

N 12 Apr 2024 by Frédéric -lefred- Descamps

How to install WordPress on Oracle Cloud Infrastructure (OCI) using always free tier

Full text search with Oracle Text

8 Nov 2005 by fstrahberger

How to do full text search with Oracle Text

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.

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

Alternative tnsping utility

3 Jan 2013 by hevesir

Alternative tnsping for Oracle Instant Client.

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.

How Toad DevOps Toolkit can help with the DevOps process

30 Jan 2018 by Quest Software

If you wanted to ramp up database DevOps, which development tasks would be most important for you?

Map/Reduce script in NetSuite with SuiteScript 2.0

20 Dec 2018 by Benktesh Sharma

An illustration of working with Map/Reduce paradigm in the NetSuite cloud.

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.

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.

Visual Representation of SQL Joins

3 Feb 2009 by C.L. Moffatt

This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.

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!

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"

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

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

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.

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

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.

DBTool for Oracle - Part 1

13 Apr 2014 by Espen Harlinn

Enhance productivity and reliability, write your own tools.

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)

The Time Machine

9 May 2012 by Petr Ivankov

Long time strategy of software design and development

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

Custom Aggregates in Oracle

19 Mar 2011 by Wendelius

How to create custom aggregates in Oracle using PL/SQL

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

QxOrm - C++ ORM (Object Relational Mapping) Library

24 Apr 2019 by QxOrm

QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)

Extending Kerosene ORM for WCF support

2 Mar 2015 by mbarbac

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

Return DataTable Using Entity Framework

5 Apr 2020 by DiponRoy

Select data as DataTable object for a database using Entity Framework

Fluent Database Access

1 Mar 2016 by Jörgen Andersson

Fluent database access

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

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.

Building a Framework - Part I (DAL)

5 Feb 2014 by V.

First article on creating a reusable framework

Joining Tables in SQL

3 Apr 2013 by Pierre Kellerman

Explaining different ways to join tables

Audit Trail – Tracing Data Changes in Database

30 Aug 2010 by Petr Kozelek

Logging of data changes in relational databases

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

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.

11 important database designing rules which I follow

25 Feb 2014 by Shivprasad koirala

This article will discuss about 11 important database designing rules.

How To Receive Oracle Database Change Notification using WCF SOA Technology with netTCPBinding, netNamedPipeBinding and wsdualHTTPBinding

6 Mar 2009 by kamran anwar (Software Engineer)

WCF Oracle Database Change Notification Application

Interaction between C# Application and Oracle through Custom Object

1 Jan 2011 by Bibhas Paul

Interaction between C# application and Oracle through custom Object

DBMapper - A New ORM Tool

2 May 2013 by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

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.

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

Sql180 Developer

25 Oct 2008 by Guy Haim

A Graphic tool for Oracle developers and DBAs

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.

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.

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

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.

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.

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.

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

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.

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.

Executing Raw SQL Queries using Entity Framework Core 6

9 Aug 2022 by DiponRoy

Run Raw SQL Query - Entity Framework Core 6

Oracle

entity-framework

SQL-Server

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

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

Oracle data into Excel sheet

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

How to capture a Window as an Image and save it

15 Jun 2007 by dmihailescu

Take a snapshot of the main Window of any UI application

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

SQL Joins

20 Aug 2010 by Vivek Johari

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

Oracle

SQL-Server

Passing an Array as Parameter to SQL Server Procedure

13 May 2009 by Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

Rednet DataAccess

18 Jul 2021 by Rednet Software

Rednet.DataAccess is yet another component to work with data that simplifies your use.

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.

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

Simple Pattern Matching Technique to Improve the Search Boxes

20 Dec 2010 by Albin Abel

Simple Pattern Matching Technique for Search Suggest Boxes

Simplified ORM with NW.ORM

29 Oct 2013 by Ogwara Rowland

NW.ORM, a helper framework for working Hibernate.

Multidatabase Text Search Tool

21 Dec 2017 by Miguel Diaz Kusztrich

A database tool for search text in procedures, views and tables using regular expressions

Merge Data in Database

28 Jun 2022 by DiponRoy

How to use MERGE statements in different databases

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.

Delete duplicate entries from a data store while leaving a single copy

5 Apr 2009 by Tarek Najem

How to delete duplicate entries from a data store, while leaving a single copy.

Oracle Materialized Views under ETL Processes, an Opportunity Cost Approach

30 Jan 2018 by Member 11127135

Oracle materialized views under ETL processes

Returning Multiple Ref Cursors from Oracle using DAAB

9 Jun 2009 by himanshu2561

How to return multiple ref cursors from Oracle using DAAB

Data Access Component

30 Apr 2009 by zhongzf

An open source Data Access Component

A Very Simple Oracle Query Tool

11 Jul 2008 by Syed M Hussain

This is a very simple tool, to query an Oracle XE database

ADO.NET Interview Questions: Part 1

20 Mar 2012 by Shivprasad koirala

Ado Dot Net Interview Question Part 1

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.

Reporting Services 2008 – Embedding a PDF Document

29 Mar 2009 by Steve MunLeeuw

Embedding the content of a PDF document is not supported, but we can add this feature with a SQL CLR function to parse the PDF into a list of images.

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.

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.