Should you memorize all SQL grammar and syntax before starting work? I saw such a question on X the other day. There were two main options. You have almost everything memorized and can write it ...

In today’s AI-driven world, AI tools for data analysis have supercharged the ability to extract meaningful insights from vast datasets. Traditional data analysis methods are often slow and struggle to ...

The data industry has arrived at a pivotal juncture that echoes the themes we’ve charted in previous Breaking Analysis episodes, from The Sixth Data Platform through The Yellow Brick Road to Agentic ...

Would you like to avoid spending your weekends patching servers? The new Hotpatch feature in Windows Server 2022 Datacenter: Azure Edition addresses this pain point—it can reduce many IT teams’ ...

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 ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

Part of the SQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates ...

Data predominantly is core to any and every organisation and so does Data Engineering. Especially in financial/banking industry where data’s availability and its fast processing in timely manner is ...