![]() it felf the need for different sample databases, which can be used to test these features. We can restore this database on SQL Server 2008 as well.īut, when Microsoft added new features like Reporting Services, Analysis Services, etc. Still, it was great for learning and trying out SQL Server new features. The Northwind was again a sample OLTP database but with little design issues. I’m sure a lot of professionals, especially trainers, do use this sample database till date. When SQL Server 2000 was released, it came up with new sample database, named Northwind. But, there were a lot of shortcomings in this database as it was not designed properly. ![]() We can run the pubs database script and restore it on SQL Server 2008 as well. This smaple database remains there until now. This is very basic OLTP database in order to try SQL Server features and learn SQL Server. Microsoft provided ‘ pubs‘ sample database with SQL Server 6.5. So, the story starts since very beginning. Hence, I decided to write about it today. And, I often come across one more question, which is relevant to AdventureWorks database – that is, Why do we have so many different types of AdventureWorks sample databases such as AdventureWorks, AdventureWorks2008, AdventureWorksLT, etc.? Frankly speaking, I got no correct answer from anyone so far. Yeah! This is very common question among professionals, especially those are learning the SQL Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |