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 More
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
During the SQL Server Optimization training, I enjoy teaching the Execution Plan. I am always sure that questions related to the estimated cost will be raised by attendees. Following are some common questions related to costs:
SQLAuthority 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 MoreSQLAuthority News – Download Windows Azure Platform Training Kit – December Update
Note : Download Windows Azure Platform Training Kit – December Update by Microsoft I wanted to read some good SQL Azure related to documentation, I tried to do searching online. While searching I landed over Windows Azure Platform Training Kit. This contains lots of SQL Server related content.I downloaded it…
Read MoreSQL SERVER – Initializing a Merge Subscription Without a Snapshot
During recent course of Disaster Recovery and Performance Tuning, I had very interesting conversation with students regarding Initializing a Merge Subscription Without a Snapshot and Initializing a Transactional Subscription Without a Snapshot. After the discussion when we were looking at MSDN pages one thing caught my notice was the note…
Read More