Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

If you've just started writing SQL Server queries, there's a good chance you probably wrote a query, saw it return the right ...

Microsoft announced the general availability of SQL Server 2019 and SQL Server Big Data Clusters at its Ignite conference on Monday. SQL Server 2019 builds on intelligent query processing features ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

This is an updated version of a classic book teaching SQL. It's an excellent choice if you don't know SQL and need to get to grips with it. The ideal reader would be someone who's beginning to use SQL ...

While it may sound as though it's aimed at people who don't know SQL, in reality there are topics in this book that would be useful no matter how good you are at writing SQL code. If, however, you don ...

Microsoft has found a new use for natural language processing capabilities in machine learning large language models (LLMs): SQL queries. The company has set up a sandbox for developers and data pros ...