SSMS Quick Install from PowerShell
Waned to share PowerShell snippet to download SQL Management Studio (SSMS) with one liner and the AKA MS redirect service. Cheers
Code
iwr https://aka.ms/ssmsfullsetup -outfile ssms.exe; .\ssms.exe
Screenshot
VIDEO – Mini SQL Query
Review and demo of a great portable app named “Mini SQL Query” I use to verify SQL connectivity and run queries. Faster than full SQL Management Studio (SSMS). Portable app ZIP to download and double click EXE to run.
Cheers!
Video
References
Poster – SharePoint List – When to Use What
The below visual captures ideas on SharePoint table data storage and when to use what. Rows and columns of data are common. Choosing the best hosting technology provides ease of support, quick time to market, performance, and scale for data growth.
SQL Server has good use cases, but comes with trade-offs including higher upfront setup effort and fewer end user controls (audit, search, version history). Can improve performance and reporting if those trade-offs are correctly addressed.
Select right tool for the job. Times for both.
Cheers!
Download PDF
Download VSDX
VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2)
Our next step in this series is cloud hosting. Each of the local source components has a Microsoft cloud destination equivalent. Here is the mapping:
- SQL Express > SQL Azure
- WebAPI > Azure Web App
- Angular SPA > Office 365 SharePoint Content Editor
In the video below I walk through all of these steps to migrate the local “todo” CRUD application created earlier to be fully hosted in Microsoft’s cloud. From there, we have a fully operational business application running on Office 365 with all custom code hosted in Azure.
Enjoy!
Video
VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2) from Jeff Jones on Vimeo.
