SQL Server has so many enhancements and features that quite often I feel like playing with various features and try out new things. I often come across situation where I want to try something new but I do not have sample data to experiment with. Also just like any sane developer I do not try any of my new experiments on production server. Additionally, when it is about new version of the SQL Server, there are cases when there is no relevant sample data even available on development server. In this kind of scenario sample database can be very much handy. Additionally, in many SQL Books and online blogs and articles there are scripts written by using AdventureWork database. The often receive request that where people can get sample database as well how to restore sample database.
In this sixty seconds video we have discussed the same. You can get various resources used in this video from http://bit.ly/adw2012.
More on Errors:
SQL SERVER – Install Samples Database Adventure Works for SQL Server 2012
SQL SERVER – 2012 – All Download Links in Single Page – SQL Server 2012
SQLAuthority News – SQL Server 2012 – Microsoft Learning Training and Certification
SQLAuthority News – Download Microsoft SQL Server 2012 RTM Now
I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.
If we like your idea we promise to share with you educational material.
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, Video