If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

Cloud-native databases deliver agility and scale. Distributed SQL is an evolution of the database for cloud native, distributed transactions. It can implement a standard SQL interface, ease ...

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

Cosmos DB provides us, with its SQL API a useful adjunct to a relational database system, and the SQL it offers is an easy way in to the technologies of JSON, document databases, NoSQL and big data.

SQL Server: The traditional database engine, which also stores SSRS catalog data. SQL Server Analysis Services (SSAS): A component for online analytical processing (OLAP) and data mining.