MCJ - The Missing Link

Question

MCJ - The Missing Link

Viewing 15 posts - 241 through 255 (of 312 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Lynn Pettis (4/29/2010)
Plus, considering some people change thier screen names on a regular basis, attributing the code to '.' may not mean anything unless you happen to know who that is from association here on SSC.

Attributing a script to '.' would be funny. I think Bob would be ok with that.:-D

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

CirquedeSQLeil (4/29/2010)
Lynn Pettis (4/29/2010)
Plus, considering some people change thier screen names on a regular basis, attributing the code to '.' may not mean anything unless you happen to know who that is from association here on SSC.
Attributing a script to '.' would be funny. I think Bob would be ok with that.:-D

I'm going to go looking for a script I can use from him, just to do that. Nice one, Lynn! :hehe:

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

I like http://www.sharepointhosting.com/sharepoint-features.html for the sharepoint site. I don't see a need for anything more than the basic plan (500 Mb) @ 19.95/mo.

Compared to http://www.fpweb.net/sharepoint-hosting/comparePlans.asp which is $29 / mo but the base plan is for 1GB.

For 1 GB the price is the same at both sites (excluding the possible discounts). Both offer just about the same package and both have everything we would need. I can't see any additional features that we would need.

The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and checkout. Besides, they are hosted in Colorado, which may give somebody a chance to visit the site and maybe cut a better deal.

edit: Fixed the second link

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

WayneS SSC Guru Points: 95460 More actions · Answer 4

CirquedeSQLeil (4/29/2010)
The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and checkout. Besides, they are hosted in Colorado, which may give somebody a chance to visit the site and maybe cut a better deal.

Now that sounds like a pretty useful feature.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

WayneS (4/29/2010)
CirquedeSQLeil (4/29/2010)
The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and checkout. Besides, they are hosted in Colorado, which may give somebody a chance to visit the site and maybe cut a better deal.
Now that sounds like a pretty useful feature.

Hopefully we can get some input from others soon on the topic.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Luke L SSC-Dedicated Points: 35547 More actions · Answer 6

CirquedeSQLeil (4/29/2010)
I like http://www.sharepointhosting.com/sharepoint-features.html for the sharepoint site. I don't see a need for anything more than the basic plan (500 Mb) @ 19.95/mo.
Compared to http://www.fpweb.net/sharepoint-hosting/comparePlans.asp which is $29 / mo but the base plan is for 1GB.
For 1 GB the price is the same at both sites (excluding the possible discounts). Both offer just about the same package and both have everything we would need. I can't see any additional features that we would need.
The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and checkout. Besides, they are hosted in Colorado, which may give somebody a chance to visit the site and maybe cut a better deal.
edit: Fixed the second link

The sharepointhosting.com site seems to have what we'd need, I'm somewhat confused by the quote at the bottom of the page.

All Bronze and above shared plans include full Microsoft licensing compliance

Does that mean we would need to purchase a share point license or am I just reading too much into it.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Luke L (4/30/2010)
CirquedeSQLeil (4/29/2010)
I like http://www.sharepointhosting.com/sharepoint-features.html for the sharepoint site. I don't see a need for anything more than the basic plan (500 Mb) @ 19.95/mo.
Compared to http://www.fpweb.net/sharepoint-hosting/comparePlans.asp which is $29 / mo but the base plan is for 1GB.
For 1 GB the price is the same at both sites (excluding the possible discounts). Both offer just about the same package and both have everything we would need. I can't see any additional features that we would need.
The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and checkout. Besides, they are hosted in Colorado, which may give somebody a chance to visit the site and maybe cut a better deal.
edit: Fixed the second link
The sharepointhosting.com site seems to have what we'd need, I'm somewhat confused by the quote at the bottom of the page.
All Bronze and above shared plans include full Microsoft licensing compliance
Does that mean we would need to purchase a share point license or am I just reading too much into it.
-Luke.

What are the doing for the basic plan if only the bronze and above are fully MS Compliant?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 8

I dfon't think we need licenses for each person. That's why we'd go hosted.

Don't fret about $10-20 a month difference. Pick the best service/features.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Steve Jones - Editor (4/30/2010)
I dfon't think we need licenses for each person. That's why we'd go hosted.
Don't fret about $10-20 a month difference. Pick the best service/features.

Sorry, didn't get a chance to review the sites and plans last night. I WILL look at them tonight and offer my recommendations. One question, who, or how, are we going to make the final decision?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I dfon't think we need licenses for each person. That's why we'd go hosted.
Don't fret about $10-20 a month difference. Pick the best service/features.
Sorry, didn't get a chance to review the sites and plans last night. I WILL look at them tonight and offer my recommendations. One question, who, or how, are we going to make the final decision?

Consensus acceptance.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Me thinks that questions like today's QotD should be on the SSCJ core exam.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Agreed

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

WayneS SSC Guru Points: 95460 More actions · Answer 13

Lynn Pettis (4/30/2010)
Me thinks that questions like today's QotD should be on the SSCJ core exam.

I'll be curious if you think the QOD's I have coming up (on indexes... only advance hint) will be worthy of it.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 14

CirquedeSQLeil (4/30/2010)
Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I dfon't think we need licenses for each person. That's why we'd go hosted.
Don't fret about $10-20 a month difference. Pick the best service/features.
Sorry, didn't get a chance to review the sites and plans last night. I WILL look at them tonight and offer my recommendations. One question, who, or how, are we going to make the final decision?
Consensus acceptance.

I'll let all know right now--- I haven't worked with SP much, so I will NOT be giving an opinion on what we should utilize. The only thing that stands out to me in line with any kind of preference is that the first one had the ability to post things into SP via email... to me, that is an advantage.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 15

Steve Jones - Editor (4/29/2010)
I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code for others and use it. That could be seen as an issue here. I think in terms of defining this, you might need to more explicitly use something along the lines of giving credit and having permission.

There IS a difference between copying a copyrighted article and, by either by omission or otherwise, claiming it as your own and using a "borrowed" snippet as a part of the code. If there wasn't, none of us would ever be able to write any code because there are very few new ideas that haven't either already been published in someone's book or on a copyrighted forum somewhere.

Understand such things should be a part of the "core module" that all tracks of "MCJ" training and testing should include.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)