If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...

Effectively, those methods can become just thin wrappers around SQL queries. If you want to play with SQL Server’s JSON support (or the other big new feature in SQL Server 2016, temporal tables), you ...

Saved searches Use saved searches to filter your results more quickly ...

There is nothing quite so eye-catching in SQL Server 2016, though in-memory OLTP is actually more usable than before, with a much wider subset of T-SQL supported, including FOREIGN KEY, UNIQUE and ...

Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example). However there are a few advanced options, not all of which are ...

Part of the SQL Server 2022 blog series.. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is ...