SQL – Set-AzWebApp -name "Anything Microsoft and other stuff on the side"

SQL Server 2022 and Azure ARC with Azure subscription model

Posted by Harri Jaakkonen Posted on 28/11/2022 0 Comments

Posted in Azure, Azure AD, Azure ARC, Compliance, Defender, IAM, Identity, Identity Platform, Microsoft Purview, On-premises, Powershell, Security, SQL

SQL 2022 has arrived and in this post I will try out the new setup that should have Azure ARC install embedded. Why to use Azure ARC with SQL 2022? One reason could be security, you will get these features…

Accessing Azure SQL with different methods

Posted by Harri Jaakkonen Posted on 26/10/2022 0 Comments

Posted in Azure, Azure AD, Conditional access, Identity, Powershell, Security, SQL

I decided to write about Azure SQL as inspired by an question from the community. The ask was “How to do I access Azure SQL with MFA enabled user, should I remove the MFA and create a normal user?” In…

Section 6 – Design security for infrastructure – Design a strategy for securing SaaS, PaaS, and IaaS services

Posted by Harri Jaakkonen Posted on 31/08/2022 0 Comments

Posted in Azure, Defender, Key vault, Security, SQL, Zero trust

Time for the next section to my SC-100 study guide: Specify security baselines for SaaS, PaaS, and IaaS services Specify security requirements for IoT workloads Specify security requirements for data workloads, including SQL, Azure SQL Database, Azure Synapse and Azure…

Section 14 – Secure data and applications – Configure security for databases

Posted by Harri Jaakkonen Posted on 22/05/2022 0 Comments

Posted in Azure, Azure AD, Azure Firewall, Defender, Identity, Microsoft Purview, Security, SQL

In this section I will cover the following: Enable database authentication by using Azure AD Enable database auditing Configure dynamic masking on SQL workloads Implement database encryption for Azure SQL Database Implement network isolation for data solutions, including Azure Synapse…

Azure SQL Database pricing and security features

Posted by Harri Jaakkonen Posted on 18/11/2021 0 Comments

Posted in Azure, Identity, Security, SQL

What is Azure SQL Azure SQL databases are coming more and more used. They can be expanded on the go with elastic pools or you can use them inside servers like inside on-premises installations. You can have multiple SQL services…

SQL history and migration to Azure with security of Defender.

Posted by Harri Jaakkonen Posted on 02/09/2021 0 Comments

Posted in Azure, Azure AD, Identity, Security, SQL

Hi, This time I will be blogging about SQL databases. First a little about history. SQL databases had (and still have) a significant part in the structure of a software. They contain storage for the data and configuration for nearly…

SQL Server Backup from inside Azure VM

Posted by Mikko Pantti Posted on 10/04/2019 0 Comments

Posted in Azure, SQL

You can backup SQL Server databases and instances running inside Azure VM using Azure Backup. The solution leverages the SQL native APIs to take backup of your SQL databases. When you specify the SQL Server VM that you want to…

Sharepoint 2013/16 and WSS_Logging DB

Posted by Harri Jaakkonen Posted on 08/11/2017 0 Comments

Posted in Onpremise, Powershell, Sharepoint, SQL

Sharepoint gathers usage and health data to database called WSS_Logging. By Default retention period is 14 days. If You want to make it lower, lets say 2 days use the below oneliner for it.

Get-SPUsageDefinition | Set-SPUsageDefinition -DaysRetained 2

1	Get-SPUsageDefinition \| Set-SPUsageDefinition -DaysRetained 2

And then just a quick…

User has db_owner my mistake.

Posted by Harri Jaakkonen Posted on 07/09/2015 0 Comments

Posted in SQL

Hi, When you are trying to remove user from a database, you will get: The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) There is a easy fix for this. First…

Install SQL when reboot is pending

Posted by Harri Jaakkonen Posted on 14/01/2015 0 Comments