MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting
Instead of capturing everything and slowing down your system with SQL Profiler, XEvents allow you to execute a targeted, razor sharp seek . It is li…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
backend
beginners
career
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
5432 and 1433: two database ports, ten million answers, and the question of what answered
5432 and 1433: two database ports, ten million answers, and the question of what answered The counts Database ports appear at very large scale in in…
Cleaning Up Unused Indexes Without Breaking Performance
Indexes tend to outlive the problems that created them. It usually starts with a slow query. An engineer adds an index, the immediate issue goes awa…
Connecting Power BI to SQL Databases.
A step by step tutorial . Power BI is a data visualization tool and a business intelligence platform that turns raw data into interactive dashboards…
SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment
TL;DR Pick the wrong auto-increment strategy in SQL Server and you find out in production. An INT IDENTITY column hits 2,147,483,647. Replication no…
SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: SSMS keeps every database diagra…
Building a Multi‑Language Weather Report System Using PowerShell, GitHub Pages, and OpenWeatherMap API
Introduction I built a fully automated weather reporting system called weather2, which updates every 4 hours and publishes multi‑language weather re…
AI Agents That Speak SQL: Text-to-SQL with Hugging Face smolagents
The problem with "classic" Text-to-SQL The simplest way to connect an LLM to a database is a single-pass pipeline: the user writes a question in nat…
The AWS Bill Says $4,000. It Won't Tell You Which Database Owes What.
How HiFX built DBSteward to turn a single shared-instance bill into a defensible per-database charge back. If you run more than one database on a sh…
Why Metadata-Driven ETL Frameworks Scale Better Than Hardcoded Pipelines — and Where They Don't
Over the years, I've seen many data platforms start with good intentions. A few scripts are created to move data from one system to another, and eve…
SQL Server updates and patches
I created a simple page for checking SQL Server updates, builds, CUs, GDRs, and support status in one place. The data is automatically updated with…
Copy Job CDC with SQL estate is now GA in Microsoft Fabric
Originally published at https://shai-kr.github.io/data-ninja-ai-lab/blog/2026-05-26-copy-job-cdc-sql-estate-ga.html . Copy Job CDC with SQL estate i…