My personal website pinaldave.com is renovated. It now links to my blog, shows excerpts of the latest SQLAuthority posts and has a new SQL tips section.
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008
Notes from the July 19, 2008 Ahmedabad SQL Server User Group meeting, where I presented SQL Server Best Practices and enjoyed a lively discussion.
SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting
I will speak on SQL Server Best Practices at the Ahmedabad SQL Server Usergroup meeting on July 19, 2008. Come meet fellow developers and DBAs.
SQLAuthority News – Thank You to Awarding Author SQL MVP
Thank you for all the wishes on my SQL MVP award. It belongs to every reader here. Send me your ideas and I will publish them with your name on this blog.
SQL SERVER – Deprecated DataType vardecimal
vardecimal, added in SQL Server 2005 SP2, saves space for zero and null values. It is deprecated in SQL Server 2008, where Row Compression covers more datatypes.
SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP
I am very glad to share that Microsoft has given me the Most Valuable Professional Award for SQL Server. Thank you to MVP Lead Abhishek and all my readers.
SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER
Nicholas Paldino shared a neat way to find the Nth Highest Record from a table in SQL Server 2005 using the ranking function ROW_NUMBER. Here is his query.