At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment ...

We consider the problem of creating a sample view of a database table. A sample view is an indexed materialized view that permits efficient sampling from an arbitrary range query over the view. Such ...

Learn the basics of views and materialized views in SQL, how they differ, and how to choose the best option for your queries.

CTE queries are a very common method of extracting data from tables and it is used extensively. The results of such queries being set up as materialized view is extremely valuable. Currently a ...

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

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.

And while Steampipe’s primary benefit is live querying of APIs, you can create materialized views to persist that data and write Postgres functions to operate on it.