Hi All, A few Hours ago, Microsoft has released the Azure PowerShell Module AZ v8.0.0
Microsoft Azure PowerShell AZ 8.0.0
https://www.powershellgallery.com/packages/AZ/8.0.0 Release Notes not yet udated
https://docs.microsoft.com/en-us/powershell/azure/release-notes-azureps?view=azps-7.5.0 Check your current installed Module and what is available on PowerShell Gallery
Get-InstalledModule AZ Find-Module AZ
I've published a Script in my GitHub Repo to uninstall the old Modules and install the new Modules https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/AzureAD/Microsoft.Graph_HowToStart.ps1
Or you can run the Script below to directly execute that Script
Hi All, As you probably know, i am a big Fan of Azure Automation to run some Automation Scripts for M365 in Azure. When you try to install a new Microsoft Graph Module in Azure Automation from the Gallery it will fail, due its dependency for Microsoft.Graph.Authentication, because an older Version is installed.
I've tried to figure out, how to update the Modules with PowerShell (too much clicking for doing it manually).
Hi All, Yesterday the AZ PowerShell Module 7.5.0 has been released
AZ PowerShell Module 7.5.0
https://www.powershellgallery.com/packages/az/7.5.0
I have used my Cleanup-AZModules.psy from my GitHub Repo to update the Modules
https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Cleanup-AZModules.ps1
Get-InstalledModule AZ
Get-InstalledModule AZ.*
Regards Andres Bohren
Hi All, Today Microsoft has released a new Version of the MSIdentityTools PowerShell Module
MSIdentityTools 2.0.10
https://www.powershellgallery.com/packages/MSIdentityTools/2.0.10
Find-Module MSIdentityTools If you have already installed a Version of the PowerShell Module
Uninstall-Module MSIdentityTools Install the PowerShell Module
Install-Module MSIdentityTools
Get-Command -Module MSIdentityTools
Get-MsIdAzureIpRange | measure
Connect-MgGraph Resolve-MsIdTenant -TenantValue icewolfch.onmicrosoft.com Regards Andres Bohren
Hi All, Most Organizations i know use M365 group-based Licensing. It fit's theyr provisioning Processes because it's just adding a User to another Active Directory Group. As they are already used to do.
What is group-based licensing in Azure Active Directory?
https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-licensing-whatis-azure-portal
Licensing requirements
You must have one of the following licenses for every user who benefits from group-based licensing:
Paid or trial subscription for Azure AD Premium P1 and above Paid or trial edition of Microsoft 365 Business Premium or Office 365 Enterprise E3 or Office 365 A3 or Office 365 GCC G3 or Office 365 E3 for GCCH or Office 365 E3 for DOD and above
Hi All, Finally i have some time to do a Project i've always wanted to do. In a Series of Blog Article i will create a SQL Server / SQL Database in Azure and compare diffrent Deployment Methods. Let's start with an ARM Template. First i started creating a SQL Database in the Azure Portal. Under "Review + create" you can download the Template.
The Template consists of a template.json and parameters.
Hi All, Finally i have some time to do a Project i've always wanted to do. In a Series of Blog Article i will create a SQL Server / SQL Database in Azure and compare diffrent Deployment Methods. Let's start with the AZ CLI https://docs.microsoft.com/en-us/cli/azure/install-azure-cli-windows?tabs=azure-cli
The Script can also be found on my GitHub Repo https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Demo02-SQLDB-AzCli.ps1
###############################################################################
# Demo02-SQLDB-Az.ps1
# Create SQL Server / Firewall Rule / SQL Database with AZ CLI
Hi All, Finally i have some time to do a Project i've always wanted to do. In a Series of Blog Article i will create a SQL Server / SQL Database in Azure and compare diffrent Deployment Methods. Let's start with the PowerShell AZ Module Install-Module AZ
The Script can also be found on my GitHub Repo
https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Demo01-SQLDB-Az.ps1
###############################################################################
# Demo01-SQLDB-Az.ps1
# Create SQL Server / Firewall Rule / SQL Database with AZ.
Hi All, Two Days ago, Microsoft has released a new Version of Azure AD Connect that fixes an Error, when there is a model db corruption. Resolve Model database corruption in SQLLocalDB
https://docs.microsoft.com/en-us/troubleshoot/azure/active-directory/resolve-model-database-corruption-sqllocaldb
Azure AD Connect: Version release history
https://docs.microsoft.com/en-us/azure/active-directory/hybrid/reference-connect-version-history Microsoft Azure Active Directory Connect 2.1.1.0
https://www.microsoft.com/en-us/download/details.aspx?id=47594
On the M365 Admin Center in the Health > Directory Sync Status you can find the new Version Number
https://admin.microsoft.com/#/dirsyncmanagement
Regards Andres Bohren
Hi All, In this Blog Article, i want to talk about how to protect your Azure SQL Databases with Firewall Rules at Server or Database level. Azure SQL Database and Azure Synapse IP firewall rules
https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure
The Server Level you can find on your Server Object
You can also find this when query the master Database --Database: master
SELECT * FROM sys.firewall_rules
At the Database level use this sp_set_firewall_rule (Azure SQL Database)
