I always want to learn SQL Server and XML file. Let us go over a very simple example, today about how to create XML using SQL Server.
JSON_PATH_EXISTS: Distinguish Missing and Null Properties
JSON_PATH_EXISTS tests path presence, including JSON null. Compare missing properties, empty arrays and SQL NULL on SQL Server 2022.
SQL SERVER – Start SQL Server Instance in Single User Mode
How to start a SQL Server instance in single user mode: add the -m; startup parameter in SQL Server Configuration Manager and restart the service.
Choosing the Server Collation at Install Time
Choose the server collation before installation by checking application comparisons, tempdb behavior, and the cost of changing an instance later.
Contained Databases and Contained Users
Understand contained users in SQL Server databases, how they travel with a database, and the security trade-offs of partial containment.
TRY_PARSE: Make the Culture Explicit for Numeric Text
TRY_PARSE needs an explicit culture when punctuation has a specific numeric meaning. I keep that culture beside the source text. A successful conversion alone cannot establish that the intended number was read.
Using sp_help and Friends to Explore a Database
Using sp_help, sp_helpindex, sp_helptext, and sp_spaceused gives a quick SQL Server tour before you reach for catalog views.