Site Owners

SQLServerCentral.com site owners.

SQLServerCentral Article

SSC Spam

You may have spotted we currently have some issues with spambots affecting our chat forums. We're working through this at speed to get the issues resolved and the offending posts removed. Please bear with us while we fix this, and please don't log into any spam post and attempt to view or download attached files.

You rated this post out of 5. Change rating

2026-05-05

97 reads

Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes

Ready to simplify the process of building data lakehouses and data pipelines at scale? In this practical guide, learn how Delta Lake is helping data engineers, data scientists, and data analysts overcome key data reliability challenges with modern data engineering and management techniques.

You rated this post out of 5. Change rating

2026-05-04 (first published: )

1,162 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.

You rated this post out of 5. Change rating

2026-02-02 (first published: )

3,239 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,431 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,560 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,579 reads

Blogs

T-SQL Tuesday #202: 100 Hours

By

It’s time for T-SQL Tuesday again and this is a great prompt to start...

T-SQL Tuesday

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search

By

How I used AI for this postChatGPT to generate images based on info specifically...

Read the latest Blogs

Forums

Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform

By mehul.bhuva@gmail.com

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

The Costs of Multiple Platforms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs of Multiple Platforms

RegEx Functions II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions II

Visit the forum

Question of the Day

RegEx Functions II

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM
If I run this query, which row(s) are returned?
SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)

See possible answers