Stories

▼

Topics

▼
Showing posts with label SQL_DB. Show all posts
Showing posts with label SQL_DB. Show all posts
Wednesday, 22 March 2023

DevOps - Get-SpnAccessToken is obsolete

›
Case I'm deploying my SQL Server database via DevOps with the SqlAzureDacpacDeployment@1  task in YAML, but it is giving me a warning:...
Saturday, 12 November 2022

Deploy Azure SQL Databases via a DevOps pipeline

›
Case A while ago we did a post about deploying an Azure SQL Database via Azure DevOps  using the deployment pipelines. Since that post we m...
1 comment:
Friday, 13 May 2022

DevOps: SQL Server - NETFramework v4.5 not found

›
Case I have a DevOps pipeline to build and deploy my Azure SQL Server Database, but it is giving an .NET Framework error stating that it ca...
Sunday, 20 February 2022

ADF Snack - Give ADF access to SQL DB via MSI

›
Case I'm using Azure Data Factory to populate tables in an Azure SQL Database. I want to avoid using SQL Server authentication/Basic au...
Monday, 5 July 2021

SQL Snack: Create readonly DB user in Azure SQL DB

›
Case I want to create a SQL Server user in my Azure SQL Database that can only read tables and view from a specific schema so I can use it ...
Monday, 20 April 2020

Databases in DevOps - Publishing profile

›
Case I can’t release my database project due an error “data loss could occur” error code Updating database (Failed) *** Could not...
1 comment:
Sunday, 2 February 2020

Schedule Up/Downscale Azure SQL Database (API)

›
Case I want to up- and downscale my Azure SQL Database within my ADF pipeline. You recently showed how do this with  Powershell code  in an...
Saturday, 1 February 2020

Schedule Up/Downscale Azure SQL Database (TSQL)

›
Case You recently showed how to up- or downscale my Azure SQL Database with Powershell code in an Automation Runbook, but is there a way t...
5 comments: