In this post I describe how to install SQL Server Management Studio (SSMS) version 22, which is in preview at the time of this writing. Get the Bits To begin: Visit the Microsoft Learn article titled Install SQL Server Management Studio Click the link labeled “Download SSMS 22 Preview”: Remember where you save the file: …
Continue reading One Way to Install SSMS v22 (Preview 3)
Category:SSMS
SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent
I’m reading Announcing SSMS 20.2 … and getting feedback for SSMS 21 by Erin Stellato (LinkedIn) on the SQL Server Blog and this fix caught my eye: SSIS and SQL Agent – many customers ran into a connection error (“The certificate chain was issued by an authority that is not trusted”) in SQL Agent when trying …
Continue reading SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent
I’m Installing SSMS Version 18.12.1…
… and you can install it, too! Visit Download SQL Server Management Studio (SSMS) and have at it. :{>
One Way to Build an SSMS Database Solution – Add a Stored Procedure and the Build
This is the fourth post in a series named One Way to Build an SSMS Database Solution. Please find additional posts: One Way to Build an SSMS Database Solution – Introduction One Way to Build an SSMS Database Solution – Add a New Query One Way to Build an SSMS Database Solution – Add a …
Continue reading One Way to Build an SSMS Database Solution – Add a Stored Procedure and the Build
One Way to Build an SSMS Database Solution – Add a Table and a View
This is the third post in a series named One Way to Build an SSMS Database Solution. Please find additional posts: One Way to Build an SSMS Database Solution – Introduction One Way to Build an SSMS Database Solution – Add a New Query One Way to Build an SSMS Database Solution – Add a …
Continue reading One Way to Build an SSMS Database Solution – Add a Table and a View
One Way to Build an SSMS Database Solution – Add a New Query
This is the second post in a series named One Way to Build an SSMS Database Solution. Please find additional posts: One Way to Build an SSMS Database Solution – Introduction One Way to Build an SSMS Database Solution – Add a New Query One Way to Build an SSMS Database Solution – Add a …
Continue reading One Way to Build an SSMS Database Solution – Add a New Query
One Way to Build an SSMS Database Solution – Introduction
This is the first post in a series named One Way to Build an SSMS Database Solution. Please find additional posts: One Way to Build an SSMS Database Solution – Introduction One Way to Build an SSMS Database Solution – Add a New Query One Way to Build an SSMS Database Solution – Add a …
Continue reading One Way to Build an SSMS Database Solution – Introduction
View Azure Blob Storage Containers in SSMS
SQL Server Management Studio – SSMS – supports viewing the contents of Azure Blob Storage containers. Connect to a Azure Blob Storage Container To connect, open the latest version of SSMS, open Object Explorer, and click the Connect dropdown in the Object Explorer menu: Select “Azure Storage…” to start the connection process. The Connect to …
Continue reading View Azure Blob Storage Containers in SSMS
SQL Server Management Studio v18.6 is Available
SQL Server Management Studio v18.6 is released! According to Microsoft, version 18.6 is the second major release of SSMS in 2020. There are cool new features and even more bug fixes: Enjoy! :{>
SSIS in SSMS Version 18: Try SSIS in Azure Data Factory
There’s a new option when you right-click the Integration Services Catalogs node in SSMS v18: “Try SSIS in Azure Data Factory”: Clicking the “Try SSIS in Azure Data Factory” option in SSMS v18 opens the (new) Integration Runtime Creation Wizard (ISIRCreationWizard.exe, which is found in the <installation drive>:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn directory): …
Continue reading SSIS in SSMS Version 18: Try SSIS in Azure Data Factory