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
2025-12-26 (first published: 2025-10-14)
2,045 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.
2025-12-24 (first published: 2024-09-18)
5,492 reads
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.
2025-12-22 (first published: 2025-10-14)
2,035 reads
Murach's SQL Server 2022 for developers
Murach's SQL Server 2022 for Developers is a comprehensive guide to database design and management. This computer book teaches essential SQL statements through clear examples and practical exercises. The book's unique paired-pages format makes learning database software concepts easier, while providing in-depth coverage of database management fundamentals. Ideal for both beginners and seasoned developers seeking to enhance their data management skills.
2025-12-17 (first published: 2025-10-14)
933 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
2025-12-15 (first published: 2024-11-25)
10,993 reads
The Phoenix Project: A Graphic Novel about IT, DevOps, and Helping Your Business Win
Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.
- Printed book:
2025-12-11 (first published: 2024-12-05)
2,660 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:
2025-12-05 (first published: 2025-11-10)
122 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.
2025-12-03 (first published: 2024-09-18)
2,859 reads
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, 3rd Edition
Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.
2025-11-17 (first published: 2023-06-19)
13,498 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.
2025-11-14 (first published: 2025-02-06)
4,748 reads
Blogs
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers