SQL Server 2019 supports non-XML format files and XML format files for bulk exporting and importing. Find out about non-XML format files and their benefits. You can create a non-XML format file ...

Creates an XML index on a specified table. An index can be created before there is data in the table. XML indexes can be created on tables in another database by specifying a qualified database name.

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.

Abstract: XML is often used to represent objects that expose different sets of properties. This "property bag" scenario is a prominent use case for the XML support added to Microsoft SQL Server 2005.

This post is part of “Overview of NAV-specific SQL features for application consultants”. This post describes the steps needed to create a new NAV database from a NAV backup (.fbk) file. All the steps ...