Delete or Cleanup Backup History in sql server.

All backup history is stored in msdb database.

The following stored procedure can be executed with the parameter, here we clean history before 30 days.   

USE msdb
GO
DECLARE 
@BeforeDays DATETIME
SET 
@BeforeDays = CONVERT(VARCHAR(10), DATEADD(dd, -30,GETDATE()), 101)
EXEC 
sp_delete_backuphistory @BeforeDays
GO


 how to enable prevent save changes in SQL Server?

Go into Tools -> Options -> Designers-> Uncheck "Prevent saving changes that require table re-creation"

PostgreSQL-Query: Sort result set by specific field values using ORDER BY Clause

Problem: Suppose we have a book_inventory table which has some columns such as id, isbn, title, author, publisher, publish_date, etc.. whe...