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

Using C# for Inserting CLOB Data in Oracle

3 Aug 2007 by ace

Inserting CLOB data into an Oracle table using C#.

SQL Database Restore

1 Apr 2009 by Ahmet Göktaş

T-SQL string maker for backup with a MEDIAPASSWORD database.

Simple Pattern Matching Technique to Improve the Search Boxes

20 Dec 2010 by Albin Abel

Simple Pattern Matching Technique for Search Suggest Boxes

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.

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.

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

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)

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.

Data Visualization using Matplotlib

24 Apr 2019 by Azim Zahir

This article demonstrates Data Visualization using Matplotlib library of Python.

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.

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

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.

Interaction between C# Application and Oracle through Custom Object

1 Jan 2011 by Bibhas Paul

Interaction between C# application and Oracle through custom Object

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!

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

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.

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.

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

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"

TNSNames Reader

13 Nov 2008 by cirovladimir

An article explaining how to list oracle data sources from tnsnames.ora file

Oracle

Dev

DBA

Generate Classes and CRUD Procedures

5 May 2009 by ColinBashBash

Generate classes / CRUD procedures.

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.

How to Insert a DateTime Value into an Oracle Table

17 Jul 2017 by Database Star

This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.

SQL

Oracle

Merge Data in Database

28 Jun 2022 by DiponRoy

How to use MERGE statements in different databases

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

Using CURSOR in Different Databases

27 May 2019 by DiponRoy

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

Return DataTable Using Entity Framework

5 Apr 2020 by DiponRoy

Select data as DataTable object for a database using Entity Framework

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

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

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

DBTool for Oracle - Part 1

13 Apr 2014 by Espen Harlinn

Enhance productivity and reliability, write your own tools.

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.

The Oracle Call Interface (OCI) and ODP.Net - Part 1

23 Mar 2021 by Espen Harlinn

Proven techniques for fast Oracle Database access using .NET 5.0 and native C++

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.

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.

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

Facade to disparate databases

19 Sep 2013 by G3Coder

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

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

Sql180 Developer

25 Oct 2008 by Guy Haim

A Graphic tool for Oracle developers and DBAs

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.

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

Alternative tnsping utility

3 Jan 2013 by hevesir

Alternative tnsping for Oracle Instant Client.

Returning Multiple Ref Cursors from Oracle using DAAB

9 Jun 2009 by himanshu2561

How to return multiple ref cursors from Oracle using DAAB

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.

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.

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.

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.

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

Fluent Database Access

1 Mar 2016 by Jörgen Andersson

Fluent database access

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

DBMapper - A New ORM Tool

2 May 2013 by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

Check Database Size with Summary

22 Jun 2009 by Kuldip Rindani

This script calculates size of every user database with summary

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

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

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

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.

Extending Kerosene ORM for WCF support

2 Mar 2015 by mbarbac

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

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

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

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

Oracle Materialized Views under ETL Processes, an Opportunity Cost Approach

30 Jan 2018 by Member 11127135

Oracle materialized views under ETL processes

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

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.

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

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

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

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.

Simplified ORM with NW.ORM

29 Oct 2013 by Ogwara Rowland

NW.ORM, a helper framework for working Hibernate.

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

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

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

The Time Machine

9 May 2012 by Petr Ivankov

Long time strategy of software design and development

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

Audit Trail – Tracing Data Changes in Database

30 Aug 2010 by Petr Kozelek

Logging of data changes in relational databases

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

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.

Joining Tables in SQL

3 Apr 2013 by Pierre Kellerman

Explaining different ways to join tables

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

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?

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)

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.

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

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.

ADO.NET Interview Questions: Part 1

20 Mar 2012 by Shivprasad koirala