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


When Windows don’t provide illumination


When Windows don’t provide illumination

Author
Message
Jim P.
Jim P.
Say Hey Kid
Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)

Group: General Forum Members
Points: 681 Visits: 2215
JJ B (6/10/2013)
I do not understand the point of this Editorial. I do not know anything about the the GUI tools in SSMS for creating tables, but I am familiar with both MS Access and ERwin. For SQL Server databases, I always model database changes in the ERwin file first. I then use ERwin to generate the SQL code which I run in SSMS when appropriate.


I used the MS Access GUI tools early on. I eventually found they left me with as bad a design as the designer (me) could come up with.

As far as ERWin, I've never had a chance to use it. And many others haven't either. In many companies the DBA is an accidental one with the job thrown at a sysadmin or a developer that had the job thrown at them. The add-on tools are too expensive or not known about. So the DBAs only have the SSMS tools to use.

Then there is a generation of us that didn't have GUI's to really work with. I started in SQL 7 in the late 90's. You had to code by hand no matter what to get to the extended stuff to start with.

So you are now sitting here and saying that you don't think it is valuable to know how to do it by hand just lacks weight with me. There should always be the ability to do it by hand. Without the basics, the rest is shifting sands.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
JJ B
JJ B
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 2846
So you are now sitting here and saying that you don't think it is valuable to know how to do it by hand...

That's not what I'm saying. What I'm saying is that 1) it *is* very valuable to have the GUIs despite what the post said, and 2) that the good GUIs help beginners learn "how to do it by hand" correctly. I'm also saying that once you know how to do something by hand, always doing it by hand is generally a waste of time and unnecessary point of possible errors if a GUI is available.

I hear you that not everyone is lucky enough to be able to work with a good GUI tool. That's too bad. I can't imagine wanting to work in such a place. I believe in having the tools available to do a job efficiently. Too bad ERwin is ridiculously expensive.

Jim, thanks for showing how my previous post was not clear. I hope this post clarifies my thoughts.
Mauve
Mauve
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1246 Visits: 2049
Another case where the SSMS GUI failed...
Bug in SSMS where page level locking is disabled.
http://www.interworks.com/blogs/bbickell/2010/05/10/sql-server-index-indexname-table-tablename-cannot-be-reorganized-because-p

Whereas, if the SQL DDL command to create the index was coded by hand, the coder would know exactly what they were doing.

And when the object was reverse-engineered, so that it can be properly checked into the source code control system, was this error by SSMS going to be detected? I doubt it.


(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Phil Factor
Phil Factor
Right there with Babe
Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)

Group: General Forum Members
Points: 741 Visits: 2937
I do not understand the point of this Editorial. I do not know anything about the the GUI tools in SSMS for creating tables, but I am familiar with both MS Access and ERwin.

@JJ B If you do not know anything about the the GUI tools in SSMS for creating tables, then you would certainly wonder why I'm warning of the dangers of relying on them rather than learning how to cut your own code. What I was trying to say was that we shouldn't rely on the GUI tools. I'm not advocating taking away all the tools that help with database design, just making the point that we should also support the use of code to design databases by providing good documentation and examples.

I'm pleased that you're happy with ERwin. I used it for many years, but I never regretted learning how to cut tables in code as well. For a start, I can use the latest features of SQL Server without having to wait for the ERwin upgrade!


Best wishes,

Phil Factor
Simple Talk
JJ B
JJ B
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 2846
Phil Factor: Thank you for your reply. That makes sense. And concerning waiting for new SQL Server features to get into ERwin: you have me there!
Colin Daley
Colin Daley
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 68
Hello Phil,

Motivated by the railroad style diagrams article at Simple Talk, I wrote a program to generate railroad diagrams directly from the command syntax in text form.

Check it out at http://translator.colindaley.com and let me know what you think.
TomThomson
TomThomson
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: 10704 Visits: 12002
Phil, I find myself about 95% in agreement with you; the 5% discrepancy is because I think you are understating your case.

For a long, very long, extremely long time I have struggled with the fact that MS tools like Query Analyser (OK, I'm archaic) and SSMS when asked for scripts to generate something as simple as a table or a view, instead of generating a natural script generate a heap of gobbledegook dominated by lousy layout and insanely prolific and utterly unnecessary brackets that requires extensive editing before it is useful for anything. It's cheering to see that I'm not the only one who has noticed that minor problem; and somewhat disappointing, on reading these comments, to see the odd one that suggests Ms have got that right!

Tom

Phil Factor
Phil Factor
Right there with Babe
Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)

Group: General Forum Members
Points: 741 Visits: 2937
@Colin
I couldn't get that link to work. It would be a great tool to have. It is a time-consuming job to do by hand.


Best wishes,

Phil Factor
Simple Talk
Colin Daley
Colin Daley
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 68
Drat! I can't access it either. I can ping it, but Firefox says "Connecting ..." forever. Is that what happened to you?

I have reported it to my hosting provider. I will update you when it is up again.
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