Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
In this article you will learn about SQL Injection in Dynamic SQL.
This article provides more tips to increase SQL Server query performance.
In this article we will see how to create a simple trigger in a SQL-CLR project. I hope you are already quite familiar with the concept of triggers in SQL Server (or some other database).
In this article I am going to explain how to insert multiple rows using a user defined table type.
In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.
I will illustrate the principles of Distributed Database Management Systems through this article.
Windows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.
This article explains @@Identity, Scope_Identity() & Ident_Current('Table_Name') in SQL.
In this article you will learn what is Different between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in SQL 2008
In this article, I provide a quick overview of how to add a number in a string in SQL Server.
In this article we will go through the most basic and frequently asked interview questions on SQL Server.
In this article, we learn about how SQL is used for data governance and compliance in regulated industries.
In this article, we learn about how to implement data governance in SQL.
In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.
This article explains how to use the transactions and various way of writing the transactions in SQL Server.
This article explains the Merge Statement in SQL Server.
The SQL Server Service Broker helps developers to build scalable as well as secure database applications.
In this article, we will create a symmetric key and encrypt and decrypt string using this key.
In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.
In this article, we will generate a certificate and using this certificate we will encrypt and decrypt the string.
In this article, we will discuss Database Master Key. The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database.
In this article we are show different types of joins in SQL Server. A Join in SQL is used to combine two or more tables. We use the Join operator to gather the data in a single query.
In this article, you will learn about Clustered vs Non-clustered Index.
In this article, I would like to show the functions Datepart, DateName, Year, Month and Day in SQL Server.
In this article, you will learn the difference between Grouping and Grouping_ID in SQL Server.
This sample shows how to use EXCEPT and INTERSECT operators in SQL Server 2005.
This article shows a simple procedure for importing data from Excel to SQL using SQL Server Integration Services (SSIS).
In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.
In this article I explain how to count and delete duplicate records from SQL database table.
Everything on SQL, not only its articles: the SQL page →
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterMembers onlyWrite an article and earn +1,000 SHARP when it is approved.
Write an article