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 |
July 26, 2013
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
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:
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.
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.
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
July 23, 2013
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/
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/
July 22, 2013
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.
· 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.
July 6, 2013
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
Subscribe to:
Posts (Atom)