Product(s): SQL Server
Overall Comment:"SQL Server 2022 has been rock solid for our enterprise workloads. I use it heavily for ETL, reporting, and cross-database querying. We host a ~1 TB data warehouse on our on-prem SQL Server and have been thrilled by performance and recent improvements to make it easier to integrate with Fabric in the cloud"
1) T-SQL power and flexibility - robust language for complex queries 2) Clustered columnstore indexing - A true game changer for performance. We could not live without this. 3) Integration with the Microsoft ecosystem and seamless handoff to reporting tools that we use for BI
Inconsistent feature parity - Some features only work in Enterprise which can be confusing. SSIS modernization lag - Specifically it is difficult to use API data sources without paying extra for 3rd party software add ins. Limited version control - No built in change tracking. Must rely on third party tools.