T-SQL Fundamentals
For anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance
2026-08-12 (first published: 2025-10-14)
3,825 reads
Site Owners
Refactoring Databases: Evolutionary Database Design
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.
2026-08-10 (first published: 2024-09-18)
7,139 reads
Introduction to PostgreSQL for the data professional
Adoption and use of PostgreSQL is growing all the time. From mom-and-pop shops to large enterprises, more data is being managed by PostgreSQL. In turn, this means that more data professionals need to learn PostgreSQL even when they have experience with other databases. While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.
2026-08-07 (first published: 2025-02-06)
6,106 reads
Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle.
2026-08-03 (first published: 2026-02-03)
1,248 reads
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
This book is your comprehensive guide to building robust Generative AI solutions using the Databricks Data Intelligence Platform. Databricks is the fastest-growing data platform offering unified analytics and AI capabilities within a single governance framework, enabling organizations to streamline their data processing workflows, from ingestion to visualization. Additionally, Databricks provides features to train a high-quality large language model (LLM), whether you are looking for Retrieval-Augmented Generation (RAG) or fine-tuning.
2026-07-31 (first published: 2026-02-03)
2,192 reads
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
With built-in AI for application development and advanced analytics powered by Microsoft Fabric, SQL Server 2025 empowers you to innovate—securely and confidently. This book shows you how.
- Printed book:
2026-07-29 (first published: 2025-11-10)
2,249 reads
Storytelling with Data: Let's Practice!
Influence action through data! This is not a book. It is a one-of-a-kind immersive learning experience through which you can become—or teach others to be—a powerful data storyteller.
2026-07-06 (first published: 2026-02-03)
1,703 reads
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization.
2026-07-03 (first published: 2024-09-18)
5,123 reads
Pro SQL Server Internals
Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions
2026-06-29 (first published: 2026-06-12)
319 reads
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases
2026-06-08 (first published: 2024-11-25)
14,184 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers