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.

Skype for Business Edge Server reset connection

2020-02-11 1 min read Skype for Business "Erwin Bierens"

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”

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

How to obtain your SQL Reporting license key

2020-01-24 1 min read Microsoft SQL Reporting Services "Erwin Bierens"

During the installation of SQL Reporting Services 2019 you will be asked to insert a license key. You don’t need to buy a separate key to make use of full features.

Start SQL Server setup

Run your SQL Server setup and copy the pre-populated key:

License key SQL Server Setup

Download Reporting Services 2019, run setup, and paste the key: License key SQL Server Setup

Continue your setup.

Enable God Mode for Windows 10 and Windows Server

2020-01-23 1 min read Windows 10 Windows Server Windows Server 2016 "Erwin Bierens"

The steps shown in this post will work on Windows Server 2012, 2016, 2019, Windows 7, Windows 8 and Windows 10. When activated, it is a folder that contains links to all of the settings of your Windows system.

How to enable God Mode in Windows 10

To enable God Mode in windows 10 login to the Windows 10 client with account that has administrative privileges. Create a new folder on the desktop. Right click and rename it as God Mode .{ED7BA470-8E54-465E-825C-99712043E01C} and press Enter.

Microsoft Teams for Linux

2020-01-23 2 min read Microsoft Teams Linux Ubuntu "Erwin Bierens"

This how to is written for debian distro based operating systems. During this test i’m using Ubuntu Desktop 18.04.3 LTS.

Installing Microsoft Teams

First of all download the right client package for Microsoft Teams.

For my Ubuntu desktop i’m using the DEB 64-bit installer. You can also download the package using wget.

Teams Installer Download

Download the package from the Teams website. You can find the latest version right here (Right click the version and copy the link)

Disable .NET Framework 4.8 from Windows Update

2020-01-21 1 min read Exchange Skype for Business 2015 Windows Server 2016 "Erwin Bierens"

About the .NET Framework 4.8

The .NET Framework 4.8 is an in-place upgrade to versions 4, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2 and 4.7 of the .NET Framework. In case of Exchange / Skype for Business Server 2015 if you don’t have the corresponsing CU patch or product level we will need to block the automatic installation through Windows Update of the .NET Framework 4.8 patch.

These steps describes how to perform this blocking action.

Older posts Newer posts