When an index facet is changed (e.g. the fill factor), EF currently generates a migration that drops and then recreates the index. First, we should add support for ALTER INDEX, which would be the p ...

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

Virtual tables connect the Power Platform to business data stuck in silos, enriching it to use with workflows, AI tools and custom apps.

In a SQL Server, two types of indexes exist; Clustered and non-clustered indexes. Both clustered indexes and non-clustered indexes have the same physical structure. Moreover, both of them are stored ...

The cache tables can be refreshed on-demand or on a schedule using a SQL Agent job. Using big data clusters for SQL Server 2019 public preview provides this capability. Intelligent Data – SQL Server ...

I was super-excited when, a few days ago, the long-awaited integration of Power Query into Microsoft Flow was announced. I was then gutted when work commitments meant I couldn’t blog about it right ...

The OLE DB Driver for SQL Server exposes the ITableDefinition::CreateTable function, allowing consumers to create [!INCLUDE ssNoVersion] tables. Consumers use CreateTable to create consumer-named ...

To import a table or view in your database all you have to do is right-click on your data source and choose Import New Tables; my blog post from September last year describes how to do this, and how ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...