Viewing 15 posts - 4,831 through 4,845 (of 14,953 total)
Then you'll need to do it in two steps.
The first creates the database without any content (beyond whatever's in model).
The second opens a connection to the new database and runs...
- 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
February 24, 2011 at 2:38 pm
Stefan Krzywicki (2/24/2011)
car ad that you click through to get info on the car is still measurably more effective than one that people scan past without noticing.
Quite possibly true, but...
- 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
February 24, 2011 at 2:36 pm
Craig Farrell (2/24/2011)
Education and Experience: Bachelor's degree in Computer Science, IS, or related degree, or equivalent experience. 5-6 years experience working with multiple database...
- 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
February 24, 2011 at 2:04 pm
Stefan Krzywicki (2/24/2011)
GSquared (2/24/2011)
Stefan Krzywicki (2/24/2011)
- 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
February 24, 2011 at 1:56 pm
That sounds more like a team of people than a single job listing.
Develop plans for providing reliable, recoverable, and scalable databases/computing environments to store and integrate company data.
(emphasis added)
All...
- 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
February 24, 2011 at 1:48 pm
Red Gate has one by Grant Fritchey. He knows the subject pretty well, so it's definitely a good place to start.
(There's a link to Red Gate's site at the...
- 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
February 24, 2011 at 1:43 pm
What you're hitting here is the age-old conflict on how best to architect data warehouses. One is "star/snowflake schema", one is "normalized, but not fully". (There are real...
- 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
February 24, 2011 at 1:41 pm
Stefan Krzywicki (2/24/2011)
- 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
February 24, 2011 at 1:23 pm
Are you familiar with the T-SQL version of XQuery?
With that, it's pretty easy to shred this XML.
This should get you started:
DECLARE @XML XML = '<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<wcsxml...
- 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
February 24, 2011 at 1:19 pm
Stefan Krzywicki (2/24/2011)
Brandie Tarvin (2/24/2011)
How do they prove they posted the link if it gets deleted?
I'm sure there's logging software available that will record the site and if data is...
- 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
February 24, 2011 at 1:10 pm
Have you tried simply creating a backup of the database as it's supposed to be when you create a new copy?
You can use the Restore command to give it a...
- 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
February 24, 2011 at 12:50 pm
Brandie Tarvin (2/24/2011)
How do they prove they posted the link if it gets deleted?
I don't know. If I get the chance, I'll ask.
- 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
February 24, 2011 at 12:48 pm
Steve Jones - SSC Editor (2/24/2011)
GSquared (2/24/2011)
Most won't go that far, but business competition is ... well ... competitive. Sun Tzu's Art of War applies.
As I get older, I...
- 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
February 24, 2011 at 12:45 pm
Grant Fritchey (2/24/2011)
Ian Scarlett (2/24/2011)
If I was in the market for one of those, I wouldn't buy from a company that does...
- 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
February 24, 2011 at 12:39 pm
Brandie Tarvin (2/24/2011)
Tom.Thomson (2/23/2011)
I don't see much point in attempting obfuscation if the enemy can see inside the database.
That's a good point, Tom. But is "enemy" a good word choice...
- 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
February 24, 2011 at 7:26 am
Viewing 15 posts - 4,831 through 4,845 (of 14,953 total)