News

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 ...
CREATE XML INDEX (Transact-SQL) [!INCLUDE SQL Server SQL Database] 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 ...
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.
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. However, ...
Loosely-coupled, distributed system architectures need to be flexible enough to allow individual components to join or leave the heterogeneous conglomerate of services and components and to change ...
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.