As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

Microsoft today announced a new service in its Azure database lineup during its Build developer conference keynote today. The Azure SQL Data Warehouse, which will go into public preview in June, is ...

The first generation of Azure SQL Data Warehouse (SQL DW) was announced in 2015, and SQL DW "Gen 2" reached general availability in 2018. Today, at its Ignite confab on Orlando, Microsoft is ...

For too many companies, the data warehouse remains an unfulfilled promise. The work that was started with data warehouses to create a living, clearly defined source of truth about what is happening in ...

The "data" part of the terms "data lake," "data warehouse," and "database" is easy enough to understand. Data are everywhere, and the bits need to be kept somewhere. But should they be stored in a ...

Many organizations nowadays are struggling with finding the appropriate data stores for their data. Let’s zoom in on some key data structures to facilitate corporate decision making by means of ...