A boring setting with huge payoff.

In 2021, after catching the tech bug as a kid and earning a degree in communications, Ada got into tech writing by editing crypto guides. Ada's expertise now spans Windows, Android (especially Samsung ...

This article is not about ethics, privacy, security, ownership, or corporate governance — I am going to circumvent all of this here by using some made-up data relating to supermarket sales: Here, I ...

Every country produces data, but not every country produces it in an organized manner. What matters is not just the volume of data, but how it’s standardized and structured. The messiest or most data ...

Why write SQL queries when you can get an LLM to write the code for you? Query NFL data using querychat, a new chatbot component that works with the Shiny web framework and is compatible with R and ...

While running comp bio, comp chem, and ML engineering teams for several years, we faced two main problems: (1) We made incorrect assumptions about how datasets were generated because their processing ...

SQL is more than just a tool for querying data—it’s a fundamental skill for anyone serious about working in data-driven roles. Whether you’re diving into analytics, managing databases, or building ...

This article discusses how Power BI reports can be embedded into Fabric notebooks, combining data visualization with Python analysis in one place. It allows users to view interactive charts and graphs ...

A few years ago a new pair of Profiler events was added for Power BI Import mode datasets (and indeed AAS models): the Job Graph events. I blogged about them here but they never got used by anyone ...

For a database migration, schema validation plays a vital role. This Python based validation tool helps in finding the gaps between source and target database objects like Tables, Views, Indexes, Keys ...

ChatGPT, the AI language model from OpenAI, brings artificial intelligence to database management systems. However, ChatGPT’s query capabilities may be limited by the link, or lack thereof, between it ...