Uzma Younas in SQL Server How to get clean, usable data out of SQL Server into Python Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis. Learn about views, CTEs, pruning,... 24 July 2026 11 min read 1
Grant Fritchey in AI AI built my WordPress plugin. Here’s what worked – and what went wrong (building an app with AI, part five) Learn what happens when you try building a working WordPress plugin for your app with AI - featuring plugin creation,... 20 July 2026 9 min read 11
Dejan Lukić in AI The best AI developer tools in 2026: from coding agents to code review A developer's honest take on the best AI tools for research, day-to-day coding, and code review in 2026 — covering... 15 July 2026 9 min read 21
Grant Fritchey in AI I let AI build my API. Here’s what happened (building an app with an AI LLM, part four) Learn how to use Microsoft CoPilot and GitHub Copilot to build a secure REST API— covering Azure deployment, PostgreSQL integration,... 13 July 2026 8 min read 1
Grant Fritchey in AI AI can build the pipeline, but don’t trust it for security (building an app with an AI LLM, part three) Learn what happens when you let GitHub Copilot and VSCode set up database migrations and a GitHub Actions pipeline on... 06 July 2026 8 min read 1
Abhishek Goyal in Development How I built a startup with no web development background: lessons from launching Unibridge The story of how I built Unibridge - a platform helping new arrivals navigate housing, banking, and SIM cards -... 03 July 2026 17 min read 2
Nick Harrison in Development How to match names in C# without exact string comparisons Learn how to build a confidence-based name matching system in C# using normalization, Double Metaphone, Jaro-Winkler, and weighted scoring.… 02 July 2026 22 min read 21
Chisom Kanu in Development Analytics in esProc SPL: a complete guide Understand analytics in esProc SPL with this comprehensive guide covering time series analysis, text processing, statistical methods, custom functions, machine... 25 June 2026 27 min read
Simple Talk Editor in Career From anthropology to analytics: how to build a data career with no prior experience (10 tips from a Microsoft MVP) No computer science degree, no clear plan - just deliberate moves and the right communities. Here's what Kristyna Ferris learned... 12 June 2026 10 min read 21
Uzma Younas in PostgreSQL How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale) In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.… 29 May 2026 10 min read 21
John Kerski in AI How DataOps principles help to reduce GenAI risk and improve data quality Learn how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. Tips for for Git, testing,... 08 May 2026 10 min read 11
Chisom Kanu in Development How to handle large datasets and parallel processing in esProc SPL Learn how esProc SPL handles large-scale data processing with efficient memory management, cursor-based processing, and parallel execution.… 22 April 2026 22 min read 11
Chisom Kanu in Development Data manipulation techniques in esProc SPL: a complete guide Understand data manipulation in esProc SPL. Learn how to clean, filter, merge, and reshape data efficiently compared to Python.… 14 April 2026 22 min read 1
Chisom Kanu in Development Data analysis in Python and esProc SPL compared – what are the differences, and which is best? Compare esProc SPL and Python for data analysis. Discover how esProc simplifies grouping, filtering, and data processing compared to Pandas.… 09 April 2026 19 min read 1
Chisom Kanu in Development Syntax and data structures in esProc SPL – a complete guide Explore esProc SPL's syntax and data structures. Learn how it compares to Python and discover its scripting capabilities for efficient... 06 April 2026 29 min read 1
Chisom Kanu in Development How to set up a data analysis environment in esProc SPL (compared to Python) Learn how to install and set up esProc SPL for data analysis. Compare esProc with Python and its unique features... 30 March 2026 23 min read 1
Joydip Kanjilal in .NET How to use refresh tokens in ASP.NET Core – a complete guide Learn all about JWT-based authentication, access and refresh tokens, and how you can implement them in an ASP.NET Core application.… 11 March 2026 19 min read 211
Andy Brown in Python Python is good, but not perfect – here are 10 reasons to avoid it Here are 10 reasons to avoid using Python for large or long-lived systems despite its strengths, featuring key limitations such... 12 February 2026 18 min read 11
Development Goodness Woke in Development Agile software development process vs DevOps and Waterfall Learn what the Agile software development process is, how it works, and how it compares to DevOps and the Waterfall... 09 January 2026 10 min read 1
Lee Asher in Python Incrementally Loading Data into Parquet with Python In this article, we'll introduce the Parquet format, explain some strategies for incrementally updating a Parquet repository, and, with a... 17 July 2025 14 min read 1
