“We have SQL Server version 20 years ago, and it runs fine. So what’s the problem? Why should we upgrade it?”
The short answer is that the more your SQL Server is out of date, the more things become
“Vulnerability = liability.”
-Anon
Older versions of any software are less secure internally than their newer cousins. After all, “the good old days” of computers are always slightly simpler…
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:
“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…
The tech world is just beginning to adapt to the “new normal”. Businesses are working through the hurdles of remote work environments. We’re all passing around remote working tips on desks, work hours, and hot beverages. That’s good stuff, but you’re going to need more than a good ergonomic chair to push through the rest of 2020: you’re going to need some solid SQL tools.
Here are the five absolutely essential tools for SQL Server shops, as agreed on by the MinionWare team.