I interact with MySQL and PostgreSQL all the time and I'm comfortable doing so via Unix command (my preference) or via myPhpAdmin or phpPgAdmin. So I was surprised how tripped up I got today when I needed to access a Microsoft SQL Server over a remote connection.
Trying to figure out which product I needed, and what if anything was free, was surprisingly tricky.
When it's all said and done, I found that Microsoft SQL Server Management Studio Express worked like a charm, and was even free to download. I just plugged in the hostname of the server the hosting provider gave me, and set it to SQL authentication, and I was accessing tables in no time.
Any great tools I should know about for MS SQL?
No comments:
Post a Comment