SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...

SQL Server Management Studio (SSMS) is the tool of choice for most developers when managing SQL Server and the relational data stored in it. Microsoft recently outlined plans for SSMS 22, currently in ...

Watch this recorded webinar where Microsoft MVP Steve Endow demonstrates some simple techniques that mere mortals can use to diagnose and optimize SQL Server queries. Topics include identifying ...

Although there was significant fanfare surrounding SQL Server Query Store's initial release in SQL Server 2016, many companies have been hesitant about adopting the performance monitoring and ...

I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

The latest version has reached general availability a few months after the release of v18.4. It brings a bunch of new features and general bug fixes, along with more specific improvements. In November ...

Microsoft releases SQL Server Management Studio 22.9.0 with GitHub Copilot, Database DevOps and SQL formatting enhancements. GitHub Copilot Ask Mode now generates reviewable T-SQL scripts, while Agent ...

Fix SQL Server connection problems If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist ...