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…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
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…