explaingit

dmcteknoloji/sql-server-2025-kitap

17TSQLAudience · dataComplexity · 2/5ActiveLicenseSetup · 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

Things people build with this

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

Tech stack

T-SQLSQL ServerShellDiskANN

Getting 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
Open on GitHub → Explain another repo

Generated 2026-05-22 · Model: sonnet-4-6 · Verify against the repo before relying on details.