Posts

SQL Stored Procedure In SQL Server Management Studio

The main purpose of stored procedures to hide direct SQL queries from the code and improve performance of database operations such as SELECT, UPDATE, and DELETE data.SQL stored procedure is a collection of SQL commands and SQL logic. It also can be use as caches and reused. Type of stored procedure There are two types of stored procedure: User defined stored procedure System defined stored procedure User defined stored procedure It developed by database developer or database administrators. These Stored Procedure contains one or more SQL statements to SELECT, UPDATE or DELETE records from database table. It can take input parameters and produce output parameters.It is a mixture of Data Definition Language and Data Manipulation Language commands. User Defined Stored Procedure can classified into two types: T-SQL Stored Procedure                        Transact SQL (T-SQL) Stored Procedures receive and ret...

Firewall

Image
We can easily said that firewall is a program which is prevents unauthorized access to or from a private network. Firewalls are tools that can be used to enhance the security of computers connected to a network, such as LAN or the Internet. They are an integral part of a comprehensive security framework for your network. What firewall do? Defend resources Validate access Manage and control network traffic Record and report on events Act as an intermediary A Personal firewall is important when You surf the Internet at home using an 'always on' broadband connection You connect to the Internet via a public WiFi network in a park, cafe or airport You run a home network which needs to be kept isolated from the Internet You wish to be kept informed when any program on your computer attempts to connect to the Internet Most Personal Firewalls are highly configurable so you can easily create security policies to suit your individual needs.

Basics Of Cloud Computing

Image
Hi folks, Here I want to discussing about cloud computing. Most of the person may be heard about cloud computing. Cloud computing referred as  "PAY AS YOU GO" it means you can use the software ,operating system, database , servers or any other services as your needed periods. while you are using the system you can pay for it. Here we can shortly lookup what are the benefits on cloud computing. Flexibility. Disaster recovery. Automatically software updates. Capital-expenditure free. Cloud Services   SAAS : This acronym is refereed as Software As A Services. It is being used by normal end users who don't have much aware of the software and their purpose is just using it. eg:- Google drive, Facebook, Salesforce ,Yahoo mail and etc. PAAS : This acronym is refereed as Platform As A Services. It is being used by developers. They can build , compile and run heir programs without worrying of the underlying infrastructure. eg :- windows azure, LongJump, Ama...

Introduction of Amazing Web Services

Image
Quick Inro of Amazon Web Services.  Amazon web services is a leader of the cloud computing platform provided by amazon.com which is a pioneer of Internet services. 57% of the cloud services are provided amazon web services. AWS services and product   Compute :  Amazon EC2 Amazon Elastic Beanstalk Amazon Lambola Auto scaling Elastic load blancer Amazon VPC Storage : Amazon S3 Amazon cloud front Amazon EBS Amazon Glacier AWS snowball AWS storage gateway Database : Amazon RDS Amazon DynamoDB Amazon Elastic Cache Amazon Redshift  Networking : Amazon VPC AWS Direct connect Elastic load Balancer Amazon Route S3 Management tool : Amazon cloud waste AWS cloud information AWS cloud trail AWS Ops Works AWS trusted advisor Security & identity : AWS identity Access Management(IAM) AWS key management services (KMS)  Application services : Amazon AES Amazon SNS Amazon SQS

Media fire

Image
Hi folks, "Mediafire" this word may uncommon for many one nut this is a new term for using cloud storage.This is a one of the free cloud storage media. You can get this following way browse the URL https://www.mediafire.com then signup your account. Home page Select BASIS for free storage then you have to register your account Register Then your home page will be loaded. Your Home page  via you clicking upload your file, you can use cloud storage. This file can be anything.. You can use your files anywhere from any sourcs like your smart phone, laptops or your PC.

Hotel Online Reservation System

Image
I am doing BSc computer science in Department of Computer Science University of Jaffna,, I have started my 2nd year group project.. The Department allocated a mender to guide our project.. Her name is  Dr. (Mrs.) B. Mayurathan.   B.Sc. [Hons] (Jaffna),  Ph.D. (Peradeniya) Senior Lecturer..   First week I met her and fixed a appointment time to discuss our project title.. Next week  I went to meet with my group members with a idea of project title, after that she finalized our project title as  online hotel reservation   for Gnanam Hotel in jaffna.. We decided to make a online room reservation System.. After 3 week we got a approval letter from Department of Computer Science Head  Dr. K. Thabotharan  B.Sc.[Hons](Jaffna), M.Sc.(Akron), Ph.L. (Uppsala), Ph.D. (Colombo) .. we met the manager of the hotel. then he also interesting to do our project.so we got their requirements. and we sort out them functio...

Artificial intelligence

Artificial Intelligence Artificial Intelligence is a way of making a computer, a computer-controlled robot, or a software think intelligently , in the similar manner the intelligent humans think. In other hand Artificial intelligence (AI) is the ability of a computer program or a machine to think and learn. It is also a field of study which tries to make computers "smart".   AI involves many different fields like computer science, mathematics, linguistics, psychology, neuroscience, and philosophy.  History of artificial intelligence The artificial intelligence began in ancient times with myths, stories and rumors of artificial beings feelings with intelligence or consciousness by master craftsmen. AI researches were reached the peak after invention of Programmable digital computer in the 1940.This device and the ideas behind it inspired a handful of scientists to begin seriously discussing the possibility of building an electronic brain. AI rese...