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.
Setting Business Constraint for Unique Combination of Multiple Columns in Master Data Services
Learn how to convert datetime values to different formats in SQL Server with this comprehensive guide. Explore various date conversion functions and formats, including examples and code snippets, to efficiently manipulate and format date and time data in your SQL Server queries.
Registered Servers in SQL Server Management Studio (SSMS) is a feature that allows database administrators and developers to conveniently manage and access multiple SQL Server instances and other database-related resources from within a single interface. Here's a detailed description of this feature.
ACID Properties in SQL Server ensure Data Integrity during a transaction.
In this article, I described how to pass a table to a Stored Procedure parameter in SQL Server.
In this article, I would like to show the Dateadd Function in SQL Server.
This article explores SQL Server's TRY...CATCH statement for exception handling. It delves into its syntax, functions like ERROR_NUMBER and ERROR_MESSAGE, and demonstrates its use through examples.
A stored procedure is a reusable collection of SQL statements stored on the database server. It simplifies code maintenance and execution. Stored procedures can be invoked by triggers, other procedures, and various programming languages like Java, .Net, and Python, making them versatile.
In SQL Server, various types of SQL commands are essential for managing and querying databases. These include Data Query Language (DQL) for retrieving data, Data Definition Language (DDL) for defining structures, Data Manipulation Language (DML) for data manipulation, and Control Language (CL) for transactions and control. Understanding these SQL command types is crucial for effectively working with SQL Server databases, enabling tasks from creating tables to querying data, ensuring efficient data management and retrieval.
The MERGE statement is a versatile SQL command used for conditional INSERT, UPDATE, or DELETE operations, streamlining database management tasks efficiently in a single query.
Learn how to efficiently save and insert JSON array data into a database table using SQL Server's T-SQL language, with adaptable concepts for other database systems.
Normalization is the process of organizing data into a related table; it also eliminates redundancy and increases the integrity which improves performance of the query.
Tracking changes in data over time is a common problem, and deciding on your approach relies on answering questions such as “Do I want to track every field or just some fields?”, “Does it need to be ‘live’ or is it okay to detect changes within a period of time?” and “What audit fields are available to me and what degree of tracking is needed (e.g. deletions vs. just updates)?”
This tutorial will show you the concept of IIF Function In SQL Server.
This article explains the tricks to implement Interactive Sorting on Matrix Column Group in SSRS.
This article will discuss how to set status bar color for a SQL Server Query Editor
Tiggers are commonly used in SQL Server to automate data updates. This introduction article explains the basics of trigger in SQL, the types of triggers, and how to implement triggers in SQL Server.
Understanding of various joins in SQL Server with examples and SQL Script for self learning.
CTE Usage Guide: When and How to Use CTE in SQL Server and its Features and Limitations
Numeric data types are a crucial part of any database system, providing the foundation for storing numerical values accurately and efficiently. In Microsoft SQL Server (MSSQL), developers have the choice between DECIMAL, FLOAT, and NUMERIC data types to meet specific requirements. In this article, we'll explore the differences between these data types, their use cases, and examples to illustrate their behavior.
Discover the power of SQL Server Jobs for automating repetitive tasks in your database. Learn how to create, manage, and optimize tasks efficiently, ensuring a smoothly running database environment.
An append-only ledger table is a type of database table that only allows new data to be appended to the end of the table. Once data is added to an append-only ledger table, it cannot be changed or deleted.
In this article, we will learn about How To Work with JSON in SQL Server
How to Optimize SQL Server Query Performance.
In this article we are going to explore how to create custom CLR assembly and how to access it in the SQL Server.
Effective documentation of complex SSAS tabular models ensures its maintainability, scalability, and ease of understanding for future users. This guide shares best practices, from utilizing descriptions and data dictionaries to visual diagrams, detailing DAX formulas, outlining refresh strategies, and the use of centralized, accessible information hubs, including leveraging automation tools for efficiency.
SQL Server Ledger is a feature of SQL Server that provides tamper-evident capabilities for your database. It does this by using a blockchain and Merkle tree data structures to track the history of changes to your database.
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
