SansSQL is a technical blog focused on databases, data analytics, cloud, big data, and cybersecurity. It publishes tutorials, comparative reviews, architectural principles, scripts, and best practices–often for Microsoft SQL Server, cloud design, and data systems.
Key Themes & Content Focus
-
The blog features database fundamentals, such as the difference among databases, data warehouses, data lakes, and lakehouses.
-
It emphasizes Microsoft SQL Server topics (e.g. backups, replication, collation, T-SQL scripts).
-
Posts cover cloud architecture principles, especially for scalable, resilient, and secure environments.
-
It also handles big data use cases, showing how analytics benefit manufacturing, prediction, quality control etc.
-
The site includes technical tools / scripts, such as T-SQL scripts to fetch backup sequences or change server collation without rebuilding system databases.
-
The content is written mostly by a consistent author voice (Sandesh Segu) and guest contributors.
-
The blog has archives spanning many years (back to 2007) and periodic posts up to 2023.
-
It also includes sidebar tools or “apps,” such as calculators (e.g. SQL Server memory recommendation) and utilities.
Strengths & Limitations
| Aspect | Strengths | Limitations / Considerations |
|---|---|---|
| Depth in SQL / Server Topics | Good command of SQL Server internals and practical scripts | Less coverage for non-SQL or non-Microsoft ecosystems |
| Breadth in Data & Cloud | Balances between database, analytics, and cloud design topics | May lack deep coverage on newer architectures like serverless, data mesh |
| Longevity & Archive | Rich archive across many years, showing evolution of practices | Older posts may refer to outdated versions or deprecated features |
| Practical Utility | Scripts, real examples, architectural guidance | Some posts assume prior technical knowledge; beginners might struggle |
| Consistency & Focus | Clear focus on data, DB, cloud topics | Less on UI, front end, or general software development |