August 20, 2013

Difference between a Domain,Work group and Home Group?



In a work-group:

@ All computers are peers; no computer has control over another computer.
@ Each computer has a set of user accounts. To log on to any computer in the work group,you must have an account on that computer.
@ There are typically no more than twenty computers.
@ A workgroup is not protected by a password.
 @ All computers must be on the same local network or subnet.

August 14, 2013

SQL Aliases

SQL aliases are used to give a database table, or a column in a table, a temporary name.
Basically aliases are created to make column names more readable.

SQL Alias Syntax for Columns

SELECT column_name AS alias_name
FROM table_name;


SQL Alias Syntax for Tables

SELECT column_name(s)
FROM table_name AS alias_name;


Source: w3

SQL Wildcard Characters

In SQL, wildcard characters are used with the SQL LIKE operator.
SQL wildcards are used to search for data within a table. 
With SQL, the wildcards are:

Wildcard

%, -->A substitute for zero or more characters
_, --->A substitute for a single character
[charlist], -->Sets and ranges of characters to match
[^charlistor [!charlist], -->Matches only a character NOT 
specified within the brackets

How do I enable cookies in my browser?

Internet Explorer 7 and 8 

1. Click the Tools button (or press ALT and T on the keyboard), and then click Internet Options. 
2. Click the Privacy tab 
3. Move the slider to the bottom to allow all cookies, and then click OK. 

Firefox 
1. At the top of the Firefox window, click on the Tools menu and select Options...
2. Select the Privacy panel. 
3. Set Firefox will: to Use custom settings for history. 
4. Make sure Accept cookies from sites is selected. 
5. Make sure Accept third party cookies is selected. 
* Disabling third party cookies can cause problems with some websites including statcounter.com. Enable this setting to rule it out as a cause for your problem. 
6. Click Exceptions.... 
7. Make sure statcounter.com isn't listed. 
* If it is listed, click on its entry, then click Remove Site 

July 26, 2013

SQL Versions and its Code Name..

Microsoft SQL Server is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and the list below refers to its versions.

shyam.mb
SQL VERSIONS

Stages in BI Project an Overview

Stages in BI project

  •  Project Preparation / Requirement Gathering
  •  Business Blueprint
  •  Realization
  •  Final Preparation
  •  GO Live & Support


July 25, 2013

About URL and Local Host....

A Uniform Resource Locator (URL) is used to address a document (or other data) on the world wide web.

http - HyperText Transfer Protocol - Common web pages starts with http://. Not encrypted

https - Secure HyperText Transfer Protocol - Secure web pages. All information exchanged are encrypted

ftp - File Transfer Protocol - For downloading or uploading files to a website. Useful for domain maintenance

  • host - defines the domain host (the default host for http is www)
  • domain - defines the Internet domain name, like www.google.com
  • port - defines the port number at the host (the default port number for http is 80
  • path - defines a path at the server (If omitted, the document must be stored at the root directory of the web site)
  • localhost path - http://localhost/