July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Sharpen Your Basic SQL Server Skills – Learn the distinctions between unique constraint and primary key constraint and the easiest way to get random rows from a table

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Constraint and Keys
Read my article in SQL Server Magazine March 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 – 2005 – Licensing Model Compared to Other Database Products

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Data Warehousing, Database, DBA, Software Development, SQL Download, SQL Licensing
Yesterday on this blog I wrote about SQL SERVER – 2005 – Understanding Licensing Model. I have received many questions about pricing and comparing SQL Server with other RDBMS. One of the reason I like SQL Server because I am strong believer of licensed software usage and SQL Server is…
Read More

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