Books

Deciphering Data Architectures

Deciphering Data Architectures

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

You rated this post out of 5. Change rating

2024-10-11 (first published: )

3,046 reads

Azure SQL Revealed

Azure SQL Revealed: A Guide to the Cloud for SQL Server

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.

You rated this post out of 5. Change rating

2024-10-09 (first published: )

3,730 reads

Definitive Guide to DAX cover

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.

You rated this post out of 5. Change rating

2024-10-07 (first published: )

359 reads

The Phoenix Project

The Phoenix Project

In this newly updated and expanded edition of the bestselling The Phoenix Project, co-author Gene Kim includes a new afterword and a deeper delve into the Three Ways as described in The DevOps Handbook.

You rated this post out of 5. Change rating

2024-10-04 (first published: )

2,234 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

2024-10-02 (first published: )

6,180 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

2024-09-27 (first published: )

1,274 reads

SQL Server 2022 Administration Inside Out

Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance.

You rated this post out of 5. Change rating

2024-09-25 (first published: )

5,401 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

2024-09-20 (first published: )

7,183 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

5 (1)

You rated this post out of 5. Change rating

2024-09-18 (first published: )

6,468 reads

Blogs

Build Recovery into the Design

By

It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...

dataMinds Connect 2024 – Session Materials

By

The slides and scripts for my session “Tackling the Gaps & Islands Problem with...

Want to Supercharge Your Business? SQL is Your Secret Weapon.

By

Look, we all know data is king these days. But having mountains of data...

Read the latest Blogs

Forums

Log Backup failed on Secondary Replica

By aroojsql

I have a scenario where log backup is getting failed in Secondary replica on...

Everything is Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Everything is Code

Statistics Histograms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Histograms

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers