Deprecated

Get-DbaDbFeatureUsage

Brandon Abshire, netnerds.net

Get-DbaDbFeatureUsage View Source Brandon Abshire, netnerds.net Windows, Linux, macOS Synopsis Identifies Enterprise-edition features currently used in databases that prevent downgrading to Standard edition Description Queries the sys.dm_db_persisted_sku_features dynamic management view to identify SQL Server Enterprise features that are actively used in your databases. This is essential when planning to downgrade from Enterprise to Standard edition or migrating databases to environments with lower SQL Server editions. Enterprise features like columnstore indexes, table partitioning, or transparent data encryption must be removed or disabled before a database can be successfully migrated to Standard edition.

Get-DbaDeprecatedFeature

Chrissy LeMaire (@cl), netnerds.net

Get-DbaDeprecatedFeature View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Identifies deprecated SQL Server features currently in use with their usage counts from performance counters. Description Queries the sys.dm_os_performance_counters system view to identify which deprecated SQL Server features have been used on your instances and how frequently they’ve been accessed. This information is essential for upgrade planning, as deprecated features may be removed in future SQL Server versions and could cause application failures.