Are the posted questions getting worse?
-
Koen Verbeeck (3/3/2011)
GSquared (3/3/2011)
... but we're still in 2005, and in Standard Edition at that.Ouch... 🙂
heh, we just finished *upgrading* all our satellite offices to that. viva la 2000! (not)
---------------------------------------------------------
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."
-
have a feeling I already know the answer to this, but what the heck, I'll ask it anyway...Can I copy tasks from one SSIS package and paste into another?
---------------------------------------------------------
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."
-
GSquared (3/3/2011)
Koen Verbeeck (3/3/2011)
GSquared (3/3/2011)
If anyone's interested in what I've been working on the last six months or so, last night (late) we launched http://www.VisitOrlando.com.While you won't see my ETL and database work on the site directly, I am curious about reactions to it.
Edit: Link changed to bypass odd link handling by forum.
Nice website, but in my opinion, it is a little weird that the changing pics are much wider than the actual content of the site (at least in my browser, IE9).
Just a small sidenote, the site is really beautiful.
What did you do for the ETL? Gather clickstream data?
I'll pass along the comment to the design people. The picture layout at the top is by design, but feedback on it will be appreciated.
There are five databases worth of information being fed into the site, including two different CRMs, one CMS, and some custom data specific to the business. Two of the databases are in Florida, three are in a different state. And that doesn't include the data stream for the images showing on the site, which is also managed as part of the ETL process, even though they're not stored in a database at all, and which also has to move them between multiple servers, rename all the files based on an algorithm (simple one, thankfully), and keep them synchronized with metadata in three databases.
The tricky part was completely reloading the database the site feeds from, including clearing and reloading multiple tables, without losing content during the load. Snapshots would have made that easy, and Merge would have made it unnecessary, but we're still in 2005, and in Standard Edition at that.
I really like how fast the page loads and that there appears to be no Flash.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
Tom.Thomson (3/3/2011)
GSquared (3/3/2011)
If anyone's interested in what I've been working on the last six months or so, last night (late) we launched http://www.VisitOrlando.com.While you won't see my ETL and database work on the site directly, I am curious about reactions to it.
Edit: Link changed to bypass odd link handling by forum.
Looks as if it's currently down - browsing to http://www.VisitOrlando.com ends up with some sort of 500 error from the Bluefrog Interactive site (so I guess VisitOrlando.com is intended to fit onto a very small screen - eg a mobile phone - as that's what Bluefrog was set up to do). But using DNS and ARIN Whois suggests that http://www.VisitOrlando.com belongs to an outfit called Por Motivos de Viaje in Caracas, Venezuela (which sounds like a second hands sales advertising company) but that seems improbable.
Edit: it's back up now. It's very odd - I get two different websites depending which browser i use.
Mozilla gives me a site designed for very small screen; it looks pretty nice, and has no picture size issues. However there are some 404s, and some bits that look like multiple entries for the same thing, (go through cultural for March to either of the Bach Festival entries and you'll find (i) that the "website" links are all broken and (ii) that there are more entries on each day that there are performances that day).
IE8 gives me a site which looks as if most of it was designed to be 990 px wide but with some weird image sizing that means you need something well over 1200 px width to display it cleanly, and also a lot of depth to avoid excessive scrolling. I don't like this version of the site at all, it's too loud and busy and I certainly wouldn't want to use it on a laptop or on a 1280 X 720 HDTV screen (or anything smaller), maybe it would look better on a 1920 X 1080 HDTV screen (I don't have one here so haven't tried it). This version of the site has unbroken links down at the bottom of the events-cultural chain (they point direct to the external website instead of trying to pull it through Bluefrog) and only one entry for for each performance.
I'm not sure what you mean when you mention "Bluefrog". I searched for it online, and got a New York area ISP, an anti-spam company, a direct marketing agency for not-for-profit companies, a blues band, and numerous other entries, none of which make sense in this context.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
Tom.Thomson (3/3/2011)
Brandie Tarvin (3/2/2011)
LutzM (3/2/2011)
Craig Farrell (3/2/2011)
...By Jove! You've forgotten about taking care of your SOX while you're at it! In dealing with a rainforest, you'll catch some nasty things if you don't keep your SOX clean and dry.
Actually, that's part of testing the desaster recovery scenario: run through the rainforest not SOX-compliant and try to recover. 😀
However, it needs to be documented in an ISO compliant format where the SOX actually have to be. Otherwise you'd end up with a situation Jeff described earlier (a mouth full of SOX 😀 ).
But this might actually be a good version of an intrusion prevention system. At least for this specific point of entry. 😉
And now we know why you have to have SOX everywhere: it's just there to protect you!
And HIPAAs are previously undiscovered rainforest predators that leap out of the shadows when you least expect it, deliberately hampering all attempts to keep your SOX clean and dry. They're also very talented when it comes to tying ISO formats into complicated Gordian Knots.
I'm confused, and will now have to revise my views on the impact of SQLServerCentral on the ecology of the Amazon basin. I hadn't realised that avatars of Jason were rainforest predators until I saw Brandie's message.
I'm confused now. HIPAA = HIPPO != Rhino 😎
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 -
CirquedeSQLeil (3/3/2011)
I'm confused now. HIPAA = HIPPO != Rhino 😎SOM! D'OH! And I run my mouth about pet peeves...:hehe::-D
---------------------------------------------------------
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."
-
CirquedeSQLeil (3/3/2011)
...I'm confused now. HIPAA = HIPPO != Rhino 😎
Hoola-HIPAA-Hippo as requested 🙂
-
LutzM (3/3/2011)
CirquedeSQLeil (3/3/2011)
...I'm confused now. HIPAA = HIPPO != Rhino 😎
Hoola-HIPAA-Hippo as requested 🙂
Hey the hippo is back from the TITD. There should be plenty of room there now.
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 -
GSquared (3/3/2011)
Tom.Thomson (3/3/2011)
GSquared (3/3/2011)
If anyone's interested in what I've been working on the last six months or so, last night (late) we launched http://www.VisitOrlando.com.While you won't see my ETL and database work on the site directly, I am curious about reactions to it.
Edit: Link changed to bypass odd link handling by forum.
Looks as if it's currently down - browsing to http://www.VisitOrlando.com ends up with some sort of 500 error from the Bluefrog Interactive site (so I guess VisitOrlando.com is intended to fit onto a very small screen - eg a mobile phone - as that's what Bluefrog was set up to do). But using DNS and ARIN Whois suggests that http://www.VisitOrlando.com belongs to an outfit called Por Motivos de Viaje in Caracas, Venezuela (which sounds like a second hands sales advertising company) but that seems improbable.
Interesting.
There is a mobile version of it, but the main site isn't designed for a small screen. Nor is it owned by a company in Venezuela. I guess it's possible some DNS propagation issue is in the way of you getting to it currently, since the site didn't exist till late last night. But that's outside my field of expertise, and I'm more than slightly just guessing.
I edited my last post before seeing your reponse, there are some comments about each version of the site there now.
The reason the mobile site was broken is that it redirects to the Bluefrog site, which was down (and is now back up).
It's pretty weird, I think someone has some bad code deciding whether a visitor is on a mobile or not - if I go to the site with Mozilla by specifying the URL (http://www.VisitOrlando.com) I get the mobile site, if instead I specify the server IP address (http://64.39.29.98) I get the big screen site. If I use IE8 I get the big screen site either way.
I did some additional digging on the ARIN information (because I like solving puzzles like that). The Venezuelan company was apparently being hosted by one of Cymitar, Rackspace, or Serverbeach (the IP adress originally assigned to Cymitar when it was an ISP; Rackspace was spun off from Cymitar to handle its hosting business; Serverbeach was spun off from Rackspace in 2003 to handle its low end hosting, but is now independent) - probably Rackspace given that http://www.Cymitar.net, http://www.Cymitar.com, and ns.cymitar.net all map to rackspace servers; the ARIN information on the IP address was last updated (by Cymitar) in 2003, except for a note added by ARIN to the contact point record for the IP to say it has been trying unsuccessfully to contact Cymitar since August 2010; so the ARIN information on the IP is out of date (and VisitOrlando maybe ought to be chasing whoever is hosting the bigscreen site to update the ARIN information).
Tom
-
GSquared (3/3/2011)
I'm not sure what you mean when you mention "Bluefrog". I searched for it online, and got a New York area ISP, an anti-spam company, a direct marketing agency for not-for-profit companies, a blues band, and numerous other entries, none of which make sense in this context.Bluefrog Interactive is (or maybe was - I could easily be out of date, for all I know Bluefrog Interactive is defunct, it must be a few years since last I heard of it) the company which owns (or owned) mobiManage, the company which owns the server to which the mobile version of the VisitOrlando redirects.
Tom
-
CirquedeSQLeil (3/3/2011)
Tom.Thomson (3/3/2011)
Brandie Tarvin (3/2/2011)
LutzM (3/2/2011)
Craig Farrell (3/2/2011)
...By Jove! You've forgotten about taking care of your SOX while you're at it! In dealing with a rainforest, you'll catch some nasty things if you don't keep your SOX clean and dry.
Actually, that's part of testing the desaster recovery scenario: run through the rainforest not SOX-compliant and try to recover. 😀
However, it needs to be documented in an ISO compliant format where the SOX actually have to be. Otherwise you'd end up with a situation Jeff described earlier (a mouth full of SOX 😀 ).
But this might actually be a good version of an intrusion prevention system. At least for this specific point of entry. 😉
And now we know why you have to have SOX everywhere: it's just there to protect you!
And HIPAAs are previously undiscovered rainforest predators that leap out of the shadows when you least expect it, deliberately hampering all attempts to keep your SOX clean and dry. They're also very talented when it comes to tying ISO formats into complicated Gordian Knots.
I'm confused, and will now have to revise my views on the impact of SQLServerCentral on the ecology of the Amazon basin. I hadn't realised that avatars of Jason were rainforest predators until I saw Brandie's message.
I'm confused now. HIPAA = HIPPO != Rhino 😎
That's my memory failure for you, maybe :blush: senility setting in. I remembered the avatar looked big and grey, like a hippo or an elephant or a rhino, and didn't have a trunk - I'd forgotten the horns.
Tom
-
Another sad case of copyright infringement (or plagiarism, I can't tell them apart):
http://www.sqlservercentral.com/Forums/Topic1072353-2912-1.aspx#bm1072920
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (3/3/2011)
Another sad case of copyright infringement (or plagiarism, I can't tell them apart):http://www.sqlservercentral.com/Forums/Topic1072353-2912-1.aspx#bm1072920
Plagiarism is when you're pretending the work is your own and not giving proper credit.
Copyright infringement is when you're reprinting the work without permission.
It is possible to do both at the same time, but plagiarism is the more serious charge.
-
Brandie Tarvin (3/4/2011)
Koen Verbeeck (3/3/2011)
Another sad case of copyright infringement (or plagiarism, I can't tell them apart):http://www.sqlservercentral.com/Forums/Topic1072353-2912-1.aspx#bm1072920
Plagiarism is when you're pretending the work is your own and not giving proper credit.
Copyright infringement is when you're reprinting the work without permission.
It is possible to do both at the same time, but plagiarism is the more serious charge.
Well, than it is obvious plagiarism in this case.
(small grammar question, in the sentence above, should it be than or then?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (3/4/2011)
Brandie Tarvin (3/4/2011)
Koen Verbeeck (3/3/2011)
Another sad case of copyright infringement (or plagiarism, I can't tell them apart):http://www.sqlservercentral.com/Forums/Topic1072353-2912-1.aspx#bm1072920
Plagiarism is when you're pretending the work is your own and not giving proper credit.
Copyright infringement is when you're reprinting the work without permission.
It is possible to do both at the same time, but plagiarism is the more serious charge.
Well, than it is obvious plagiarism in this case.
(small grammar question, in the sentence above, should it be than or then?)
"than" is a comparison word. "then" means "after" or "in addition to" or something that occurs second, third, etc.
Because you are implicitly comparing plagiarism to copyright infringment, you are using the correct word.
Viewing 15 posts - 24,436 through 24,450 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply