Adventure Works?

I'm curious; what do people here think about AdventureWorks? Do you use it
often when you need to demonstrate something?
BG, SQL Server MVP
www.SolidQualityLearning.com
www.insidetsql.comPlease ignore; wrong newsgroup!
I'm probably getting old...
BG, SQL Server MVP
www.SolidQualityLearning.com
www.insidetsql.com
"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:uChZMmiFGHA.1180@.TK2MSFTNGP09.phx.gbl...
> I'm curious; what do people here think about AdventureWorks? Do you use it
> often when you need to demonstrate something?
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
> www.insidetsql.com
>
>|||How about, for a nickname: Itzik "SQL Geezer" Ben-Gan. I think it has a
nice ring to it.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:u4l1qoiFGHA.1088@.tk2msftngp13.phx.gbl...
> Please ignore; wrong newsgroup!
> I'm probably getting old...
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
> www.insidetsql.com
>
> "Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in
> message news:uChZMmiFGHA.1180@.TK2MSFTNGP09.phx.gbl...
>|||There is no "probably" about it Itzik. It's inevitable<g>.
Andrew J. Kelly SQL MVP
"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:u4l1qoiFGHA.1088@.tk2msftngp13.phx.gbl...
> Please ignore; wrong newsgroup!
> I'm probably getting old...
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
> www.insidetsql.com
>
> "Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in
> message news:uChZMmiFGHA.1180@.TK2MSFTNGP09.phx.gbl...
>|||Well, having Aslan nicknamed "the top geezer", I guess I'm in a good group.
I guess this makes you Mr. Beaver, then, doesn't it? ;)
BG, SQL Server MVP
www.SolidQualityLearning.com
www.insidetsql.com
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OCIhyCjFGHA.516@.TK2MSFTNGP15.phx.gbl...
> How about, for a nickname: Itzik "SQL Geezer" Ben-Gan. I think it has a
> nice ring to it.
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in
> message news:u4l1qoiFGHA.1088@.tk2msftngp13.phx.gbl...
>|||Hmmm, I have only a vague idea of what you're talking about -- I read that
book years ago and haven't made it out to see the movie yet -- so I'll get
back to you on this soon :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:ObDagajFGHA.532@.TK2MSFTNGP15.phx.gbl...
> Well, having Aslan nicknamed "the top geezer", I guess I'm in a good
> group. I guess this makes you Mr. Beaver, then, doesn't it? ;)
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
> www.insidetsql.com
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:OCIhyCjFGHA.516@.TK2MSFTNGP15.phx.gbl...
>|||While I suspect, based on the responses from Adam & Andrew, this was
supposed to be posted to the MVP newsgroups, I'll answer anyway. I find
AdventureWorks (and pubs before it) pretty useless. I only ever look at
them (if I haven't already dropped them) if some Microsoft whitepaper or
MS Press book I'm reading has some example that specifically refers to them.
Any T-SQL code example I give I write from scratch, complete with CREATE
statements & tidy up DROP statements at the end of the script (if I
create any permanent objects). Setting up the schema & data for the
demo helps to get your head fully around the question you're trying to
answer and only takes a few extra minutes. I guess if I was writing a
book (like just about everyone else in the MSSQL world it seems) then
some consistency with the schema & data used in the examples would be
good but 99% of the code examples I give are direct responses to one-off
ad-hoc questions.
BTW Itzik, don't worry about getting old, it happens to all of us.
Anyway, from where I sit you're still one of the sharpest tools in the
shed; I don't think premature senility is setting in just yet.
*mike hodgson*
blog: http://sqlnerd.blogspot.com
PS. C.S. Lewis is underrated. He was the king of allegories - The
Chronicles are timeless (if you'll pardon the play on words).
Itzik Ben-Gan wrote:

>I'm curious; what do people here think about AdventureWorks? Do you use it
>often when you need to demonstrate something?
>
>