explaingit

dmcteknoloji/sql-server-2025-kitap

Analysis updated 2026-06-24

17TSQLAudience · dataComplexity · 2/5LicenseSetup · moderate

TLDR

Code samples and errata repo for a free Turkish-language book on Microsoft SQL Server 2025, covering classic DBA topics and the new vector and AI features.

Mindmap

mindmap
  root((sql-server-2025-kitap))
    Inputs
      SQL Server 2025 instance
      Demo database
      Setup script
    Outputs
      T-SQL examples
      Test logs
      Errata records
    Use Cases
      Learn SQL Server 2025
      Try vector and DiskANN
      Run AI_GENERATE_EMBEDDINGS
      Report errata
    Tech Stack
      T-SQL
      SQL Server 2025
      Shell
      DiskANN
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

USE CASE 1

Read the free Turkish book on SQL Server 2025 in PDF, EPUB, or web format

USE CASE 2

Run the tested T-SQL examples from kod-ornekleri against a local SQL Server 2025 instance

USE CASE 3

Try the new vector, DiskANN, and AI_GENERATE_EMBEDDINGS features from a worked example

USE CASE 4

File an issue to report errata that gets verified against Microsoft Learn and added to ERRATA.md

What is it built with?

T-SQLSQL ServerShellDiskANN

How do you get it running?

Difficulty · moderate Time to first run · 1h+

Needs a working Microsoft SQL Server 2025 instance plus the demo database before any example will run.

Creative Commons license, free to read, share, and adapt with attribution.

In plain English

This repository is the companion to a Turkish-language reference book on Microsoft SQL Server 2025, written by Çağlar Özenç and published by DMC Bilgi Teknolojileri in Istanbul. SQL Server is Microsoft's database product for storing and querying business data. Version 2025 added vector data types, an index format called DiskANN, an AI_GENERATE_EMBEDDINGS function, a natural language query interface, and a SQL MCP Server, so the book covers both the classic database administration topics and the new AI features. The book itself is free under a Creative Commons license and is offered as PDF, EPUB, and a web edition. It is about 448 pages across 32 chapters arranged into 6 parts, with 158 glossary entries, 12 diagrams, and over 100 T-SQL code examples. A physical printed copy is offered as an optional 700 lira supporter edition, but the digital editions cost nothing. The repo holds the code samples and the community-facing infrastructure rather than the book text. Each chapter has its own folder of tested .sql files under kod-ornekleri, with a shared setup script and a demo database. A control folder ships a shell script called run-tests.sh that runs the examples against a real SQL Server 2025 instance and writes masked output logs. Readers are invited to file issues for errata, which the maintainers verify against Microsoft Learn references and then record in ERRATA.md before folding into the next book version. Discussions are used for questions, and pull requests can add new code samples or refine existing ones. The book targets 11 reader roles from beginners and DBAs through data engineers, analysts, and architects up to C-level executives. Version 1.0 was released in May 2026, with monthly small updates and a v1.1 planned for March 2027.

Copy-paste prompts

Prompt 1
Set up a local SQL Server 2025 container and run the setup script plus the kod-ornekleri samples end to end
Prompt 2
Walk me through the chapter on AI_GENERATE_EMBEDDINGS and DiskANN indexing with one runnable T-SQL example
Prompt 3
Show me how to use the SQL MCP Server feature from SQL Server 2025 with a small natural language query demo
Prompt 4
Convert one chapter's T-SQL examples into a Postgres equivalent so I can compare the two engines
Prompt 5
Open a clean errata pull request against this repo following the maintainer workflow

Frequently asked questions

What is sql-server-2025-kitap?

Code samples and errata repo for a free Turkish-language book on Microsoft SQL Server 2025, covering classic DBA topics and the new vector and AI features.

What language is sql-server-2025-kitap written in?

Mainly TSQL. The stack also includes T-SQL, SQL Server, Shell.

What license does sql-server-2025-kitap use?

Creative Commons license, free to read, share, and adapt with attribution.

How hard is sql-server-2025-kitap to set up?

Setup difficulty is rated moderate, with roughly 1h+ to a first successful run.

Who is sql-server-2025-kitap for?

Mainly data.

Open on GitHub → Explain another repo

This repo across BitVibe Labs

Verify against the repo before relying on details.