Loading
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 memory-optimized tables in SQL Server.
This article represents the comprehensive guideline for date and time functions in T-SQL.
Are you looking to supercharge your database? Learn how you can use Pivot in SQL Server to take your database to the next level. Pivot can help you optimize your database performance, improve data analysis, and reduce the time it takes to access and store data. Find out how Pivot in SQL Server can help you today!
A complete guide of top SQL Server interview questions and answers that will help pass your SQL Server interview.
This article explains how to create functions in SQL Server using the SQL function operator.
This tutorial will show you the difference between the HAVING and WHERE Clause in SQL Server.
Learn about the Common Table Expression (CTE) in SQL Server with the WITH clause. Simplify code, improve query readability, and use recursive queries with the SQL WITH clause.
This article provides a step-by-step guide to finding data differences between two tables in MS SQL Server
This article will explain to you how exactly you need to configure TLS 1.2 as a default protocol and setup SMTP O365 migration using SQL 2012 Database mail and above versions for Windows Server 2012 and above Common SMTP exceptions we usually faced : The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2. Exception Message: Cannot send mails to mail server. (Failure sending mail.). ) Just follow the steps -
Step by step details to create azure sql database server in the Microsoft Azure Portal
The concept of temporary tables in SQL Server, their advantages, and types.
In this article, we will delve into the world of SQL+ and explore its capabilities, advantages, and real-world applications. We will provide code snippets and examples to illustrate the power of SQL+ in action, empowering you to leverage this advanced SQL variant to tackle complex data challenges with ease.
In this article we will learn about Temporary Tables in SQL Server.
This article shows how to create a dynamic PIVOT query in SQL Server.
This tutorial will show you the concept of DDL Triggers In SQL Server.
This article provides a step-by-step guide on how to connect to SQL Server and execute queries using SQL Server Management Studio 2022 (SSMS).
This article describes how different date styles work with date formats
Learn how to use the SQL Server ORDER BY clause to sort SELECT query results by columns, aliases, and expressions in ascending or descending order.
In this article, we shall cover Logon Triggers. Logon trigger a special kind of stored procedure which fires automatically when a LOGON event is detected, or new database connection is established. Logon triggers are similar to DDL triggers and created at server level.
In this article, you will learn about SQL Server Reporting Services statements in SQL
Learn how to use SQL Server primary key, foreign key, and unique constraints to enforce data integrity and relationships between tables.
DDL triggers are a type of trigger that gets fired and executed when DDL events occurs on database schema. DDL events include Create, Alter, Drop, Grant, Deny, Revoke statements.
This article explains about Triggers and when and how to use them
Everything on SQL Server, not only its articles: the SQL Server page →
Mahesh Chand9 videos · 23 news posts+5.3Kpoints2
Aarav Patel21 articles · 1 reaction received+2.1Kpoints3
Ananya Desai21 articles · 1 reaction received+2.1Kpoints4
Riya Patel20 articles · 1 reaction received+2Kpoints5
Bhavya Singh20 articles+2KpointsFull leaderboard →
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
