Site Owners

SQLServerCentral.com site owners.

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.

You rated this post out of 5. Change rating

2026-02-02 (first published: )

3,089 reads

The Phoenix Project

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.

(1)

You rated this post out of 5. Change rating

2026-01-26 (first published: )

2,956 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.

You rated this post out of 5. Change rating

2026-01-05 (first published: )

1,378 reads

Big Data Analytics cover

Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis

Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.

(2)

You rated this post out of 5. Change rating

2025-10-08 (first published: )

5,543 reads

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.

You rated this post out of 5. Change rating

2025-10-03 (first published: )

10,548 reads

The Unicorn Project

In The Unicorn Project, we follow Maxine, a senior lead developer and architect, as she is exiled to the Phoenix Project, to the horror of her friends and colleagues, as punishment for contributing to a payroll outage. She tries to survive in what feels like a heartless and uncaring bureaucracy and to work within a system where no one can get anything done without endless committees, paperwork, and approvals.

You rated this post out of 5. Change rating

2025-09-15 (first published: )

4,439 reads

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

You rated this post out of 5. Change rating

2025-08-06 (first published: )

14,023 reads

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Are luxury packages in Andaman suitable for a honeymoon?

By andamantourtravelpackage

Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

By rdr1

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table:

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers