Our Team and Culture

No matter what type of project you envision, Ideal State will help make it a smashing success. Deliver innovative solutions that improve citizen and employee experience and increase mission impact.

Contacts

Irvine, CA USA

info@globaladmins.com

+1 (949) 346 5577

Linkedin
Uncategorized

“Unlock Unsupported Characters with Azure Database Creation Using T-SQL or SSMS”

Azure Database Creation using T-SQL or SSMS Currently Allows Unsupported Characters in its Name
Introduction
Azure Database is a cloud-based database solution developed by Microsoft. It is used to store and manage data in a secure and scalable manner. While creating databases in Azure, administrators can specify the database name. To ensure the reliability and security of the database, certain characters are not allowed in the database name. However, a recent issue has been identified where users are allowed to create databases with unsupported characters in the database name.

What is the Issue?
When creating a database in Azure using T-SQL or SSMS, users are able to specify a name containing unsupported characters. These characters include spaces, periods, and other special characters. This can lead to issues with the database, such as accessing the data or running queries. This issue has been identified and is currently being addressed by Microsoft.

What is the Impact?
The use of unsupported characters in the database name can lead to a number of issues. These include:

* Data access issues due to the use of unsupported characters in the database name.
* Difficulty running queries due to the use of unsupported characters in the database name.
* Data corruption due to the use of unsupported characters in the database name.
* Inability to back up or replicate the database due to the use of unsupported characters in the database name.

What Are the Solutions?
Microsoft is currently working on a solution to address the issue of unsupported characters in the database name. The solution will require users to specify a valid name when creating a database.

Conclusion
Azure Database is a powerful and secure cloud-based database solution developed by Microsoft. However, the use of unsupported characters in the database name can lead to a number of issues. Microsoft is currently working on a solution to address this issue. As a Cloud Architect consultant, it is important to be aware of this issue and the potential implications it can have on the database.
References:
Azure Database creation using T-SQL or SSMS currently allows Unsupported characters in it’s name.
.

1. Azure SQL Database
2. T-SQL Database Creation
3