Archive

SQL-related Stored Procedures (SP)

Normally, a stored procedure is said to be an independent module of programming instructions accessible to submissions getting into a ‘relational’ DB scheme. Stored procedures, which are also known as sproc, proc, StoPro, SP or StoredProc, are retained in the data dictionary of your database.

Typical uses for stored procedures include data authentication, which is incorporated into the DB or get access to command mechanisms. Besides, stored procedures are utilized to consolidate and centralize logic, which was initially applied in the applications. Widespread or complex processing, which needs implementation of...

Read more

SQL, How To Select Columns, Rows And Join Tables

Selecting Specific Columns From a Table: SELECT command, used to retrieve information from the database, allows you to select the columns to be including in a query. A query is a request for information, and one of the most common DB operations. Queries are performed by the SELECT command. A SELECT command must have at least two clauses; the first one is SELECT (the columns to retrieve) and second is FROM (the tables which contains those columns). You may place the clauses on the same line or on separate lines but...

Read more

Software as a Service (SaaS) and Its Usage

Basically there are four layers in the model of cloud computing:
  1. Business Process as a Service
  2. Software as a Service
  3. Platform as a Service
  4. Infrastructure as a Service

In this article we are going to discuss Software as a Service (SaaS) layer of cloud computing model. Software as a Service i.e. SaaS actually refers to the situation where the service provider provides customer the software applications by means of deployment over the internet. Sometimes SaaS is also called software on demand. History: Software as a service actually existed before cloud the...

Read more

Top 50+ Cloud Computing Providers There are a variety of cloud computing providers all across the world that offers different products and services to the IT users. They cover every walk of life to provide more ease to the network administrators to manage things and to make processes swifter than ever. If we go back to the history, we’ll get to know that people were unable to even think of this great change that it may happen somewhere in future. All credit goes to the mighty technology that has brought revolutionary changes to the world of IT and the humanity started...

Read more

Skype Now Becoming Layman’s Application

Introduction Skype is gaining popularity at such a rapid rate that most Internet users are already familiar with this application. It is an online communication software, which allows text chatting  and audio conferencing as well as video calls. Skype is actually a VOIP service which can be used to make calls to another person’s computer or to their land lines. There are many reasons for its popularity:  free registration, no monthly fees, free computer-to-computer calls as well as cheap rates for landline calls, ease of use, etc.  Even someone with no or very little technical knowledge...

Read more

Microsoft Active Directory Universal, Global and Local Security and Distribution Groups

When we conceive a new assembly in Microsoft Active Directory, we should choose an assembly type. Two of the assembly kinds are described as follows: 1. Security Groups in Active Directory: Such assemblies permit us to organize client and PC to get access to distributed resources. We can also command who obtains assembly principle settings. It makes management easy by allowing us to establish permissions one time on many PCs, then to change the members of assembly as required. The alteration in assembly members mechanically affects all over. We can...

Read more

Virtualization Basics, Needs and Benefits

Points Covered
  • Microsoft VirtualizationVMware and all other main virtualization companies and their products
  • Comparing each with others if possible a table with their + or –
  • History of each in short
  • Benefits
  • Involved hardware
  • Involved software
  • Deployments
  • Software virtualization and hardware virtualization

Virtualization – An Introduction Virtualization can be defined as a methodology or framework that helps to divide the computer resources into numerous execution environments using various technologies and/or concepts, like software and hardware partitioning, complete or partial machine simulation, time sharing, service quality, and emulation, etc....

Read more

How to Find the Best Software among Open Source, Freeware and Shareware?

You must have heard of the different types of software, but I’m pretty sure that you don’t know their benefits. Well, it is natural to use things directly without wasting time to get to know their proper use and what they actually offer. In this article, I’ll tell you the major differences between different types of software and their benefits. Types of software:
  • Open source
  • Freeware
  • Shareware
Open Source Software: Open source is a sort of software type, which refers to the fact that the source cipher is accessible to...

Read more

Multimedia Programs

These are the programs that help us in presenting multiple kinds of media, including sounds from different sources, graphic display as well as written texts. Majority of these Multimedia programs causes a clear interaction with their user to gain attention. Pages of a page are one of the multimedia that causes interaction with the user. This is because they are a combination of different media including sounds, graphics and even texts. All computers perform their operations with all the kinds of media of which art is one of them and this is only possible if the resources of...

Read more

T20 format is known for high scores and hard-hitting and The Caribbean Premier League is no different from this. One of the topmost events to feature blistering hits right from 2013 till today. There's no limit for entertainment here and with the likes of Chris Gayle, Kieron Pollard, Andre Russell it can't get any better. CPL has always been known for boundaries and sixes. And below is the list of the top 10 batsmen to hit the most number of sixes in the Caribbean Premier League.

10. Colin Munro: 90 Sixes

(Trinbago...

Read more