Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Less and Less Visual


Less and Less Visual

Author
Message
Phil Factor
Phil Factor
SSC Eights!
SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)

Group: General Forum Members
Points: 929 Visits: 2953
Comments posted to this topic are about the item Less and Less Visual


Best wishes,

Phil Factor
Simple Talk
scoan
scoan
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 68
Phil Factor. Great name for a dba.
Yet Another DBA
Yet Another DBA
SSC Veteran
SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)

Group: General Forum Members
Points: 253 Visits: 1222
I dont actually believe that many understand ERDs. Would like to see a survey on what people do know, and the extent.

Last few companies I have worked at none of the DBAs or developers understood what a ERD was. Blank expressions have been the norm. Suggest it as a method of resolving a dispute on the suggested relationships of the schema and they have often not understood or refused it as the "code knowns"; yeah then why the discussion in the first place?

My issue with the diagramming tools that MS provide is that they have such basic notation.
P Jones
P Jones
Right there with Babe
Right there with Babe (772 reputation)Right there with Babe (772 reputation)Right there with Babe (772 reputation)Right there with Babe (772 reputation)Right there with Babe (772 reputation)Right there with Babe (772 reputation)Right there with Babe (772 reputation)Right there with Babe (772 reputation)

Group: General Forum Members
Points: 772 Visits: 1510
Visio is my favourite tool for documentation and design (and the one available when you work in a restricted Microsoft shop!).
I reverse engineer my databases into Visio Premium to give visual documentation easily.
I started with Visio just at the point where Microsoft bought it and it was a better product in those days, because you could both reverse engineer from SQL Server AND forward engineer your design, but the latter option was removed as Microsoft "developed" the product.
Phil Factor
Phil Factor
SSC Eights!
SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)SSC Eights! (929 reputation)

Group: General Forum Members
Points: 929 Visits: 2953
@Yet Another DBA
For years, I did all my work in ErWin, which is a good ERD tool, and I very seldom used SQL code for designing databases. Mind you, I was engaged in doing high-level design at the time and the mapping of corporate data, and only did the first cut of the physical model from the ERD, but it has given me a great respect for the power of the ERD. I really would recommend diagramming the database model for as long as possible in the course of development. You can always use the diagrams in the subsequent documentation.


Best wishes,

Phil Factor
Simple Talk
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18623 Visits: 13249
P Jones (6/26/2014)
Visio is my favourite tool for documentation and design (and the one available when you work in a restricted Microsoft shop!).
I reverse engineer my databases into Visio Premium to give visual documentation easily.
I started with Visio just at the point where Microsoft bought it and it was a better product in those days, because you could both reverse engineer from SQL Server AND forward engineer your design, but the latter option was removed as Microsoft "developed" the product.


+1
I used Visio from time to time, but they took out the best features in later editions.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Gary Varga
Gary Varga
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10159 Visits: 6345
There does seem to be a loss in the community (generalising here so many of you will be exceptions!!!) of using visual tools for anything but documentation. I agree that scripting is, or at least can be, very powerful and shouldn't be overlooked but there are proven psychological reasons why visual representation is a better form of communication over text. Yes, you can argue that text is less likely to be prone to misinterpretation and ambiguity but I do think that we have lost some tools and that is rarely a good thing. In the 80s and 90s there was a lot of effort to bring the power of visual representation to the IT professionals. Sadly, this appears to be discarded now.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Ian Massi
Ian Massi
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2103 Visits: 2178
Does a whiteboard and a smartphone count as a tool? I agree that some more visual tools would help us be more effective. People who have a great mind for the abstract can "see" the data and relationships more easily than others, especially with experience. Graphical tools allow this meta data to be stored and shared so it doesn't have to only take up space in your working memory and who doesn't want to have more memory available for processing?
cmgreenjr
cmgreenjr
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 6
Several have commented that the current trend seems to be toward text with the feeling that text is more accurate. I think that the opposite is true, text has become much less accurate in every dimension of communication and is no more accurate in database descriptions. Much has been written about the rise of the "texting" vocabulary in all aspects of communications and it coincides with the general degradation of the written word in society. With mounting evidence that text is less and less precise how can it be a more precise representation of a concept than a visual representation that is prima facie accurate and not open to the interpretation that text is? I have been waiting years for good and affordable graphical tools to use in engineering and reverse engineering databases and applications as both time saving devices and as higher level abstract representations of the code and just when I thought they were arriving they seem to be going away. This is a sorry state of affairs for current work and advancement of the discipline.Sad
Gary Varga
Gary Varga
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10159 Visits: 6345
charles.green (6/26/2014)
Several have commented that the current trend seems to be toward text with the feeling that text is more accurate. I think that the opposite is true, text has become much less accurate in every dimension of communication and is no more accurate in database descriptions. Much has been written about the rise of the "texting" vocabulary in all aspects of communications and it coincides with the general degradation of the written word in society. With mounting evidence that text is less and less precise how can it be a more precise representation of a concept than a visual representation that is prima facie accurate and not open to the interpretation that text is? I have been waiting years for good and affordable graphical tools to use in engineering and reverse engineering databases and applications as both time saving devices and as higher level abstract representations of the code and just when I thought they were arriving they seem to be going away. This is a sorry state of affairs for current work and advancement of the discipline.Sad


I agree with most of what Charles says here but, at least for my part, executable text is verifiable whereas a non-executable graphical representation is not. A document was certainly not what I had in mind.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
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