This post is a response to one of the most asked questions where to get Sample Database for SQL Server 2008. The name of the new sample database is AdventureWorks.
SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification
Remote BLOB Store Provider Library Implementation Specification logo-sql08.gif SQL Server Technical Article Writers: Kevin Farlee, Pradeep Madhavarapu Technical Reviewer: Pradeep Madhavarapu, Michael Warmington Published: August 2008 Remote BLOB Store (RBS) is designed to move the storage of large binary data (BLOBs) from database servers to commodity storage solutions. With RBS,…
Read MoreSQLAuthority News – Community Tech Days – Jan 30, 2010 – Event Announcement
Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills…
Read MoreSQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010
Microsoft has organized an Open Day for all MVP the South Asia MVP. The MVP Open Day is a three day invitation-only event that is hosted at MSIDC. The event will feature a roster of keynotes and deep dive technical sessions delivered by experts from the product group. Microsoft India Development…
Read MoreSQL SERVER – SSMS Query Command(s) completed successfully without ANY Results
Yesterday night, I received a phone call from one of my friends with whom I used to work in USA. I was very pleased to receive this call from my old friend after 2 years, but the situation was not good on his side. He said that whatever query he…
Read MoreSQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action
I just received an email from one of the readers asking for help with error he encountered while attempting to run DMV. Msg 297, Level 16, State 1, Line 1 The user does not have permission to perform this action. Fix/Solution/Workaround: The above error is usually generated when the user…
Read MoreSQL SERVER – Get Server Version and Additional Info
It is quite common to get the SQL Server version details from following query. SELECT @@VERSION VersionInfo GO Recently I have been using following SP to get version details as it also provides me few more information about the server where the SQL Server is installed. EXEC xp_msver GO Watch…
Read More