Site Owners

SQLServerCentral.com site owners.

All authors

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.

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.5 (2)

You rated this post out of 5. Change rating

2025-03-31 (first published: )

3,860 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.

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-03-28 (first published: )

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

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2025-03-26 (first published: )

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

  • Printed book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2025-03-26 (first published: )

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

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-03-19 (first published: )

11,631 reads

Practical Database Auditing for Microsoft SQL Server and Azure SQL

Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2025-03-05 (first published: )

7,592 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.

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-03-03 (first published: )

315 reads

All authors

Blogs

Who are you? Building an identity map.

By

I admit that until I read the article, Who are you as a Leader?,...

Call a Fabric REST API from Azure Data Factory

By

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...

Distributed Availability Group Dashboard

By

The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...

Read the latest Blogs

Forums

How to update a history table with changes.

By bswhipp

Good morning to all.  I am a novice when it comes to SQL so...

How to check if credential password for TDE matches the secret key of Key Vault

By Micuen Tabazura

Hi all, In my company we have many databases encrypted with TDE and there...

Create Raw Zone Tables using Generative AI: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Create Raw Zone Tables using...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022? 

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy