The notebook may not render on a mobile device. Use the Secret Management moduleĪgain, I decided to use a notebook to show this as it is a fantastic way to share code and results and because it means that anyone can try it out. Unfortunately, people being people, they will often store their admin account credentials in a less than ideal manner (OneNote, Notepad ++ etc) to make it easier for them, so that when they right click and run as a different user, they can copy and paste the password. In many shops, you will need to open applications that can do administration tasks with another set of account credentials. It is good practice to not log into your work station with an account with admin privileges. > Can I use this to run applications as my admin account? A user with a beard The ability to filter in the ADS Object Explorer.Following on from my last post about the Secret Management module.You can’t hold Alt to make a rectangular selection in the SSMS editor (although there are other options for those kinds of edits - I just need to update my muscle memory).There are only a couple of things which I miss from SSMS: No more digging around SSMS menus to find that one tick-box. Another feature that is in SSMS but that just seems to work slightly better in ADS - in particular I like the folding of CTEs. The notebooks are saved in the Jupyter Notebook format, so they can be converted (e.g. I find this kind of literate programming approach is helpful for tasks such as investigating data quality issues. ADS notebooks let you mix SQL and Markdown. I also find it helpful to be able to diff code fragments on the fly. ADS on the other hand plays nicely with Git for Windows from the get-go. But they tend to require a third-party plug-in. Again, there are ways to use Git (or other VCS) with SSMS. ADS retains the familiar Object Explorer from SSMS. Code completion feels both a bit smarter and also less laggy than in SSMS. The same good highlighting as you get in SSMS - certainly better than RStudio’s default attempt to highlight T-SQL. Auto-formatting is just such a quick win for writing code others can read. You can choose to automatically format as you type or when you paste code, or with a keyboard short-cut. The code formatting in ADS worked for me out of the box. It’s possible to auto-format code in SSMS but I never quite got it working to my satisfaction. The former certainly describes my workload better than the latter, so I gave it a try. Microsoft says to use ADS if you “spend most of your time editing or executing queries”, while you should prefer SSMS if you “spend most of your time on database administration tasks”. The user experience for an analyst is similar to working with an on-premises database in SSMS. Despite its name, ADS isn’t just a tool for managing Azure cloud databases. Lately though I’ve left SSMS for a different Microsoft product, Azure Data Studio (ADS). But I always missed the code highlighting and completion, and the ability to view object definitions too much to stick with it. It’s nice to have everything in one place. For trusts on the Microsoft stack, it’s the standard approach, and it works fine.įrom time-to-time I’ve experimented with writing my SQL in RStudio when working on R projects. All the while I’ve worked in the NHS, I’ve used SQL Server Management Studio (SSMS) as my development environment for writing SQL queries.
0 Comments
Leave a Reply. |