Home / SQL / SQL Server

SQL Server

0 Comments 2 tags

In this article we’ll learn “SQL Server” concepts. This tutorial is designed for beginners as well as professional developers who want to learn basics and advance concepts of SQL Server. Please check out below article for SQL.

SQL Server Concepts for Beginners and Professionals

SQL server Column Encryption using symmetric key.
How to Update using Select statement in SQL Server.
SQL Server Interview Questions and Answers.
Import One Database to another in SQL server.
Generate database scripts in SQL server.
Different ways to search SQL objects in database.
SQL CASE statement
SQL IIF function
QUOTENAME function in SQL
How to Take SQL Server Database Offline/Online
How to use SQL ORDER BY in Your Queries
SQL Paging using OFFSET and FETCH
How is data physically stored in a SQL database
Fill Factor in SQL Server
How to Search SQL Object in Complete Database
How to generate SQL table script with data
Delete Truncate and disk storage.
How to safely delete the SQL database objects.
Deadlock in SQL Server.
Exception handling in SQL Server.

More for you

How to enable SQL Server authentication
SQL Server Authentication is a default way to connect to MS SQL Server, but there may be many times that you need to use SQL Server Authentication to connect to… Read more: How to enable SQL Server authentication
Set Transaction Isolation Level in SQL
In this post we’ll discuss SQL server “Set Transaction Isolation Level”. These are of 5 types, and we’ll discuss all one by one below. READ UNCOMMITTED Read uncommitted specifies that… Read more: Set Transaction Isolation Level in SQL
Is SQL NOLOCK bad practice?
In this post we’ll read about the use of [Nolock] in SQL Queries and stored procedures. Is this good or bad practice to use this in query. Let’s check out… Read more: Is SQL NOLOCK bad practice?
SQL Paging using OFFSET and FETCH
In this article we will learn about SQL Paging using OFFSET and FETCH. In SQL these clauses can be used with ORDER BY to limit the number of rows returned… Read more: SQL Paging using OFFSET and FETCH
Aggregate and Summarize Totals with SQL SUM
In this we will discuss about ‘aggregate and summarize totals with SQL SUM function. Knowing the method to calculate the complete addition of a specified column in a SQL Server… Read more: Aggregate and Summarize Totals with SQL SUM
How to use SQL ORDER BY in Your Queries
In this article we will learn how to use SQL ORDER BY in your queries. SQL is a powerful tool for manipulating data and ordering results in a specific order.… Read more: How to use SQL ORDER BY in Your Queries
How to Take SQL Server Database Offline/Online
In this article we will learn how to take SQL server database offline/online. There are some situations when we need to offline the database like How to make your DB… Read more: How to Take SQL Server Database Offline/Online
How to generate SQL table script with data
In this article we’ll learn how to generate SQL table script with data. You can create insert script of table before playing with its data for the safer side so… Read more: How to generate SQL table script with data
SQL server column encryption using symmetric key
In this article we’ll learn about SQL server Column encryption using Symmetric key. In Financial organizations or banks, we have sensitive data including account numbers and credit card numbers. As… Read more: SQL server column encryption using symmetric key
How to UPDATE using SELECT statement in SQL Server
In this article, we will learn how to UPDATE using a SELECT statement in SQL Server. There are “multiple ways which are used to update the data in a given… Read more: How to UPDATE using SELECT statement in SQL Server
Fill Factor in SQL Server
In this article we’ll learn about “Fill factor in SQL server”. Fill factor is used to decide how the data will get stored on SQL 8KB pages. We all know… Read more: Fill Factor in SQL Server
Delete Truncate and disk storage
Delete Truncate and disk storage
SQL CASE Statement
Introduction of SQL CASE: In this article we’ll learn about SQL CASE Statement. Like if-else the CASE statement goes through multiple conditions and returns a value when the first condition is… Read more: SQL CASE Statement
QUOTENAME Function in SQL: should read
In this article you’ll learn QUOTENAME Function in SQL. This Function was first introduced in SQL Server 2012. Main use of this function is to add square brackets to the… Read more: QUOTENAME Function in SQL: should read
SQL IIF Function
In this article, we’ll explain you about SQL IIF function. IIF Stands for Immediate IF function. It is an inline IF function that can be used to provide a conditional… Read more: SQL IIF Function
How is data physically stored in a database: All you need to know
In the article we’ll discuss “How is data physically stored in a database” in the form of “series of 8kb pages”. We all know that SQL server stores data in… Read more: How is data physically stored in a database: All you need to know
Import one SQL Database into another
In this article we’ll learn how to “Import one SQL Database into another”. To start the SQL Server Import and Export Wizard using SSMS, go to Object Explorer, right click on… Read more: Import one SQL Database into another
How to Search SQL Object in Complete Database
This article we’ll learn how to search SQL object in complete database. You can search for database objects in SQL database such as tables, stored procedures, functions, and views. In… Read more: How to Search SQL Object in Complete Database
How to Generate Complete Database Script
In this article we’ll learn how to generate complete database script. To generate full database script using SSMS, go to Object Explorer, right click on a database for which want to generate scripts;… Read more: How to Generate Complete Database Script
SQL Query Optimization Techniques
In this article we will learn SQL query optimization techniques. There are some useful practices to reduce the cost of the query so that it can perform better. To achieve… Read more: SQL Query Optimization Techniques
SQL Server
In this article we’ll learn “SQL Server” concepts. This tutorial is designed for beginners as well as professional developers who want to learn basics and advance concepts of SQL Server.… Read more: SQL Server
Interview Questions and Answers
This article will cover top .NET Interview Questions and Answers and is designed for Students, beginners as well as experienced professional developers who want to prepare an interview for .NET… Read more: Interview Questions and Answers
SQL Server Interview Questions
In this article you will get list all MS SQL server interview questions for beginners at one place. It is designed for beginners and experts too. It is a set… Read more: SQL Server Interview Questions

Using above SQL Server topics, you will learn from the very basic to the advanced level features of SQL Server. So, stay tuned with latest posts.

Prerequisites:

There are no prerequisites required to learn above topics in SQL Server. It is good to have SQL Server installed on your computer. This is required for you in executing the examples yourself and get to know how it works.