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
All Articles warning

SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)

Pinal Dave
SQL
SQL Error Messages, SQL Server, Starting SQL

Just a day ago while playing with SQL Server I suddenly faced a new kind of error, which I have never seen before. This error happens when clicked on New Query in SQL Server Management Studio. Let us learn in this blog post how we will fix the error – cannot find template file for a new query. 

Read More