Join Us!

Spaces are allowed; punctuation is not allowed except for periods, hyphens, and underscores.
A valid e-mail address. All e-mails from the system will be sent to this address. The e-mail address is not made public and will only be used if you wish to receive a new password or wish to receive certain news or notifications by e-mail.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

Login

Enter your Project Envision username.
Enter the password that accompanies your username.
Request new password

Krystian Zieja's blog

How to enable AUTOTRACE in Oracle

Oracle SQL*Plus has a neat feature called AUTOTRACE, which enables us to get execution plan and additional statics about the running SQL statement. The main difference between AUTOTRACE and EXPLAIN PLAN is that AUTOTRACE actually executes the SQL statement. AUTOTRACE can be a helpful tool in Oracle Developer or Oracle DBA hands to check performance of SQL statements.

Categories:

Sql Server Convert YYYYMMDD to Date

Sql Server Administrators often face a problem when working with some application, in which their developers decided to store dates as integers. In those applications the dates are stored as integers in format YYYYMMDD. This post will illustrate how to convert YYYYMMDD format to smalldatetime data type and back on Microsoft Sql Server.

ORA-01536: space quota exceeded for tablespace

ORA-01536: space quota exceeded for tablespace is a common error in Oracle Database.
It means that users is trying to use more space than the Database Administrator assigned to him. Quota is a maximum number of bytes that a user can allocate in particular tablespace. Implementing quotas in database is a reasonable approach because it prevents buggy or malicious code to fill the tablespace.

Categories:

How to check MX records of mail server

Sometimes Mail Servers administrators have problem with receiving mails. One of the first things to troubleshoot is the MX record of their mail server in DNS. We can do it by using many online services or by using simple tools like nslookup or dig. One thing to note dig is Linux utility, while nslookup can be found on both Windows and Linux systems.

Categories:

How to check the version of Microsoft Sql Server

Often we need quickly check the version of the Microsoft Sql Server. The quickest way to do it is to use @@VERSION. However there is one more method, which is often overlooked by Database Administrators, the extended stored procedure xp_msver.

How to truncate the same table in several schemas in Oracle

Sometimes Oracle Database Administrators receive some strange requests like dropping or truncating the same table in several schemas. Obviously we can do such requests manually, but it would be time consuming and very hard to automate. Instead of performing such requests manually we can use a handy script.

Categories:

How to take database offline in Sql Server

Sometimes we want to disable user access to database without deleting or detaching that database. The easiest way to do it is to take database offline. Taking database offline can be performed using Transact-Sql or Sql Server Management Studio.

How to list all database files in SQL Server

When preparing the Sql Server Migrations or performing audits is to list all database files on the server. One way to do it is to go to each database and query sysfiles. However this approach is not too handy where we have many database on a server.

Categories:

Filtering numeric data from character based column

It is quite often asked question how to select only numeric data from character based column. Using Sql Server makes this task usually easy, you just need to use IsNumeric function.

create table t1( 
c1 varchar(10)
);

insert into t1(c1) values('Krystian');
insert into t1(c1) values('10');
insert into t1(c1) values('13.5');
insert into t1(c1) values('- 13.5');
insert into t1(c1) values('100.25.55');

select * from t1;

Krystian
10
13.5
- 13.5
100.25.55

How to convert Unix timestamp to Oracle date

Let's start from some theory, "what is unix timestamp?".
The unix timestamp is the way to measure time as a running total number of seconds after Unix epoch. Unix epoch started at 1st, January 1970 00:00:00 UTC. The often asked question is how to convert Unix timestamp to Oracle date.

Categories: