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-01-09 (first published: 2025-10-14)
2,712 reads
Books
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-01-07 (first published: 2024-11-25)
11,529 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.
2026-01-05 (first published: 2025-10-14)
1,240 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:
2026-01-02 (first published: 2024-12-05)
2,822 reads
Architecting Power BI Solutions in Microsoft Fabric
Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.
2025-12-31 (first published: 2025-05-27)
4,060 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-29 (first published: 2024-09-18)
3,097 reads
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,595 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,130 reads
SQL Server 2022 Query Performance Tuning
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.
2025-12-19 (first published: 2025-05-27)
1,555 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)
131 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers