Jeff Pries

Business Intelligence, SQL Server, and other assorted IT miscellany

Month: September 2015

Counting Down to PASS Summit 2015

pass2015_countdownWe’re a little over a month away from the start of PASS Summit 2015 on October 27th, it’s time for planning to begin.   PASS Summit is an annual conference (usually held in Seattle, WA) of over 5,000 data professionals focusing on all things SQL Server.  Unlike many conferences, this is very much a “for the people, by the people” type of conference where practical knowledge is the focus.

As with any large conference, there is a lot of planning to be done to get the most out of attending.  In additional to all the usual travel and accommodation logistics, there is whether or not to attend any pre-conference sessions, which of the over 200 sessions to plan to attend over the 3 days of the event, and which after hours events to attend.

Continue reading

Sample Data — An Intro to Adventure Works

AdventureWorks-Logo_blogSample Data — An Intro to Adventure Works

From time to time, it’s handy to have access to some good, solid sample data.  Now, actually coming up with a robust set of sample data that has no tie back to any proprietary business data can actually be a tricky prospect.  It’s easy to generate a small amount of good data yourself, or a large amount of really random data, but neither of these are very robust.  Fortunately, Microsoft comes to the rescue with their fictional company, Adventure Works, and the Adventure Works Databases.

Microsoft provides the following bio for the Adventure Works company over at Technet:

Adventure Works Cycles, the fictitious company on which the AdventureWorks sample databases are based, is a large, multinational manufacturing company. The company manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. While its base operation is located in Bothell, Washington with 290 employees, several regional sales teams are located throughout their market base.

In 2000, Adventure Works Cycles bought a small manufacturing plant, Importadores Neptuno, located in Mexico. Importadores Neptuno manufactures several critical subcomponents for the Adventure Works Cycles product line. These subcomponents are shipped to the Bothell location for final product assembly. In 2001, Importadores Neptuno, became the sole manufacturer and distributor of the touring bicycle product group.

Coming off a successful fiscal year, Adventure Works Cycles is looking to broaden its market share by targeting their sales to their best customers, extending their product availability through an external Web site, and reducing their cost of sales through lower production costs.

In addition to providing a realistic scenario for the Adventure Works company and a database full of realistic sample data, Microsoft continually updates the Adventure Works database for new versions of SQL Server and makes numerous variations of the databases available to highlight different technologies.

Continue reading

© 2017 Jeff Pries

Theme by Anders NorenUp ↑