Bukhantsov.org

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

Example of an Indexed View in 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

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...

Copyright © 2018 Bukhantsov.org. Entries (RSS). Clean Simple White Theme by Mazznoer. Powered by WordPress.

Business Intelligence Tools