Explores Microsoft's new Columnstore compression estimation in SQL Server 2019, comparing it to a custom system stored procedure.
A technical guide on splitting delimited text into a table using DAX functions like PATH, GENERATESERIES, and PATHITEM for Power BI data modeling.
Developer shares the story behind building feediary.com, a privacy-focused, ad-free RSS reader, to escape Twitter's algorithmic feed and information overload.
Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
Announcing two full-day SQL Server workshops at SQLSaturday Lisbon 2018, featuring Query Store troubleshooting and performance tuning.
A critique of speakers who cancel free tech events, arguing they disrespect attendees' time and organizers' resources despite no ticket revenue.
An organizer explains the hidden costs behind free IT community events, from venue and food to materials and sponsor expectations.
A reflection on the challenges and principles of organizing a truly independent tech conference, focusing on community over self-promotion.
A guide on creating a Power BI Push Dataset using Power BI Desktop and the PowerBIPS.Tools module to simplify API dataset creation.
A guide to setting up and testing with a MySQL 5.7 database on the Codeship continuous integration platform.
Explores the challenges of applying open source software freedoms to web services and introduces the Fair Web Services project.
A project to map and analyze the governance models of various open source projects, creating a machine-readable resource for comparison and learning.
A personal reflection on the author's 5-year journey writing a blog series about SQL Server Columnstore Indexes, from initial posts to becoming an expert.
A review of Robert C. Martin's 'Clean Architecture' book, covering its core principles, structure, and insights on software design.
A developer explains the decision to avoid CSS Custom Properties for a paid theme feature to maximize browser compatibility, discussing progressive enhancement trade-offs.
Author announces 'Practical Python Projects' book, designed to teach intermediate Python through 15+ real-world, portfolio-ready projects.
Explores Microsoft's Resumable Online Index Creation feature in Azure SQL DB, detailing its benefits for managing large databases without downtime.
A developer's retrospective on the mistake of shipping a product too late, with insights from their fourth month working on Zestful.
Author shares excitement about being selected to speak at PASS Summit 2018 on SQL Server Columnstore index selection.
The author praises Joe Obbish's blog for its original, critical analysis of the SQL Server Query Optimizer, declaring it the Data Platform blog of 2017.
