July 13, 2024 at 5:13 am
HI Team,
what are the software's required for sqlserver dba in laptop to install in new company can you list out things where i dont have access need to reach access team to install , i need to provide the list of software's required
Thanks
Naga.Rohitkumar
July 13, 2024 at 7:23 pm
My opinion - that REALLY depends on the company. For example, if you have a license for SQL Prompt, I would recommend grabbing that.
But as a bare minimum, for a DBA role, I would want to have SSMS installed and notepad++ and a web browser of some sort. My opinion - nothing else is "NEEDED", but there are more nice to have tools (SQL Search for example) and it depends on what you are licensed for AND what you will be doing. If you are doing developer work as well as DBA, then Azure Data Studio may be helpful. If you are doing tuning on older SQL instances, Profiler may be helpful (useful on newer ones too, but Extended Events are more powerful and less impactful on the server even if they are a little harder to set up).
Just my 2 cents, but there is no "one size fits all" solution. In the event you need to RDP into the server hosting SQL, I like having Remote Desktop Manager installed so I don't need to memorize all of the servers, but that's just a personal preference, not a hard requirement. My opinion, SSMS is the only hard requirement with notepad++ being a very nice to have tool (especially with the free SQL formatting plugins installed).
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 15, 2024 at 1:56 pm
There isn't a single correct answer to this. Here's my list of "I'm gonna need this" software:
SQL Server Management Studio
Azure Data Studio
VS Code
Git
Docker
Redgate Toolbelt (yes, I work for them, but I bought that toolbelt in four companies before I went to work for Redgate. If I didn't work for them, I'd buy a copy of Toolbelt)
Flyway Desktop (see above note)
That's the minimum for me.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply