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

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

New Trusted Site Required when Connecting to Azure SQL DB

I got pinged about a new trusted site requirement when I tried to connect to Azure SQL DB this morning. https://aadcdn.msftauth.net is the URL. I added the URL to Internet Explorer’s Trusted Sites: I was then able to connect to Azure SQL DB and add a rule for my IP using SQL Server Management Studio (SSMS).