The SQL Server Management Studio makes a lot of operations very simple. Creating a database takes three clicks. A new login is a minimum of two clicks.
So why is it that we at MinionWare still write T-SQL over 90% of the time, instead of using the GUI? We like code better than mouse clicks for three basic reasons:
- T-SQL lets you do more
- T-SQL lets you share your process
- T-SQL lets you keep a record
Do more with code
“Doing more with code” shows up in several ways: flexibility, applicability, and repeatability.
T-SQL is far more flexible, and so you have more options available in code. On the other hand, a GUI is locked into a certain set of options, and so you’re more limited.
Let’s take the example of creating a login…