Dealing with a Skype for Business deployment with SQL AlwaysOn isn’t an easy task as there are a number of different elements involved from ensuring your databases are in the correct configuration to security permissions across the nodes.
I did originally create the following script while doing a customer deployment and have improved/modified to ensure I take out most of the headaches involved when deploying your backend databases.
The script runs through the following actions;
Check if SQL Instance
Check if Failover Clustering Role in configured on the two SQL servers
Ask to configure Failover Clustering Role (If required)
Convert and backup all Skype for Business Databases
Detect Skype for Business Folder on source SQL Server and copy to secondary
Configure SQL Server Service for AlwaysOn
Repeat task manually on the secondary server
Complete your AlwaysOn Configuration using the SQL Management Studio
Download Pro-Loaded Office 365 Configuration Files – This contains Office 365 ProPlus and Office 2019. This option supports menu 20 which calls the downloaded setup.exe and xml files.
Support for PowerShell Version 5 – This script using Version 5 to expand Zip archives which allows the script to call the contents. If Version 5 is not detected you will be prompted to extract the required files manually.
If youidentity any issues within running the script please email email@example.com
When working with PowerShell and using a (get-command | fl or format-list) you will receive a whole list of information which sometimes can be difficult to digest as shown below. In most cases normally you are only after one or two pieces of key information.
Select-Object is a great command when filtering PowerShell output by a particular property example Get-Service and Name/Status
When working with PowerShell and using a (get-command | fl or format-list) you will receive a whole list of information which sometimes can be difficult to digest as shown below. In most cases normally you are only after one or two peices of key information
Using Format-List or LT you can specify the required information into something a bit more readable.
For example, I am currently working Get-SPOSite (SharePoint Online Sites) and I would like to know if any of the sites have sharing capabilities and site defined sharing capabilities.
# Command Get-SPOSite | Select-Object -Property URL,SharingCapability,SiteDefinedSharingCapability | ft
As you can see from the above image the output for the required fields is more readable to my needs. You can use this approach for many different scenarios and maybe within a technical script you are writing for a deployment or an action.
Just come across an interesting blog post about Office365DSC Module and like a kid in the candy store. Just had to have it and start playing
The module has been created by a number of Microsoft Premier Field Engineers (PFE’s) and its very much in the earlier stages but supports the following.
O365Group: Office 365 Groups (Security, Distribution List, Mail enabled and Office 365)
O365User: Office 365 User and Licenses
SPOSite: SharePoint Online site collection
The blog is quite vague of information but the goal is to make the community aware that the effort is currently undergoing, and that if people want to contribute to it, that they are encouraged to report issues, comments/feedback or to fork and submit Pull Requests to help out with the code base.
To install the Early Preview, run the following line of Powershell
install-module – Name Office365DSC -AllowPrerelease
Microsoft have recently released an update to the Microsoft Teams powershell module, in this update we see 3 new exciting additions allowing more control for your Microsoft 365 Global Adminstrator or dedicated Microsoft Teams Service Administrator.
New-Team -Owner Parameter
You can now create Microsoft Teams using the Owner parameter
Edit all Teams settings on all Teams without ownership
Now as a Microsoft 365 Global Admin or Microsoft Teams Service Admi, you can edit all setting within a Microsoft Team located within your tenant.
What no licence require?
The administration account no longer requires a Microsoft Teams Licence in order to use the PowerShell Module
So now lets update Microsoft Teams PowerShell module.
I have created the following script which will check your client machine to see what version is installed and install the latest version.
Microsoft Teams Direct Routing is the latest in connecting your SIP trunk provider but how about leveraging the Microsoft cloud and deploy your Session Boarder Controller (SBC) into Azure.
Audiocodes are one of many SBC providers using Azure to provide an additional options with your approach to moving to Microsoft Teams. If your a consultant deploying AudioCodes Mediant VE SBC for Microsoft Azure, this process couldnt be any easier with using Azure Resource Manager (ARM) templates which can be developed to adapt to any customer requirements.
If you have a bit of Azure knowledge in deploying new resources the below image will not be to difficult understand.
But if this is the first time you’ve looked deploying a resource in Azure, I highly recommend looking at creating a template and use Visual Studio. This will allow you to make modification in the code and learn how ARM templates work.
How much does the Audiocodes Virtual Machine cost?
The below tables is based on today costing as of 12 November 2018 and these prices may change.
Microsoft Teams Direct Routing will only get bigger as time goes on and you can expect the number of supported SIP sessions to increase (expected 6000 sessions in Q1 2019). It is also worth noting that Audiocodes also offer a multi tenant SBC so if you are a service provider, you can house multi customers on a single SBC appliance.
Microsoft Teams now supports dynamic groups but what does this mean? Dynamic groups are an Azure AD Premium (P1) feature that allows group membership to be automatically tied to AD attributes (i.e. users with a location of ‘London, New York or Seattle’) that will continuously sync as the membership changes over time. Dynamic group membership reduces the administrative overhead of adding and removing users.
Which is great for IT Administrator across the group.