What is NAS, SAN, DAS ?

NAS stands for Network Attached Storage. It differs from traditional, directly attached storage in that, in NAS, the operating system and other software on the NAS product are dedicated solely to data storage.

SAN stands for Storage Area Network. A SAN is a network designed to attach storage hardware and software to servers. SANs generally come in two forms: as a network primarily dedicated to transferring data between computer systems and storage systems, or as a complete system that includes all of the storage elements and computer systems within the same network.

DAS stands for Directly Attached Storage. DAS is generally used to differentiate between storage systems directly attached to a server or workstation and NAS and SAN setups.


Source

How to fix orphaned SQL Server users?

The problem is that the user in the database is an "orphan". This means that there is no login id or password associated with the user. This is true even if there is a login id that matches the user, since there is a GUID (called a SID in Microsoft-speak) that has to match as well.

This used to be a pain to fix, but currently (SQL Server 2000, SP3) there is a stored procedure that does the heavy lifting.

All of these instructions should be done as a database admin, with the restored database selected.

First, make sure that this is the problem. This will lists the orphaned users:

EXEC sp_change_users_login 'Report'

If you already have a login id and password for this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user'

If you want to create a new login id and password for this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'


Source : SQL BLOG

Create and Configure Virtual Directories in IIS 7.0

To create a virtual directory by using IIS Manager

1. In IIS Manager, expand the local computer and the Sites folder, and then find the Web site that you want to add a virtual directory for. Use the following steps:

o For , right-click the site or folder where you want to create the virtual directory, and then click Add Virtual Directory.

o For Windows Server 2008, right-click the site or folder where you want to create the virtual directory, click Manage Web Site, and then click Add Virtual Directory.

2. In the Add Virtual Directory dialog box, specify the following information:

o Alias. Type a name for the virtual directory. Choose a short name that is easy to type, because the user types this name to access the Web site.

o Physical Path. Type or browse to the physical directory that contains the virtual directory. You can select an existing folder or create a new one to contain the content for the virtual directory. 

3. To provide credentials to connect to a UNC path, click the Connect as button.

4. Click OK.

List of Run Commands in Windows 7 & 8

TO DOWNLOAD THE COMMANDS CLICK THE LINK - DOWNLOAD

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.

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

[^charlist] or [!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 

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.

SQL VERSIONS

Stages in BI Project an Overview

Stages in BI project

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

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/

The MVC Programming Model Overview

MVC is one of three ASP.NET programming models.

MVC is a framework for building web applications using a MVC (Model View Controller) design:

• The Model represents the application core (for instance a list of database records).
• The View displays the data (the database records).
• The Controller handles the input (to the database records).

The MVC model also provides full control over HTML, CSS, and JavaScript.

The MVC model defines web
applications with 3 logic layers:

The business layer (Model logic)

The display layer (View logic)

The input control (Controller logic)

The Model is the part of the application that handles the logic for the application data.
Often model objects retrieve data (and store data) from a database.

The View is the parts of the application that handles the display of the data.
Most often the views are created from the model data.

The Controller is the part of the application that handles user interaction.
Typically controllers read data from a view, control user input, and send input data to the model.

The MVC separation helps you manage complex applications, because you can focus on one aspect a time. For example, you can focus on the view without depending on the business logic. It also makes it easier to test an application.

The MVC separation also simplifies group development. Different developers can work on the view, the controller logic, and the business logic in parallel.

Source : w3schools

What is QR Code?

Do you know what is QR Code?
A QR code (short for Quick Response) is a specific matrix barcode (or two-dimensional code), readable by dedicated QR barcode readers and camera phones. The code consists of black modules arranged in a square pattern on a white background. The information encoded can be text, URL or other data.

Was checking a barcode reader and found that app that i was testing can read QR codes so this was it.
Here is a QR code of my blog .

These are easily readable by most smartphones with camera by installing small app.

To generate QR Code visit - http://goqr.me/

Using of CAB files in Windows (Making & Extracting)

Cabinet files are the Microsoft Windows Archives. These archives can store multiple files/folders into a single file with or without involving data compression. Since every Windows system is natively compatible with cab files, Windows provide enough facilities to create, extract, or rebuild cab files without requiring additional software.By default, there are 3 utility files for dealing with cab files. They are

·         makecab.exe
·         expand.exe
·         extrac32.exe


You can find these in the system32 directory.

Use IEXPRESS.EXE,there is a lot of facilities with this tool. Try playing around a bit and figure them out.

Useful Software Downloads

Shyam's shared4.com 

To List the Schema Name and Table Name in MS SQL

The script which generates all the tables name in database along with its schema name.

SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'AS SchemaTableFROM sys.tables