Tag Archives: sql server

New SQL Server 2022 Functions

At the recent 2024 PASS Data Community Summit, I saw a lightning talk from Mikey Bronowski on the New T-SQL Functions in SQL Server 2022.  Before the talk, I made a joke with him that none of these were new … Continue reading

Posted in Editorial | Tagged , | 6 Comments

The Stretch Database Retirement

Stretch Database is finally going away. It is being retired. It was deprecated on Nov 16, 2022, from SQL Server 2022. Effective Jul 9, 2024, the supporting Azure service is retired. I saw this in an announcement on Jul 3, … Continue reading

Posted in Editorial | Tagged | Comments Off on The Stretch Database Retirement

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server accurately tracking history across time and noted they hadn’t cleaned any … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Free SQL Server

No, I don’t have a way to license a SQL Server instance for your application for free. Microsoft still charges for production workloads. However, there are several ways that you can do development or testing for free, or at a … Continue reading

Posted in Editorial | Tagged | 2 Comments