Gökhan Aravi

Gökhan Aravi

Code is like humor. When you have to explain it, it’s bad.

  • An Unknown Feature of MSSQL: Graph Database Support

    An Unknown Feature of MSSQL: Graph Database Support

    On

    12 November 2024

    By

    gokhanaravi

    One of the lesser-known but highly powerful features of Microsoft SQL Server is its Graph Database support. While SQL Server […]

    Continue reading

  • Simplifying Data Manipulation with the MSSQL MERGE Statement

    Simplifying Data Manipulation with the MSSQL MERGE Statement

    On

    4 October 2024

    By

    gokhanaravi

    In MSSQL, traditional data manipulation tasks often involve separate INSERT, UPDATE, and DELETE commands. However, when you need to perform […]

    Continue reading

  • A Hidden Feature of MSSQL: System-Versioned Temporal Tables

    A Hidden Feature of MSSQL: System-Versioned Temporal Tables

    On

    4 October 2024

    By

    gokhanaravi

    MSSQL is widely recognized for its robust data management and storage solutions, and many users are familiar with its powerful […]

    Continue reading

  • Advanced Feature in C#: Extension Methods

    Advanced Feature in C#: Extension Methods

    On

    2 October 2024

    By

    gokhanaravi

    In C#, it’s possible to add new behavior to a class or a struct without modifying the original source. This […]

    Continue reading

  • Unlocking Hidden Power in MSSQL: Indexed Views for Performance Optimization

    Unlocking Hidden Power in MSSQL: Indexed Views for Performance Optimization

    On

    30 September 2024

    By

    gokhanaravi

    Introduction Database performance is a critical factor in database management and software development processes. SQL Server offers many powerful tools […]

    Continue reading

1 2 3 … 6

Categories

  • C#
  • Genel
  • SQL Server

Archives

  • November 2024
  • October 2024
  • September 2024
  • January 2024
  • December 2023
  • November 2023

Tags

ABS Architecture async AsynchronousMethods AutoMapper AVG C# CEILING COUNT DATEADD DATEDIFF ExtensionMethods FileTable FLOOR FORMAT GETDATE GraphDatabase IndexedViews interface LEN LOWER MAX MERGE MIN MSSQL Onion OnionArchitecture Operators POWER REPLACE ROUND signalR SQL SUBSTRING SUM swagger switch sync SynchronousMethods TEMPORALTABLES TSQL UPPER Views WITH Yield

Categories

  • C#
  • Genel
  • SQL Server

Archives

  • November 2024
  • October 2024
  • September 2024
  • January 2024
  • December 2023
  • November 2023

Tags

ABS Architecture async AsynchronousMethods AutoMapper AVG C# CEILING COUNT DATEADD DATEDIFF ExtensionMethods FileTable FLOOR FORMAT GETDATE GraphDatabase IndexedViews interface LEN LOWER MAX MERGE MIN MSSQL Onion OnionArchitecture Operators POWER REPLACE ROUND signalR SQL SUBSTRING SUM swagger switch sync SynchronousMethods TEMPORALTABLES TSQL UPPER Views WITH Yield


© 2024 Gökhan Aravi

  • Twitter
  • Instagram
  • LinkedIn
  • Mail