Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI In the era of big data and diverse data formats, the ability to store and query semi ...

Community driven content discussing all aspects of software development from DevOps to design patterns. If you plan to do database development with Java and MySQL, the first thing you’ll need to do is ...

What was considered best practice yesterday does not hold true today and this is especially relevant when it comes to XML sitemaps, which are almost as old as SEO itself. The problem is, it’s ...

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data. In May 1974, Donald Chamberlin and Raymond Boyce published a paper on ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...