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
Category:SSMS
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
SSIS in SSMS Version 18
Version 18 of SQL Server Management Studio (SSMS) has been out for a few weeks now, but I just now had the opportunity to install it and tinker. There are a lot of new features! Here’s a list of SSIS-related features: Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that …
Continue reading SSIS in SSMS Version 18