Blog entries

How to resolve Error 15 - "Not a Table / Database " in Foxpro

Rahul Vairagi — Tue, 07 Sep 2010 15:17:56 +0100

When You tried to open existing table in foxpro and got "ERROR-15- "NOT A DATABASE" message. What is the mean of this error ? why it occurs?

This error occurs when your table is corrupted.

Reasons of corruption:

Unexpected System shutdown
Virus Infection
MS Visual FoxPro malfunction
Operating system

corruptioRead More...

The First and Last Step towards Website Submission

Rahul Vairagi — Tue, 07 Sep 2010 15:14:15 +0100

What is DMOZ or OPD

The <b>DMOZ (Directory Mozilla) or Open Directory Project (ODP)</b> is the most comprehensive human edited directory of the Web which is compiled by a vast global community of volunteer editors. Majority of search engines including AOL Search, Netscape Search, Google, Lycos, DirectHit, and hundreds of others get their data from OPD. So if your site is listed on OPD it becomes automatically listed on maRead More...

Spoolsv.exe error – What causes it and how to fix Spoolsv.exe error easily?

Rahul Vairagi — Tue, 07 Sep 2010 15:12:12 +0100

Spoolsv.exe is a very important process for Windows-based operating systems. It will execute the Dll files and then put them into system memory so as to ensure the proper running of the computer. However, when using the computer, users are always getting the Spoolsv.exe error message such as Spoolsv.exe not found problem. Here, I will show you the causes and corresponding solutions to fix Spoolsv.exeerror.

What causes Spoolsv.exe error?

The Spoolsv.exe error can be caused by a Read More...

A Common Mistake Traders Make When Day Trading

Rahul Vairagi — Tue, 07 Sep 2010 15:08:20 +0100

Anyone who watches daytime television is well aware of several news networks that broadcast nonstop financial news. Generally speaking, these networks parade a variety of experts in front of the camera who spout all sorts of interesting and apparently insightful information about market conditions during the day. Early in my career, many years ago, I faithfully listened to all the rumors and innuendo the financial news network's reported. At some point in my career, I learned to turn the teleRead More...

Blogs will be related to cloud computing and other new stuffs

Madhusudhan G Revankar — Thu, 19 Aug 2010 11:19:57 +0100

3 Lakh Jobs in Cloud Computing in India

Cloud Computing is the latest buzzword in the web world as it brings in a paradigmatic shift. It is the internet based computing where shared resources, software and information are made available to computers and other devices on demand. Amazon, Google and Microsoft are the major cloud service providers.

The providers believe that India holds immense potential to emerge as the global competency center for cloud services. With a powerful ecRead More...

Triggers

Vinod — Wed, 18 Aug 2010 19:29:40 +0100

use master
create database bindu
on primary
(
name='vinod',
filemane='C:vinodvinodbindu.mdf',
size=10mb,
maxsize=20mb
)
log on
(
name = 'bindu',
filename = 'C:vinodindu_log.ldf',
size = 5mb,
maxsize = 10mb
)

--Day5 13/08/2010 DB-Development
_________________________________________________________
TRIGGERS

1.) DDL Triggers:- (Database triggers) Fires on DDL statements like CREATE TABLE,CREARead More...

SQL-History

Vinod — Wed, 18 Aug 2010 19:20:18 +0100

It times back to 1980s, when Oracle had already had a very large base on database market. Microsoft, most of the people who are aware of, wanted to establish its presence in the RDBMS market to compete with Oracle. Hence the story goes on.......

In 1987 Microsoft and Sybase started a partnership to build/sell a Database Management System, based on the then (yet to be released) Sybase DataServer product. Sybase would have the rights to the product on the Unix/Mini Platform aRead More...

Mypractice-5

Vinod — Wed, 18 Aug 2010 18:59:24 +0100

create database vinod
on primary
(
name = 'vinod',
filename = 'C:SQLtestvinod.mdf',
size = 10mb,
maxsize = 20mb
)
log on
(
name = 'Vinod_log',
filename = 'C:SQLtestVinod_log.ldf',
size = 6mb,
maxsize = 8mb
)
Backup database vinodto disk = 'C:SQLtestvinod_full.bak'
create table doniv
(
id int,
name varchar(20),
Qualification Varchar(25)
)
Backup database vinod to disk Read More...

Mypractice-4

Vinod — Wed, 18 Aug 2010 18:58:19 +0100

restore database slktestdb from disk = 'C:SQLtestslktestDB_Log.bak' with norecovery
restore log slktestdb from disk = 'C:SQLtestslktestDB_Log.bak' with norecovery
restore database slktestdb from disk = 'C:SQLtestslktestDB_diff.bak' with norecovery
restore database slktestdb from disk = 'C:SQLtestslktestdb_full.bak' with norecovery
restore database slktestdb with recovery
select getdate()
restore log slktestdb from disk = 'C:SQLtestslktestDB_Log.bak' with stopat =Read More...

My Practice-3

Vinod — Wed, 18 Aug 2010 18:57:00 +0100

create database slktestdb
on primary
(
name = 'slktestdb',
filename = 'C:SQLtestslktestdb.mdf',
size = 10mb,
filegrowth = 1mb,
Maxsize = 20mb
)
log on
(
name = 'slktestdb_log',
filename = 'C:SQLtestslktestdb_log.ldf',
size = 5mb,
filegrowth = 1mb,
Maxsize = 10mb
)

sp_addumpdevice 'disk','slktestdbDevice','C:SQLtestslktestdb.bak'
backup database slktestdb to slktestdbDevice
backup database slktestdRead More...

My practice-2

Vinod — Wed, 18 Aug 2010 18:55:09 +0100

use slktestdb
select * from sys.filegroups
select * from sys.data_spaces
alter database slktestdb
add filegroup Sec

alter database slktestdb
add file
(
name = sec_file,
filename = 'C:SQLTestsec_file.ndf',
size = 10mb,
filegrowth = 1mb,
maxsize = 15mb
) to filegroup Sec

alter database slktestdb
modify filegroup Sec Readonly

select * from sys.sysfilegroups
select * from sys.filegroups

alter databasRead More...

Practice

Vinod — Wed, 18 Aug 2010 18:40:24 +0100

“Discovering the unexpected is more important than confirming the known.”

Satish — Wed, 18 Aug 2010 18:22:35 +0100

Day6-Dev-2

Chillagatta Adarsh — Sat, 14 Aug 2010 20:32:50 +0100

______________________________________________________________________________________________
EXCEPTION HANDLING:

ERRORS:
1.) Syntax errors: When keyword and grammer is not properly used
2.) Logical errors: When desired is not there
3.) Exception Errors: External errors happen situationally for divide by zero,primary key errors

Using Try-Catch Exceptions are handled
syntax:
Begin try
--Statements
End try
Begin Catch
--StatementsRead More...

DB-Dev-Day6

Chillagatta Adarsh — Sat, 14 Aug 2010 16:32:50 +0100

--Day6 DB-Devolopment
create procedure sp_calbonus_cur (@did int)
as
declare @ecode int, @salary money, @bonus int

open emp_cur
fetch next from emp_cur into @ecode,@salary
while @@fetch_status = 0
begin
print 'Emp Code:' + convert (char(5), @ecode)

select * from dapartment
select * from employees
alter table employees
add bonus float, dname varchar(25)
update employees set bonus = 111, dname = 'Account', salary = 1111 Read More...

TRIGGERS

Vinod — Fri, 13 Aug 2010 21:36:06 +0100

--Day5 13/08/2010 DB-Development
_________________________________________________________
TRIGGERS

1.) DDL Triggers:- (Database triggers) Fires on DDL statements like CREATE TABLE,CREATE VIEW,DROP TABLE, etc
2.) DML Triggers:-(Table triggers) Fires on DML statements like INSERT,DELETE and UPDATE......

Use of triggers:-
Data security like rolling back un-wanted operations
Automatic Calculations and Operations

syntax:
CREATE TRIGGER droptrig

DevDay5-Triggers

Chillagatta Adarsh — Fri, 13 Aug 2010 21:35:54 +0100

--Day5 13/08/2010 DB-Development
_________________________________________________________
TRIGGERS

Use of triggers:-
Data security like rolling back un-wanted operations
Automatic Calculations and Operations

syntax:
CREATE TRIGGER droptrig

DB-Development4

Chillagatta Adarsh — Thu, 12 Aug 2010 21:21:16 +0100

--Day4 DB-Development, 12/8/2010
--------------------------------------------------------------------------------
Grouping and Sorting
--------------------------------------------------------------------------------

use employeeDB
select * from employees

alter table employees
update employees set salary = 4550 where ecode = 105
update employees set deptid = 209 where ecode = 105

select * from employees

select * from employees
ordeRead More...

DB_Dev_Day2

Chillagatta Adarsh — Tue, 10 Aug 2010 21:19:05 +0100

--Day2 10/8/2010, DB Devolopment training

SIngle valued operators: =,<,>,
Multi Valued operator: IN,ALL,ANY
< ANY
>ANY

<ALL --lessthan the minimum
>ALL --greater than the max
IN

use employeeDB
select * from dapartment

SELECT employee1.ecode, employee1.deptid, dapartment.dname
FROM dapartment FULL OUTER JOIN employee1 ON dapartment.deptid = employee1.deptid

SELECT dnRead More...

DB-Develop-1

Chillagatta Adarsh — Mon, 09 Aug 2010 20:40:41 +0100

--Date 9/8/2010, Monday-DB development training

--Creating Tables

--DDL Commands
create table employees
(
ecode int,
ename varchar(20),
salary int,
deptid int
)
--DML Commands
insert into employees values(101,'aaa',1111,201)
--insert fewer column values
insert into employeees(ecode,ename,deptid) values(101,'aaa',201)

--delete records(all)= Unconditional deletion
delete from employees
insert into employees vRead More...