June 8, 2016 at 12:00 pm
This may just be a rant but Microsoft's assertion that SSMS 2016 fully supports Azure SQL Database is a big lie. My shop is getting ready to jump on to DBPaaS so I have been trying to come up with standards, functionality etc for about a week. I feel like I'm back on Oracle 8i with SQLPlus. I've been doing SQL since 6.5 so my T-SQL skills are fine but be honest with the community.
Here is what doesn't work in SSMS for SQL Azure that I have found in the last week:
*Almost all context menu ( i.e. properties) don't work
*DB level stored procs are hit and miss (i.e. sp_helprolemember)
*Basic reporting is missing (i.e. Disk Usage)
*Intellisense doesn't work (SQL prompt does so what is the holdup?)
*Some alter login parameters don't work despite what technet says
None of these are step hills and you can find TSQL and DMV's workarounds for all of them. The point is SSMS 2016 is missing a lot of functionality that is supported in my on prem instances. I don't have 15 minutes in my day to find the TSQL equivalent every time I find basic functionality that doesn't work. For DB pros that have always relied on the great GUI features in SSMS and aren't up on the finer details of TSQL, SQL Azure is going to be a bear.
David
P.S. if Steve Jones read this and wants me to turn this into a guest editorial private message me.
June 8, 2016 at 3:44 pm
David O (6/8/2016)
P.S. if Steve Jones read this and wants me to turn this into a guest editorial private message me.
Although I think Steve would reply with a resounding "YES", you should write it up and submit it even if he doesn't. I think it's even more important to understand what the cloud won't do for you than what it will.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2016 at 12:46 am
David O (6/8/2016)
...turn this into a guest editorial ...
or even better, submit it as an SSC article !
Marketing only highlights the fancy stuff !
Users want it to work
DBA want it to be manageble and many of the rely on yea good old SSMS point and click features
It is important to know the things you'll be missing when migrating to a new SSMS, combined with a new engine.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 13, 2016 at 4:29 am
Speaking as someone who stopped using the GUI tools for most operations many years ago, I miss the stuff that Azure does not do well because I don't use the GUI. I think this could make a good article. The trick is always going to be figuring out why it doesn't do a particular thing. Meaning, is it related to the fact that we're talking about only a database and not a server. I'd love to see a detailed list of unsupported operations.
And how happy am I that SQL Prompt works well with Azure.
"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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply