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


GUI or CLI


GUI or CLI

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (104K reputation)SSC Guru (104K reputation)SSC Guru (104K reputation)SSC Guru (104K reputation)SSC Guru (104K reputation)SSC Guru (104K reputation)SSC Guru (104K reputation)SSC Guru (104K reputation)

Group: Administrators
Points: 104681 Visits: 19328
Comments posted to this topic are about the item GUI or CLI

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Ryan C. Price
Ryan C. Price
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 Visits: 1206
Horses for courses.

I would say 'it depends' on, amongst other things, your scale, your mix of servers/instances, your job function and experience.

I find truly ironic, this "Text Mode" obsession in the "Windows" world. Even within Microsoft's later editions of Visual Studio, there's less ad less "Visual" and more-and-more "Text Editor" for producing user interfaces.

And I get really annoyed with is people who think *their* way of doing something is the *right* way, and that any other way is deserving of scorn. That's the domain of religious zealots.

I'm a 'part-time' DBA (about 1/4 of my job time-wise), managing a score of mostly application-specific SQL instances that are mostly completely different from each other. In 'global' terms, our databases are tiny; the largest (our ERP database) being only about 50GB. So all up, we have a few hundred GB of data that I try to at least make sure is backed up regularly, and performance kept acceptable.

I use SSMS pretty much exclusively. Not that I'm afraid of a command line (I come from a VAX/VMS background, and moved to Windows out of necessity), but SSMS gives me a one-stop place to get to all the servers as/when needed. We have very few in-house developed systems; mostly I'm poking around inside some vendor's 'shrink-wrap' database trying to fix problems that have cropped up, and it's just much quicker for me to just click-to-expand databases, tables, views, etc. I use the scripting features all the time, but avoid using the GUI view designer (because I find the resulting SQL is barely legible). I find it an invaluable tool.

Most of the rest of my job is maintaining our few internally developed apps, which also involves me using SSMS as a development/troubleshooting/configuration tool. And it makes a great XML editor.

I'm sure if I was a full-time DBA to a Fortune 100 company with 500 identical servers servicing some Mega-Application, that I would have a very different view of the world. But that's not my job, so SSMS is the right tool for *me*.

I see the deprecation of GUI-based tooling as a step away from Microsoft's heritage. I believe that their GUIs (flawed though they may be) are core to the success that Microsoft have had with many of their products - the GUI admin tools available back in Windows NT days made the opposition (Novell) look primitive, and made Windows admin easy. Similarly with the Visual XXX development tools, and SQL's SSMS and its predecessor (Enterprise Manager) - they empowered people who just needed to get a job done, to get the job done, and get it done quickly, and made the products much more 'approachable' than their competitors.

For me, I think that if I didn't have SSMS, I'd have to question why I'd bother holding on to SQL Server as a platform for our internal systems; licensing PostgreSQL would be much simpler...
Dave Poole
Dave Poole
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12636 Visits: 3378
Pretty much agree with Ryan. I've yet to see anything worthwhile come out of a religious war. I'm a great believer in the genius of AND vs the tyranny of OR.
For me the GUI is great for rapid experimentation, prototyping what you want to do and generating the base scripts.
The command line is great for putting together a script that can be run in multiple environments.

These are tools to do a job not shackles to hamper us.

LinkedIn Profile
www.simple-talk.com
Gary Varga
Gary Varga
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22615 Visits: 6534
I totally agree with Ryan and David. I love the following from David (whether his or a quote in of itself):
the genius of AND vs the tyranny of OR

I also think that it is essential to be able to both as a professional. Not necessarily an expert, as already stated, but be comfortable to use either as and when needed even if it requires the support of ones own favourite search engine.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Alex Gay
Alex Gay
Right there with Babe
Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)

Group: General Forum Members
Points: 715 Visits: 478
I'm very happy with a CLI, but I am old and that is all that we once had. I also use Linux extensively at home, and use the terminal a lot there (Guake makes it much easier as well).
Strangely I was asked yesterday if a server had an FTP Client on it, and received a look like I had grown a second head when I replied that they all did, opened a cmd window and typed FTP, to enter a session.
For some things, a GUI is easier, especially if it is a one-off setting, but if you need to set up a bunch of machines, or server, all exactly the same then the CLI, and preferably a script, is the best tool for the job, whether that is DOS, Bash, PoSH, or SQL.
latkinson
latkinson
SSC-Enthusiastic
SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)

Group: General Forum Members
Points: 121 Visits: 76
Both CLI and GUI have their advantages and disadvantages. I'd like to believe I'm in the majority of rational thinkers in that, where a CLI is more efficient or provides an option not available in the GUI, or vice-versa, let the tool fit the requirements.

Luther



chrisn-585491
chrisn-585491
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3134 Visits: 2489
There's no war between CLI and GUI proponents, there's just clickbait and emotional responses spewed on the InterTubes.

It's not an absolute either/or absolutism, experienced computer pros recognize the strengths of the full spectrum of resources we have available. I think it's fine that we can explore a range of various tools from the bare CLI, to the assisted CLI that has tab completion, to VS Code, to SSMS, to Visual Studio.

I still have batch files in production. I also still develop applications with user friendlier interfaces. I recognized the value of both of the CLI and GUI back when AutoCAD had a CLI and the first Macs were released in the '80s. And one of the coolest things about SSMS is that you can automatic generate scripts from the GUI. It's a good marriage of both interface paradigms.
Gary Varga
Gary Varga
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22615 Visits: 6534
Do we also need to recognise professional banter for what it is? Is this adding to a myth of contention?

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Dave Poole
Dave Poole
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12636 Visits: 3378
Gary Varga - Tuesday, March 14, 2017 2:30 AM

the genius of AND vs the tyranny of OR



Sadly not one of mine. Neither is "willing prisoners of the familiar".


LinkedIn Profile
www.simple-talk.com
Ryan C. Price
Ryan C. Price
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 Visits: 1206
chrisn-585491 - Tuesday, March 14, 2017 6:36 AM
There's no war between CLI and GUI proponents, there's just clickbait and emotional responses spewed on the InterTubes.

It's not an absolute either/or absolutism, experienced computer pros recognize the strengths of the full spectrum of resources we have available. I think it's fine that we can explore a range of various tools from the bare CLI, to the assisted CLI that has tab completion, to VS Code, to SSMS, to Visual Studio.

Probably not on SQL Server Central; people on these forums seem to be quite civil and level-headed.

But I've seen some hysterical (both meanings of that word) flame wars on the craziest of I.T.-related subjects.

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