July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Download
SQL Server Compact 3.5 SP1 Beta release for the ADO.Net Entity Framework Beta 3 enables the following scenarios: Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships Applications are freed from hard-coded dependencies on a particular data engine or storage…
Read More

SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Scripts
Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More

SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Data Warehousing, Database
Top 10 Best Practices for SQL Server Maintenance for SAP By Takayuki Hoshino SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation. 1) Perform a full database backup daily 2) Perform…
Read More