In this article you will understand difference between RDBMS and NoSQL.
RDBMS vs NoSQL
Relational database (RDBMS) is completely structured way of storing data like SQL and has been the primary model for database management during the past few decades and I know most of you already familiar with the SQL database . In the last several years, NoSQL database is getting widely adopted to solve various business problems. So with widely growing DB systems, developer might get confused. In this article I’II show you the difference between them and the evolution.
Relational Database Management System (RDBMS)
RDBMS is completely structured way of storing data. Itis a database management system (DBMS) that is based on the relational model. Data is stored in the form of rows and columns in RDBMS. Data is stored in the form of rows and columns in RDBMS. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, etc.
– >Provides data to be stored in tables
– >Persists data in the form of rows and columns
– >Provides facility primary key, to uniquely identify the rows
– >Creates indexes for quicker data retrieval
– >Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied.
– >Sharing a common column in two or more tables(primary key and foreign key)
– >Provides multi user accessibility that can be controlled by individual users
Continue reading “RDBMS vs NoSQL”
In this article you will learn some basic concepts of MVC Architecture.
So what is MVC ?
- An Architectural design principle that separates the components of a Web Application.
- This separation gives you more control over the individual parts of the application , which lets you more easily develop , modify and test them.
- Three main components : The Model, The View, The Controller.
Models, Views, and Controllers
- Model — Model holds application data , data access logic.
- View — Markup and content that is returned to the browser
- Controller—Fires off some logic in response to a web browser request it listens incoming request from the browser manipulate the model data prepare the view to display in response to the web browser.
Continue reading “MVC Basics for Beginners”
SQL naming conventions
This article is for standards for the SQL naming convention. I listed all basic which I found useful. May this will benefit you too.
Databases and Files
- The database name should accurately reflect the database content and function. Use the Pascal case structure for database names. E.g., Northwind
- Use both upper and lower case letters as appropriate. Do not use spaces or underscores in the name
- File names must match the database name
Continue reading “SQL naming conventions”
C# Coding Standards
General Naming Conventions
Following a consistent set of naming conventions can be a major contribution to readability. Beyond consistency of form, names of application and framework elements must be easily understood and must convey the functions of each element.
It is important that the names of identifiers make sense on the first reading. Identifier names should clearly state what each member does and what each type and parameter represents. To this end, it is more important that the name be clear than that it be short. Names should correspond to scenarios, logical or physical parts of the system, and well-known concepts rather than to technologies or architecture.
Do choose easily readable identifier names. For example, a property named HorizontalAlignment is more readable in English than AlignmentHorizontal.
Do favour readability over brevity. The property name CanScrollHorizontally is better than ScrollableX (an obscure reference to the X-axis).
Continue reading “C# Coding Standards”
How to Format SQL query?
While working on SQL queries especially when one is dealing is large lines of SQL code , in that case formatted and refracted query is a live savior. In this blog I’II provide you with the solution which I found quite useful.
#Formatting SQL query using SSMS
This is for the guys who regularly have to deal with the queries. There is no built in formatting in SSMS (SQL Server Management Studio) although Ctrl + Shift + Q will give you a Query Designer window from which you can copy formatted query but there are plugins available that will integrate with SSMS. There are a million others out there but not all of them that do plug into management studio, but the one I know of and it works very well is Apex SQL Refactor. It is a free plugin. Integrates with SSMS. Downside is that it is an all or nothing process. It does not refactor as you type. For complete Installation Guide of Apex SQL Refactor, you may refer this.
#Formatting SQL query using Online Tool
This is one of the quick solution if you don’t have any plugin or you don’t want to as you may not have to deal more with SQL queries, there are tools that will do formatting for you. Again guys there are many online free tools available that you can use to format your large queries. One of my favorite is SQL-Format because apart from formatting it will give you many option, desktop version for this is also available but I prefer to better save my PC storage and do it online.
How to turn windows 8 PC into Wifi Hotspot
In this article I’II explain you “How you turn your PC into Wifi hotspot through command prompt”.
If you find yourself with a modem but no router, you can share one computer’s connection to other devices with a few commands. The wireless connection can be shared and used by other computers, tablets and phones. You’ll need to ensure that your computer has a wired and wireless network connection, or a data and Wifi connection. If you are not sure don’t worry I’II show you the command for this too .
Continue reading “How to turn windows 8 PC into Wifi Hotspot”
IIS Application Pools Pros and Cons
In this article we are going to see the IIS Application Pools Pros and Cons, before we start lets start what is Application pool identity, it is the name of the service or user account under which the application pool’s worker process runs. It denotes the system level privileges with which the web application runs on the IIS server. By default, starting in IIS 7.5 an application pool runs under the built-in ApplicationPoolIdentity account.
Continue reading “IIS Application Pools Pros and Cons”
How to Edit IIS ApplicationHost file?
What is Application Host file?
ApplicationHost.config is the root file of the configuration system when you are using IIS 7 and above. It includes definitions of all sites, applications, virtual directories and application pools, as well as global defaults for the web server settings. Continue reading “How to Edit IIS ApplicationHost file”
Avoid Multiple ASP .NET Deployment server
Annoying Right ? I used to work on different projects and during debugging I found a bit of an annoying behavior within Visual Studio. When debugging a solution that contains multiple project/application.
Visual Studio starts up a very new development web server for each project/application within your solution. After spending time on looking to the setting I finally came across the solution. Continue reading “Avoid Multiple ASP .NET Deployment server”