Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Visual Studio Database Tools Expand / Collapse
Author
Message
Posted Thursday, March 17, 2011 8:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
OCTom (3/17/2011)
Eventhough it's made-up, "object-mapped data files" sounds really 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.
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.
Post #1079671
Posted Thursday, March 17, 2011 8:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Nice question. Thanks!
Post #1079672
Posted Thursday, March 17, 2011 8:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
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.
Post #1079677
Posted Thursday, March 17, 2011 11:43 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 17,980, Visits: 15,983
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
Post #1079918
Posted Thursday, March 17, 2011 12:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 7,874, Visits: 9,613
Nice question, and nice explanation. Thanks.

Tom
Post #1079967
Posted Thursday, March 17, 2011 12:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 7,874, Visits: 9,613
OCTom (3/17/2011)
Eventhough it's made-up, "object-mapped data files" sounds really 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
Post #1079969
Posted Friday, March 18, 2011 6:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 1,139, Visits: 1,527
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
Post #1080321
Posted Friday, March 18, 2011 6:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
Tom.Thomson (3/17/2011)
OCTom (3/17/2011)
Eventhough it's made-up, "object-mapped data files" sounds really 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 :)


Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #1080327
Posted Friday, March 18, 2011 6:57 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, 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
Post #1080332
Posted Friday, March 18, 2011 10:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question, it is good to get an idea of what Visual Studio is capable of.
Post #1080512
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse