Hello my SQL goddeses! (how’s that for shamelessly trying to get your attention!)

Okay, so here’s the scoop in as few a words as I can possibly put them. A small team and I are building a new website for gardeners — we are in the final throws. I put together the original data model, but now I’m getting feedback from several different directions that it should be different than what I’ve modeled. And I’m perfectly fine with that. I would consider myself a junior developer that has been around — and managed many, many small, medium, and large software development efforts. I’ve always had much respect for project managers who actually know how to code — so over the past 12 months, I’ve taken it up. PROBLEM: I have noooo idea who knows the most about what I’m going to encounter days, weeks, months, years from now. So, for right or wrong, I’m going to pour my heart out to you two lovely ladies who have a bunch of followers – and trust that if you can get so many people to follow you to the ends of the Earth, that maybe I could trust you as well. So, to that end, let me try to convey much information, in a little amount of space and see if I can appeal to your sense of duty, your love of country, for all the babies in the world, to help end world hunger, for the love of all that is holy, hmmmm, what else… Oh well, if those causes aren’t enough – I’m scrooged! (I have a 10 year old daughter so I have to talk in that kind of language).

Okay, here goes: C#, .NET, MVC, SQL Server 2008R2, JQuery, a little JSON, 25% LINQ, 70% stored procs, 5% views, what I would call a small database (largest table – transaction_detail ~ million rows, customer table ~ 40,000, plant table ~ 6,000 rows, etc.), around 30 real tables with maybe another 10 used for importing flat data files coming from external systems before merging, no indexes yet because we’re just getting the first version of the site up so I can run some traces, new data merged in from multiple data sources each night, a fair amount of BIDS because I’m bringing in flat files from external sources, 3rd party hosting company for both web and database, Microsoft Azure cloud services for image storage, and more (of course). Sounds fun, huh! Probably won’t do it here, but I’m willing to share just about anything that would help you – just not here where everyone is watching… I don’t think the CIA or FBI are after my Gardening Plant Database, but you can never be too careful…it’s pretty good shi..stuff. There is a lot the government could learn from it, I fear!!! Sometimes I “feel” them listening when I’m on my cell phone. I think they might have phone taps on me…so be careful – I’m sorry for bringing you into my covert-ness?!
[Since I know sarcasm and comedy don't come through well online, I better go ahead and state the obvious that I'm tooootalllly kidding. Wait a minute, that assumes there was something in there that made you smile~~]

Okay, last paragraph, I promise — and I’ll try one last clever trick to try and suck you in to my world of problems…..I mean, opportunities! I totally mean, opportunities.

select top 6 q.question_id, q.question_description, count(*)
from questions_and_replies_kurt_would_love_help_with q
left join questions_and_replies_kurt_would_love_help_with r
on q.question_id = r.guid_of_question_id
join importance_scale is
on q.importance_scale_id = is.importance_scale_id
join status s
on q.status_id = s.status_id
join x_question_picture xqp –some questions might have one or more pictures associated with them…I like to show things in pictures.
on q.question_reply_id = xqp.question_reply_id
join picture p
on xqp.picture_id = p.picture_id
where s.status_description = ”Open, Unanswered AND Kurt might be smart enough to understand the answer.” (obviously wouldn’t really do a where with a description field, but it worked bette ee!)
and q.question_id is not null and r.guid_of_question_id is nul
and is.level = ‘EXTREMELY CRITICAL…LIFE ALTERING’
group by r.question_id, q.question_description
order by count(*) desc

[results] [Messages]
—————————————————————————————————————————————————————————————–
question_id question_description no_replies
—————————————————————————————————————————————————————————————–
1 AD0F77AA-2712-4E30-A3A7-002D569C4D9E Could you please look at my data model and give me harsh feedback? 12
2 47A0A2CD-4C85-42F6-871F-003281BFCE4D The age old question – more normalized, de-normalized for speed? 10
3 CE5094F3-3E20-4CD7-8D2D-0037A6705C1D Use of LINQ versus stored procs in MVC 8
4 BCF3CAB1-8A7C-4722-B805-003F6C50D4DD Best practices on bringing in data through BIDS 4
5 C628674C-974D-469A-87D6-0046E0FBBD97 Tools. What are the absolute best tools of the trade for experts? 0
6 8BC5B60D-7933-4FC0-98EA-FFCBB6564952 There are a couple of extremely important sprocs i’d love feedbac on 0

(6 row(s) affected)

These probably aren’t exactly the top 5 questions, but i’m getting tired.

Okay, please don’t take any of that serious. I don’t really model like that…I was trying to be cute.

Your truly,
Kurt Dicus
Molbaks
c. (425) 408-3250
http://www.molbaks.com
[this is not the site we're building. If you're willing to give me some guidance, I would love to share the site with you.]

In September before PASS (24 hours of PASS) you did a topic on CTE’s and had great examples. I was hoping I could get the .sql files from you or the slide deck. I looked all over and can’t seem to find it. Can you either tell me where to find them or just e-mail them to me?

Do either of you do consulting in puget sound area? I am looking for SSIS architect/developer and am in immediate need.