Skip to content

Business Intelligence Tools

  • BusinessObjects

Databases

Oracle

  • Fun with NULL
  • How to Restore a Table in Oracle
  • How to Generate Random Data in Oracle
  • Use of Index and Characterset
  • Language and Use of Indexes in Oracle
  • Script to kill user sessions in Oracle
  • Comparison of database schemas
  • How to print explain plan
  • Selectivity and Execution Plan

SQL Server

  • Creating ODBC system DNS with command line
  • Example of an Indexed View in SQL Server
  • How to Allow Remote TCP/IP Connections for SQL Server
  • Misc. Dates – SQL Server
  • How to Kill Active Connections to SQL Server database
  • Creating Aggregate Tables
  • How to Find Running Queries – SQL Server
  • Hierarchical (Recursive) Queries in SQL Server
  • Lock information in SQL Server
View Dmytro Bukhantsov's profile on LinkedIn

Unx Universe Documenter

Biclever Unx Documenter is a tool for extracting Unx metadata to Excel. Free. Does not require installation.

Unv Universe Documenter

Create documentation of your Unv universes in Excel format with free tool Biclever Unv Documenter

CMS Query Builder

Biclever CMS Query Builder - free tool for querying CMS database and exporting the result to Excel

About

This is a blog about business intelligence, data warehousing, databases, programming etc. The opinions expressed here represent my own and may or may not reflect the opinions or policies of my employer. The site is not endorsed by or affiliated with SAP, SAS, Oracle, Microsoft etc. The information, source code, and software available on this web site is provided "as is" without warranty of any kind blah-blah-blah...

Business Intelligence Tools, Proudly powered by WordPress.