How many of us clean up our databases and is it worth it? Steve has a few thoughts.

Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric

by John Miner

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Learn how updates and concurrency can work in Fabric with Delta Parquet data.

Casino night is back at PASS Summit 2024!

by Additional Articles

SQLServerCentral

PASS Summit

Back by popular demand, casino night from SQL Server Central will return to PASS Summit this year. Casino night will take place on November 5 after the welcome reception. Tickets will be allocated at random via a lottery.

Microsoft Fabric and PySpark: Coding tricks to improve your solutions

by Additional Articles

SimpleTalk

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

PySpark has some unconventional syntaxes which provide power to the development process, making it easier.

Converting Old Running Total Code to Window Functions

by Steve Jones

SQLServerCentral

T-SQL

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.

Effective Engineering

by Steve Jones

SQLServerCentral

Platform engineering is a new area of focus for some, but it's already being seen as passé by some. Steve notes that there isn't a magic bullet for building better software. It comes about by us working together.

SQL Index Rebuild vs Reorganize Comparison

by Additional Articles

MSSQLTips.com

This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.

Unstuck

by RyanBooz

SQLServerCentral

Have you ever been stuck in some area of your life? Maybe at work? That big project. Progressing in your career. The slow query that seems impossible to make faster. Learning new skills to switch careers. Maybe outside of work? The weekend home project that’s been going on for more than a few weekends… possibly […]