Also, if I chose to have no relationships in my SQL and simply pulled table data directly, it would be exactly as fast or faster than NoSql. 9) Flexibility is a double-edged sword.

All of the fields in a table row are said to make up a complete “entity.” If you query every row in a table for a single field, such as the first name from the person table, the results return as a ...

My second assumption is that "all the columns" is some small number -- a couple of dozen columns, for example. If you have a table with hundreds of columns, then it's certainly possible that you'll ...

In an earlier column, I showed how to create a temporal table in SQL Server 2016 or Azure SQL Database. Once you've defined a temporal table, SQL Server automatically keeps a history of all the ...

While SQL is readily available on most platforms these days, there are other alternatives—including NoSQL and NewSQL—that have arisen to address “big data,” as well as less-structured content.

Pandemic conspiracy-mongers shared the stage with scientists and public health advocates at a Stanford University conference. Should they have even been let into the room?

A column should read like an impassioned (or funny or tragic) letter; a news story should read like hurried, but coherent, history.” Occasionally, a reporter will write a column.

A popular sandwich chain in Hampton Roads is Which Wich. This got me thinking about the play on words for the sandwich chain and the difference between the words “which” and “that… ...

There’s a lot of difference between a news story, an editorial and a column Wed., Feb. 8, 2017 Undated historical photo of staff writers at the Spokesman-Review.

On Oct. 4, Stanford University's newly minted president, Jonathan Levin, opened an on-campus conference about pandemic policies by expressing the hope that the proceedings would "bring together ...