SQL Studio Generated by AI (Copilot & Claude)
A lightweight SSMS‑style SQL dashboard built in PowerShell and WPF. It loads multiple SQL files as tabs, executes queries across one or more servers, displays results in an embedded browser, …
Availability Group – How to Reduce False Failovers During Short Infrastructure Outages
To reduce false failovers during short infrastructure outages, it is common to increase: 1. LeaseTimeout — communication timeout between SQL Server Availability Group and WSFC from 20s to 60s SQL: …
Unique Incremental Number for Each Inserted Row without Using an IDENTITY Column
If you need to generate a unique incremental number for each inserted row without using an IDENTITY column, you must protect the MAX() value lookup inside a transaction. This prevents …
Database in SUSPECT State Due to DTC: How to Resolve
DATABASE REPAIR CHECKLIST Step 1 — Find the stuck distributed transaction If you see a GUID → go to Step 2.If you see all zeros → go to Step 3. …
SQL Index Creation Tutorial (Part 3): Composite Index Construction
Example: Estimated Execution Plan: 1. Open the index properties and select the Predicates section: 2. Copy the content: 3. Paste it into a prepared query and clean up the unnecessary …
Optimize Linked Server Performance with MAXDOP Settings
The working solution is to set Openquery:
SQL Index Creation Tutorial (Part 2): Performance and Execution Plans
Data source: Original query Estimated Execution Plan 1 Estimated Subtree Cost: 586.232 → far too high, indicating long execution time and heavy server load. The plan shows: Creating indexes Index …
SQL Index Creation Tutorial (Part 1): Heap Tables and Basics
Example: Data source: Heap table (a heap without a clustered index) Address_TEST, 9,963,912 rows, no nonclustered indexes. Query: Estimated Execution Plan 1: Estimated Subtree Cost: 143.514 – high number = …
Integrate Ollama AI with SQL Server 2025 for Parallel Execution
If you have already installed Ollama server, for example based on this article Setting Up Ollama for SQL Server 2025: A Guide – John Deardurff, then you need to register …