Sql Studio 2014 ((exclusive)) Today
I closed SSMS 2014. The splash screen flashed for a second – the classic blue SQL Server logo. I saved my session (Session > Save as .sql) into a folder called Phoenix_Fixes . No Git. No CI/CD. Just a network drive and a prayer.
I connected to the production instance: FIN-SRV-03\LEGACY . The Object Explorer slowly populated – Databases > System Databases > WideWorldImporters (a test restore, thankfully, not live). Tables, Views, Stored Procedures… thousands of them. sql studio 2014
SELECT CustomerID, Quarter, Revenue FROM Sales.FactQuarters UNPIVOT (Revenue FOR Quarter IN ([Q1_2014],[Q2_2014],[Q3_2014],[Q4_2014],...,[Q4_2024])) AS unpvt; The little red squiggly line appeared under UNPIVOT . SSMS 2014’s parser didn't highlight syntax errors in real-time – but the did something worse when I pressed F5 : Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'UNPIVOT'. I laughed. Of course. SQL Server 2014 supports UNPIVOT, but someone had changed the database compatibility level to 90 (SQL Server 2005). A trap. I closed SSMS 2014
I wrote a query to unpivot a decade of quarterly sales: No Git
The dashboard query that had been timing out (45 seconds) dropped to . I sat back. The blue SSMS window – with its old-school toolbar icons and gray background – felt less like an IDE and more like a cockpit.
I closed SSMS 2014. The splash screen flashed for a second – the classic blue SQL Server logo. I saved my session (Session > Save as .sql) into a folder called Phoenix_Fixes . No Git. No CI/CD. Just a network drive and a prayer.
I connected to the production instance: FIN-SRV-03\LEGACY . The Object Explorer slowly populated – Databases > System Databases > WideWorldImporters (a test restore, thankfully, not live). Tables, Views, Stored Procedures… thousands of them.
SELECT CustomerID, Quarter, Revenue FROM Sales.FactQuarters UNPIVOT (Revenue FOR Quarter IN ([Q1_2014],[Q2_2014],[Q3_2014],[Q4_2014],...,[Q4_2024])) AS unpvt; The little red squiggly line appeared under UNPIVOT . SSMS 2014’s parser didn't highlight syntax errors in real-time – but the did something worse when I pressed F5 : Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'UNPIVOT'. I laughed. Of course. SQL Server 2014 supports UNPIVOT, but someone had changed the database compatibility level to 90 (SQL Server 2005). A trap.
I wrote a query to unpivot a decade of quarterly sales:
The dashboard query that had been timing out (45 seconds) dropped to . I sat back. The blue SSMS window – with its old-school toolbar icons and gray background – felt less like an IDE and more like a cockpit.