Erwin Bierens

Knowledge is Power

How to create a Team in Microsoft Teams

2020-03-17 2 min read Microsoft Teams     "Erwin Bierens"

In this how to, I will show you how you can create your own team within Microsoft Teams. The following steps will be exaplained below:

  • Click the link at the bottom of the window which says Join or create a Team.
  • Click the option that says Create a Team.
  • Select to Build a team from scratch.
  • Choose Teams modus for the team.
  • Name the team, and select create.
  • Add people or groups.

How to create a Team

Click the link at the bottom of the window which says Join or create a team. Create Team

Continue reading

The tag present in the reparse point buffer is invalid

I ran into this issue recently where some files and folders were not accessible in using the File Explorer, command prompt or even PowerShell. When trying to open / rename or delete the folder the following error pops up:

The tag present in the reparse point buffer is invalid

Tag present not valid

The files / folders were located in OneDrive for Business and enabled for the on-demand feature. Based on saome other blogs, those files / folders are junction and got in a bad state.

Continue reading

Using Reverse Number Lookup in Microsoft Teams

2020-03-11 2 min read Microsoft Teams     "Erwin Bierens"

What is Reverse Number Lookup (RNL)

When you receive calls in your Teams client Reverse Number Lookup (RNL) will show the displayname instead of the actual phone number.

With RNL the system converts the number that is calling you to a name configured in your outlook contact or even Azure Active Directory.

The following order will be used to check and the last one will always override:

  • SIP Invite From Header
  • Azure Active Directory
  • Outlook contacts
  • Teams contacts

Requirements Exchange

The callee, in your tenant, needs to have a Exchange Online mailbox. The source object containing the phone number(s) to be matched against need to be mail-enabled in Exchange, either in Exchange Online or in Exchange on-premises with an Exchange Hybrid deployment. Mail-enabled objects are:

Continue reading

Using custom Tags with Microsoft Teams

2020-03-05 1 min read Microsoft Teams     "Erwin Bierens"

With tags, you can categorize people based on attributes, such as role, project, skill, training, or location. For example, a “Project member” or “Manager” or Customer (guests)" tag will enable you to reach groups of people in Teams without having to type every single name.

Once the tag is added, just use “@mention” in a channel. Everyone who has been assigned with the specific tag will receive a notification just as they would if they were “@mentioned” individually.

Continue reading

Skype for Business Edge Server reset connection

I ran in to a problem with a new Skype for Business server 2015 Edge installation. I was not able to connect to the sip.domain.com from a webbrowser. The browser finds the server but the server closes the connection (RESET). Therefore clients cannot log in at all.

So i fired up wireshark on the Edge server. I see my IP connecting to the Edge external interface, but it will give the message: “Reset: Set”

Continue reading

How to change compatibility level of a SQL Database

2020-02-10 1 min read Microsoft SQL     "Erwin Bierens"

Get Compatibility level of databases

First start checking your version of SQL, start a new query.

    SELECT SERVERPROPERTY('ProductVersion');

Run Query

Now start a new query to check the compatibility level of the databases.

    SELECT name, compatibility_level FROM sys.databases;

Run Query

Set Compatibility level

Create a new query.

    ALTER DATABASE databasename
    SET COMPATIBILITY_LEVEL = 120

Run Query

Compatibility Levels

Product Database Engine Version Default Compatibility Level Designation Supported Compatibility Level Values
SQL Server 2019 (15.x) 15 150 150, 140, 130, 120, 110, 100
SQL Server 2017 (14.x) 14 140 140, 130, 120, 110, 100
Azure SQL Database single database/elastic pool 12 150 150, 140, 130, 120, 110, 100
Azure SQL Database managed instance 12 150 150, 140, 130, 120, 110, 100
SQL Server 2016 (13.x) 13 130 130, 120, 110, 100
SQL Server 2014 (12.x) 12 120 120, 110, 100
SQL Server 2012 (11.x) 11 110 110, 100, 90
SQL Server 2008 R2 10.5 100 100, 90, 80
SQL Server 2008 10 100 100, 90, 80
SQL Server 2005 (9.x) 9 90 90, 80
SQL Server 2000 (8.x) 8 80 80

/

Continue reading
Older posts Newer posts