DevSocial Articles · SQL Server articles

In this article, we will learn the basics of SQL Server Database Administration.Learn four system databases in SQL Server, master, msdb, tempdb and model.

Yashwant VishwakarmaJun 4, 2019316,5431,000

This article explains how SQL Injection is possible in ASP.Net.

Sourabh SomaniJun 4, 2019387,0581,000

In this article I am going to explain how to create scalar value functions in SQL Server 2012.

Vipendra VermaJun 4, 2019364,3091,000

In this article, I am going to explain how to restore a database backup in SQL Server 2012.

Vipendra VermaJun 4, 2019289,8171,000

This article helps you to understand the concept of Linked Servers in SQL Server 2008, 2012. I will show with an example, how to connect the two different databases using Linked Servers in SQL Server 2008, 2012 step by step.

Suthish NairJun 4, 2019401,6571,000

Learn what SQL Rollback is and how you want to rollback in SQL Server.

Kapil Singh KumawatJun 3, 2019156,6531,000

In this article you will see how to Create and manage Triggers in SQL Server 2005/2008.

Vishal NayanJun 3, 2019309,7691,000

This article explains what stored procedures and functions are and how they work and some basic differences among them.

Abhishek JaiswalJun 3, 2019318,5111,000

In this article I describe Commit and Rollback Commands in SQL Server.

Deepak MiddhaJun 3, 2019530,0141,000

In this article you will learn how to Create and Manage Stored Procedure in SQL Server 2008.

Vishal NayanJun 3, 2019445,0751,000

SQL Over. This article explains how SQL Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005.

Ritesh SharmaJun 2, 2019101,7471,000

This article shows how to use Views and Stored Procedures in SQL Server.

Raj KumarMay 30, 2019480,5241,000

This article covers the fundamentals of SQL transactions and how to implement SQL Transactions in C# with ACID properties. SQL Transaction code example.

Vidya Vrat AgarwalMay 28, 2019603,0821,000

Do you wonder what the most frequently asked SQL queries are in interviews? Here is a list of most asked SQL queries interview questions.

Tushar DikshitMay 27, 2019445,9981,000

In this article, you will learn about SQL bulk copy from DataTable using XML.

Arkadeep DeMay 20, 201916,5971,000

Announcement of a PASS Summit 2019 pre-conference session on SQL Server performance tuning, query optimization, execution plans, and troubleshooting common database performance issues.

Monica RathbunApr 24, 20196,4541,000

In this article, you will learn what implicit conversion is in SQL Server and how it works.

Monica RathbunApr 22, 201942,2091,000

In this article, I will show you an approach to get the most out of your Stored Procedure.

In this article, you will learn about key lookups in SQL server.

Monica RathbunApr 3, 201945,5141,000

In this SQL article, I will introduce you to some important SQL queries and technical points. This article is a guide for you to learn the concepts related to SQL. It starts with the basic SQL queries and later, continues to the advanced ones.

RakeshApr 1, 201931,4461,000

I am sure below screen look familiar to you because most of us as a developer has build this screen in our project. Where in you need to create a search feature to search something as per your project and bring the data from back end. Generally from front end we collect the parameter and pass this data to a store prodecure.

Gaurav JainMar 25, 201945,4741,000

SQL with .NET is a new approach to database development in the service layer. Let's get acquainted with it.

This article demonstrates the inbuilt functionality of importing data from Microsoft Excel to a SQL table using import export wizard.

Jignesh KumarMar 18, 2019163,3651,000

I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to realize it’s not working. The reason in the cases I’ve seen is because they have simply neglected to assign a mail profile to SQL Agent.

Monica RathbunMar 14, 20197,3231,000

The most prevalent SQL Server wait type was SOS_SCHEDULER_YIELD. This wait type is typically prevalent on a server undergoing CPU pressure.

Monica RathbunMar 7, 201910,3551,000

Microsoft recently announced the preview of Accelerated Database Recovery? ADR is a redesigned SQL database engine feature that improves database recovery process in Azure in the presence of long running transactions.

C# CuratorMar 4, 201911,1411,000

In this article, we will take a look at the built-in @@Options function that will show you what options are enabled on your local SQL Server Management Studio client.

John MorehouseFeb 28, 20197,6461,000

According to the CTE documentation, Common Table Expression is a temporary result set or a table in which we can do CREATE, UPDATE, DELETE but only within that scope. That is, if we create the CTE in a Stored Procedure, we can’t use it in another Stored Procedure.

Usama ShahidFeb 28, 201957,7301,000

This article describes Views in SQL Server. This article explains What a View is, Types of Views in SQL Server, and how to create Views in SQL Server.

Chigicherla MallikarjunaFeb 7, 201912,1831,000