Site Owners

SQLServerCentral.com site owners.


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-04-25 (first published: )

12,215 reads

Introduction to PostgreSQL for the data professional

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.

You rated this post out of 5. Change rating

2025-04-24 (first published: )

331 reads

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

5 (1)

You rated this post out of 5. Change rating

2025-04-24 (first published: )

9,977 reads

Practical Graph Structures in SQL Server and Azure SQL: Enabling Deeper Insights Using Highly Connected Data

Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships.

You rated this post out of 5. Change rating

2025-04-23 (first published: )

1,183 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-04-16 (first published: )

9,553 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.

5 (1)

You rated this post out of 5. Change rating

2025-04-14 (first published: )

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

3.5 (2)

You rated this post out of 5. Change rating

2025-04-09 (first published: )

3,913 reads

Blogs

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

KDA: Echoes of Deception - Onboarding

By

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

By

While I mostly write about SQL Server, I have a soft spot for Kusto....

Read the latest Blogs

Forums

officialsprinklezshop.com/Buy Sprinklez Cotton Candy Vanilla Swirl Strain

By favouritechemist

Website: https://officialsprinklezshop.com/ Buy Best quality Sprinklez Strain from Officail Sprinklez Shop Sprinklez Cotton Candy...

https://officialsprinklezshop.com/ Sprinklez Super Sweet Sugar Sparks Strain

By favouritechemist

Website: ttps://officialsprinklezshop.com/ Buy Top Notch quality product from Official Sprinklez Shop. 100% Trusted -...

https://officialsprinklezshop.com/Sprinklez Peanut Butter Jelly Milkshake Strain

By favouritechemist

Website: https://officialsprinklezshop.com/ Buy Sprinklez Strain From Official Sprinklez Shop. 100% Trusted, Top notch quality product...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers