Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Delete Backup History – Cleanup Backup History

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Scripts, SQL Stored Procedure
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to…
Read More

SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, DBA, MVP

I just received the following screen shot from one of the regular readers of the SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 million visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 million visitors. I even missed the anniversary our blog. On November 1st, 2008 SQLAuthority.com has completed 2 years of its existence and now continuing in 3rd year.

Read More

SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts
I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for which is default for some of the database user. When user try to login and their default database…
Read More

SQLAuthority News – SQL Server Security Whitepapers

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Server Security, SQL White Papers
Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in those  white papers. Engine Separation of Duties for the Application Developer – Separation of duties is an important consideration for databases and database applications.…
Read More