`Set-SqlDscDatabaseDefaultFileGroup`: Add new command

[coderabbitai]

Description

Add a new command Set-SqlDscDatabaseDefaultFileGroup to set the default filegroup and default FILESTREAM filegroup for a SQL Server database using the SMO SetDefaultFileGroup() method.

Context

This command is needed to handle database filegroup settings that require SMO method calls rather than simple property assignments. The SetDefaultFileGroup() and SetDefaultFileStreamFileGroup() method should be used to configure:

• DefaultFileGroup
• DefaultFileStreamFileGroup

Proposed Solution

Create a new public command Set-SqlDscDatabaseDefaultFileGroup that:

• Accepts either ServerObject + Name or DatabaseObject parameter sets (following the pattern established in Set-SqlDscDatabaseOwner)
• Uses the SMO SetDefaultFileGroup() method to apply changes
• Supports ShouldProcess, Force, and PassThru parameters
• Includes appropriate parameter validation and error handling

Related

• Original issue: Set-SqlDscDatabase: Add parameters to command #2177
• Implementation PR: Set-SqlDscDatabaseProperty: Refactor command #2327
• Comment: Set-SqlDscDatabaseProperty: Refactor command #2327

Requested by @johlju

[github-actions]

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.