Theme-Logo
  •   .Net
    •   C Sharp(C#)
    •   Web API
    •   Micro Services
    •   ASP.Net
    • ASP.Net MVC
    • .Net Core
  •   Database
    • SQL Server
    • Oracle
    • PostgreSQL
  •   jQuery
    • jQuery Tutorials
    • jQuery Plugins
    • jQuery UI
    • More on jquery
  •   Tutorials
    • Microservices Tutorials
    • DotNet Core Tutorials
    • PostgreSql Tutorials
Latest posts on SQL Server
Introduction of SQL Server.
SQL Server Join.
SQL Server Null values.
SQL Server Union and Union All.
The SQL INSERT INTO SELECT Statement.
How to find top N salary of employee with different way.
Tutorials on DotNet Palace

SQL Server Tutorials

Stored Procedure

A group of one or more database queries.

Function

User defined functions or UDFs in sql server.

Trigger

SP that automatically runs on an event.

View

A view is a virtual table based on the result-set.

Cursor

Enables traversal over the rows of a result set.

Indexes

Performace handling of database queries.

C# Tutorials

Collections

Specialized classes that store memory dynamically.

Generic Collection

Automatic benefit of type safety in C#.

Event

An occurrence of particular action.

Delegates

Like pointers to functions in C/C++.

Lambda Expression

Something like anonymous functions in C#.

Linq

Supports data retrieval from different data sources.

ASP.Net MVC Tutorials

Routing

Process of directing an HTTP request to a controller.

Views

Binding and displaying HTML controls from model data.

Controller

Controlling the flow of the application execution.

DotNet Architecture

SOLID Principle

First five object-oriented design.

Design Patterns

Design pattern with reusable solution.

Dependency Injection

Dependency injection and its advantages

Trending Post
Introduction of SQL Server.
SQL Server Join.
SQL Server Null values.
SQL Server Union and Union All.
The SQL INSERT INTO SELECT Statement.
How to find top N salary of employee with different way.
How to create indexes in sql server table.
How to improve sql server stored procedure performance.
Interview Questions and Answers
What are the steps you will take to improve the performance of a poor performing query?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What structure can you implement for the database to speed up table reads?
Could you please some items which you may see in an execution plan indicating the query is not optimized.
About us

DotNet Palace is a community platform created and maintained by The articles are mainly focused on Microsoft stack technologies like C#, ASP.Net, MVC, .Net Core, SQL Server and Oracle, PostgreSQL, SQLite etc. To improve the site's content you can send your valuable suggestions at info.dotnetpalace@gmail.com

Quick links
  • SOLID Principles
  • Questions
  • OOPS Principles
  • DotNet Palace Tutorials
  • Privacy Policy
  • Terms and Condition