SQL Clone
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
Phil Factor
Phil Factor
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8368 Visits: 3074
Comments posted to this topic are about the item When Windows don’t provide illumination


Best wishes,

Phil Factor
Simple Talk
nickmeyer
nickmeyer
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: 13
Sorry, MS Access and 'those fripperies' is where I come from. It is regretable that SSMS's query creator isn't as polished as Access's. I have absolutely no idea why anyone would WANT to create a table through text and not a GUI. It's like coding HTML in notepad or anything in VI. You can do it, but why? Especially when you can use the GUI to generate a script which you can then tweak. Generally, for VBA recordset SQL, I'll use the query editor to build and test the SQL, and copy-and-paste the SQL into code for tweaking. Why would I want all my fat-fingered typos in my code when I have the tools to avoid them--and be way faster to boot?
emmchild
emmchild
SSC-Addicted
SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)

Group: General Forum Members
Points: 460 Visits: 408
MS has done a fine job of getting in the way of writing concise SQL statements. ADO.NET Entity Framework is a very dangerous technology in the hands of developers who don't have any interest in the sql that is dynamically generated. The move to cloud based services should rectify most of this nonsense. It going to be hard to justify paying a significant hosting bill as a result of the poorly written code that some of these gui tools produce. No one at MS really mentions it but these poorly designed statements have no chance at scaling.



5teve
5teve
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 8
I couldn't agree more, as a C# dev. Only the other day I had to sync two database schemas and the auto-generated primary key names were a pain when creating a script to rename across multiple deployments! However it did provide the opportunity to delve into the information_schema table in order to solve the problem. :-)
Dalkeith
Dalkeith
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1102 Visits: 1200
I think your solution is clearly a better implementation.

I think MS in particular has sometimes just fallen short when polishing off the UI implementation of otherwise good ideas which is why I think people like Apple and Google have managed to gain grounds in emerging markets their UIs tend to be smoother albeit more general. I do believe in the principle behind their ideas though and frequently use the diagramming tool albeit often editing generated syntax afterwards.

I always find it slightly amusing when people separate text from graphics/diagrams - in a very real sense they are one and the same. Maybe we just need time for the really valuable non text gui principles to be established we benefit from the ground rules for text which have been established over 3,000 years of history.

I had a look at the new features of Data Explorer in Excel 2013 at the weekend and they're introducing multiple tabs marked things like Query / Pivot table / Data mining etc. Excel is becoming a query editor. They're even introducing a new hybrid query language - M - Personally I would have liked them to align any query language in Excel with TSQL and I would like to have very clear deliniation between textual query editor and the associated graphical editor which generates that text and not multiple variations of a couple of ideas. Similarly aligning the query editor in Access with TSQL always seemed like a good idea. To some extent the departments in MS struggle to coordinate things sometimes.
vgrimes-1120058
vgrimes-1120058
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 54
I liken writing SQL vs using designer tools to driving a standard transmission vs an automated transmission. With a standard, you have more control over how the vehicle operates, and likewise, when you write your own SQL rather than have some designer write it for you, you have more control over what the DDL is doing. Sure, you can have a designer do it for you and then tweak it, but are you really looking at all the automated ~decisions~ the designer is making for you, or are you saying "well, the designer put it there, so it must be ok" and ignoring it. If the latter, that, to me, shows a lack of curiosity and ultimately a lack of understanding. Even if you make sure to understand every part of the auto-generated SQL, I argue that this still takes longer. When you need to change a check constraint, I had a dev spend 30 mins trying to figure out how to get the designer to change it and then generate the SQL, and when he had trouble with this he came to me. I wrote the ALTER stmt in less than 2 mins. I don't mean to be too harsh on those who "grew up" doing it that way, but you exercise and strengthen your brain muscles more effectively when you make an effort to figure out how to write the stmt without a GUI to help.

-VG
p.s. I've been coding long enough that yes, I wrote my first HTML in notepad as there weren't many IDEs back in the early 90s. While I agree that having IDEs are helpful, I don't think I would have learned nearly as much if I had not had that original experience of having to figure it all out by trial and error.
dmbaker
dmbaker
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2391 Visits: 3669
"When they need to construct a class in C#, they don't heave out a prosthetic GUI to do it. They just cut code"

Well, I think one could call Visual Studio the epitomy of a "prosthetic GUI". And I think that's what most c# devs would heave out (appropriate choice of word there I think :-) ) when they need to write code.



Dave Poole
Dave Poole
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30267 Visits: 3615
I found I quite liked HeidiSQL, the GUI that ships with MariaDB. It echos the commands that the GUI performs including those that are used by the GUI itself during its normal operation. It's quite a good teaching aid.

I think what we really need is a good hard look at intellisense. In SQL Management Studio intellisense is playing catchup with Red-Gate SQL Prompt but SQL Prompt isn't perfect.
As ever the technical problems are easy but there are two business problems to address.
1. Getting cheque signed to buy an intellisense solution
2. Make the development of an intellisense solution a viable business operation.

The writing of SSMS plug-ins is a bit of a black art. Perhaps Red-Gate could help out here.
1. Set up a plug-in writing competition
2. Provide the basic framework for a plugin so the actuall plug-in itself is a //TODO in the provided framework.

LinkedIn Profile
www.simple-talk.com
Mauve
Mauve
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5946 Visits: 2071
I couldn't agree more. I hate the "noise" generated by SQL Server's reverse-engineering.

I've been coding RDBMS (IBM'S DB2, Oracle, SQL Server) code (DDL and DML) for 30 years. I still use a plain text editor vs. reverse-engineering stuff to check into the source code control system. Yes, I learned long before the fancy GUI "helpers" came about.

Typing it (actually, mostly copy-and-paste with some "find"/"replace" changes) requires me to think about what I'm doing and results in a better (and neater, for SQL Server) end product (DDL script).

I have been badly burnt, to many times to know better, by reverse-engineering software (from numerous vendors). Including a major issue where Microsoft's SQL Server reverse-engineer (generate script) failed to include a CHECK constraint in the resulting DDL. Therefore, I don't trust any of them.


(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.
JJ B
JJ B
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1979 Visits: 2864
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.

Using ERwin, a GUI tool for creating tables if ever there was one, helps me make sure I use consistent code for creating tables. The assistance is huge, and I can't imagine wanting to waste time writing all that code by hand when ERwin will do it for me. I get to focus on the important things like table and join designs. I don't have to worry about whether certain 'code' fields are typically varchar(10) or was that 11? Did I spell that field name correctly? And did I remember to index the foreign key? Etc.

Then there is the documentation. I can write tons of documentation for individual tables and fields in ERwin. Again, I can't imagine putting that documentation only in text files which I then run in SSMS.

All of that assistance from ERwin was vital when I was a newbie. I would have made a ton of mistakes in my database designs had I not had ERwin available when I first started working with databases. I would go so far to say that ERwin was partly a career maker for me. How could a well designed GUI tool for making tables *not* help a beginner? For one thing, you can design all sorts of table and have the tool generate the SQL for those tables. It is how one can learn to write good CREATE TABLE statements.

While I can easily understand finding serious fault with a poorly designed GUI tool, I can't figure out why anyone would put down all GUI tools on principle--especially for beginners. It doesn't make any sense to me.
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