June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Data Warehousing, Database, DBA, MVP, Openday, SQL Backup and Restore, SQL Download, SQL Scripts, SQL User Group, SQLAuthority Author Visit
Ahmedabad SQL Server User Group Meeting was organized on November 29, 2008 at famous C.G. Road in Ahmedabad. We had great response and wonderful back to back technical sessions. The highlight of whole meeting was participation of UG President Jacob Sebastian – SQL MVP from New York. Meeting started with…
Read More

SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, Openday, SQL Backup and Restore, SQL User Group, SQLAuthority Author Visit
Today is special day for SQL Server enthusiastic as we will have SQL Server User Group Meeting today in Ahmedabad. Today in User Group we will have UG President Jacob Sebastian (MVP) participating from New York and UG Vice President Pinal Dave (MVP) will talk about “How to become MVP?”…
Read More

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 – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Backup and Restore, SQL Data Storage, SQL Replication, SQLAuthority Book Review
Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover) by Sujoy Paul (Author) Link to Amazon Quick Review: This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept…
Read More

SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure
Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log works and Shrinking of Log works. Question from lauraV Please help me understand. I am taking a…
Read More

SQL SERVER – mssqlsystemresource – Resource Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL System Table
Just a day ago I received following email “Dear Pinal, While I was exploring my computer in directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data I have found database mssqlsystemresource. What is mssqlsystemresource? Thanks, Joseph Kazeka” Simple question like this are very interesting. mssqlsystemresource is Resource Database. It is read only database and…
Read More

SQL SERVER – FIX – ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts
ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. If you receive above error it means you are in great trouble. This error occurs when database is attempted…
Read More