SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Visual Studio Database Tools


Visual Studio Database Tools

Author
Message
SanDroid
SanDroid
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 1046
OCTom (3/17/2011)
Eventhough it's made-up, "object-mapped data files" sounds really cool. Cool


I would have to agree. We call the filled tables in our cached Data library Datasets or well defined tables. I like object-mapped data files so much I am going to start using it. w00t
I would like to say that I am sure someone I worl with will notice this and correct me, but I know they won't. Smooooth
SanDroid
SanDroid
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 1046
Nice question. Thanks!
SanDroid
SanDroid
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 1046
kaspencer (3/17/2011)
However, in the Microsoft library, it states "You can use Microsoft Visual Studio Team Edition for Database Professionals to generate meaningful data for testing. "
Which is correct? Meaningless or Meaningfull?

They both are really. The data would be meaningfull from a testing perspective of dertermining if the database can be populated with the data and data-types that it will be filled with. Also for testing this generated or "FALSE" data can test an application UI to ensure that it dsplays information properly.

However testing a Zip Code and Last Name feild in a database with the values 54321 and QWRTGHOPI is not very meaningfull. You can find documentation that is not sales oriented that will also back this up.

It is always good to rememeber that the M$ marketing department gets to review all product documnetation before release.
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32974 Visits: 18560
Thanks for the question. It makes total sense.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Tom Thomson
Tom Thomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14502 Visits: 12238
Nice question, and nice explanation. Thanks.

Tom

Tom Thomson
Tom Thomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14502 Visits: 12238
OCTom (3/17/2011)
Eventhough it's made-up, "object-mapped data files" sounds really cool. Cool

Actually, in the context of a RDBMS, it sounds appallingly uncool - back to the bad old days of the network or heriarchical database models (which would have been a sensible approach to handling XML in an RDBMS, but someone had to reinvent the wheel, didn't they, and forgot it should have no sharp corners) or, even worse, forward to the long promised but never yet delivered working nontrivial OODBMS.

Tom

paul.goldstraw
paul.goldstraw
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1306 Visits: 1765
I think its interesting to note that the percentage for each answer is currently pretty close, certainly there is no clear leader of the 4. That says to me that many people, myself included, do not come from a Visual Studio background and do not have a great deal of knowledge of how data and databases are approached in that setting. I have appreciated these questions as they have shown me not only how little I know but how much exists in what I have previously perceived to be an environment for those programming in C# or Vb.net rather than in SQL

Thanks for the question
Jamie Thomson
Jamie Thomson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1273 Visits: 188
Tom.Thomson (3/17/2011)
OCTom (3/17/2011)
Eventhough it's made-up, "object-mapped data files" sounds really cool. Cool

Actually, in the context of a RDBMS, it sounds appallingly uncool - back to the bad old days of the network or heriarchical database models (which would have been a sensible approach to handling XML in an RDBMS, but someone had to reinvent the wheel, didn't they, and forgot it should have no sharp corners) or, even worse, forward to the long promised but never yet delivered working nontrivial OODBMS.


Fair point, although "object" doesn't necessarily imply "object oriented". Most stuff in a SQL Server DB can be considered an object because its in [sys].[objects].

Still, we're debating a term which I only made up so that we had 4 multiple choise answers instead of 3 so this is possibly the most pointless debate I have ever contributed to Smile

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Jamie Thomson
Jamie Thomson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1273 Visits: 188
SanDroid (3/17/2011)
kaspencer (3/17/2011)
However, in the Microsoft library, it states "You can use Microsoft Visual Studio Team Edition for Database Professionals to generate meaningful data for testing. "
Which is correct? Meaningless or Meaningfull?

They both are really. The data would be meaningfull from a testing perspective of dertermining if the database can be populated with the data and data-types that it will be filled with. Also for testing this generated or "FALSE" data can test an application UI to ensure that it dsplays information properly.

However testing a Zip Code and Last Name feild in a database with the values 54321 and QWRTGHOPI is not very meaningfull. You can find documentation that is not sales oriented that will also back this up.


Yeah, correct. Thanks SanDroid. When I said "meaningless" I meant that its not real-world data and actually is often nonsensical. When Microsoft say "meaingful" they mean data that means something in respect of the tests. Probably truer to say that both are correct - just depends on the context (as is often the case).

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
UMG Developer
UMG Developer
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2718 Visits: 2204
Thanks for the question, it is good to get an idea of what Visual Studio is capable of.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search