Month: August 2013

So You Want to Learn SQL… Session 4

Published by sbalkum on August 29, 2013

Homework Answers Generate a list of products that have a bill of material, stating each subcomponent and the quantity used. You should use the Production.BillOfMaterials…

So You Want to Learn SQL… Session 3

Published by sbalkum on August 22, 2013

Homework Answers List AOV per credit card type and country region code for July, 2008. Drop rows with statistically irrelevant results, i.e. less than 10.…

Moving the sessionState connection string to a separate config file

Published by sbalkum on August 19, 2013

Typically, the sessionState for SQL is specified in the web.config something like this: <sessionState mode=”SQLServer” sqlConnectionString=”Data Source=dbserver;User Id=username;Password=password” cookieless=”false” timeout=”20″/> However, to make switching connection strings between…

Current State of Azure’s Preview AutoScale

Published by sbalkum on August 17, 2013

Today at the Austin Code Camp, Aaron Murray and I gave a presentation on our experience with Azure’s AutoScale which is in preview. Take a…

So You Want to Learn SQL… Session 2

Published by sbalkum on August 15, 2013

Review Homework Answer For orders in July of 2008, list the territory IDs, average total sale and number of sales per territory ID, sorted by…