Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: xsd

Generate DDL Statement from XSD file

By adminPosted on May 27, 2021

Question : I have a database schema exported into XML format. My goal is to create a DDL statement from […]

How to resolve this ‘XML Validation: Declaration not found for element’ error?

By adminPosted on May 14, 2021

Question : I’m new to SQL Server and I have this task to complete (for learning purposes), yet I’m unable […]

Loading Extended Events ring buffer to SQL table using powershell

By adminPosted on January 13, 2021

Question : I am running a RPC_Completed extended event which outputs to a ring buffer. While trying to read the […]

What’s the relationship between Documents, XSDs and Collections?

By adminPosted on July 1, 2020

Question : I have a number of XML Schema Definitions describing business objects. It’s unclear to me what the correct […]

Is there a way to validate XML using variable as schema?

By adminPosted on January 17, 2020

Question : Is there a way to declare XSD schema as variable inside a construct: DECLARE @xml XML(Books)? I need […]

Recent Posts

  • Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?
  • Create a user on database A with a procedure from database B (with EXECUTE AS)
  • Mysql pivot rows
  • SQL Server CLR procedures and SQLCLR_QUANTUM_PUNISHMENT
  • backup history using availability groups
  • How to prevent database shrinking
  • postgres select aggregate timespans
  • mysql simple update with 40 million and 128GB RAM taking too much time
  • Suggestion for enforcing unique constraint in a table where soft delete is implemented [duplicate]
  • Implementing something similar to “pointer arrays” with MySQL
  • What are valid connection strings for SSMS login box?
  • ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full
  • Faulty oracle11g regexp_replace on removing duplicates
  • MySQL – Can I have quick queries in a table with 200 million rows?
  • Automatic index creation for primary vs. foreign keys in Postgresql
  • In PostgreSQL, how do I make it so that either column A or column B must be non-null?
  • Automate backup using Windows Task Scheduler
  • Naming Convention for Login, User and Roles? [closed]
  • Changing from utf8 to utf8mb4
  • How to get a COUNT for both IN and NOT IN a table

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding