AI hype has triggered millions of people and many corporations to dabble in AI with some launching full-blown applications.

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...

Community driven content discussing all aspects of software development from DevOps to design patterns. The key difference between columns and rows is that a column arranges data vertically from top ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment in its ...

Community driven content discussing all aspects of software development from DevOps to design patterns. Have you ever wondered why Bootstrap, the popular JavaScript framework designed to create ...

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

I'm using a EF Core 6 DbContext transaction to create/update entities on a SQL Server temporal table. The data I'm processing (array of items) has a key (Year-Sequential, like: 2023-001, 2023-002, etc ...

When designing objects in SQL Server, we must follow certain best practices. For example, a table should have primary keys, identity columns, clustered and unclustered indexes, data integrity and ...

In Microsoft Excel, there are row and column headings on your spreadsheet by default. The column header is the grey color alphabetical columns above the spreadsheet, and it identifies each column, ...