Service restart without administration permissions

Service restart without administration permissions
Today I need to configure to allow normal user to be able to restart some service. The problem was because user was not admin user. I will show you how to in easy way configure it. In case of reinstallation service remember that permissions needs to be updated one more time. First you need to download Process…

MSSQL – DBMail configuration

MSSQL – DBMail configuration
Today's post will contain tutorial how to step by step configure DB Mail feature in MSSQL database. To have it we need already created mail account and SQL management studio. First, login via SSMS with admin account to SLQ DB. In tree at the left choose Management, next Database Mail ,click PPM and choose"Configure Database Mail" In…

How to fix orphan users problem in SQL

How to fix orphan users problem in SQL
After MSSQL database restore you might to meet with situation that in DB will be orphan users. Simply, it is empty login name without any assignment with user. We can check it and then will see that there is 2 the same login names but with different SID numbers like on the picture below. To list all…

Windows Server 2019 – language pack installation

Windows Server 2019 – language pack installation
Some days ago I need to install additional language on windows server 2019. I will share with you how to do it. Firts, you need to download ISO language pack for Windows Server 2019 and mount this image by double clicking and then it will show as a DVD drive in "This PC". Next, need to start…

Sharepoint – how to see who views files or pages ?

As a owner of sharepoint site, you might to know who was reviewed your files. To see that we have to enable sharepoint feature allowing for that. Keep in mind that you have to have proper permissions to be able manage SP site. Open your site in browserThen, in the top right corner choose Settings and Site…

Import and export SQL data to Excel file

Import and export SQL data to Excel file
Today I will show you how to export and import data between SQL server and Excel file. I thing it will be usable for you. To make import please open SQL Server Management studio, connect to SQL server and right-click on our DB. Choose file to be imported. in my case import file looks likt that: Results…

Phishing – attack simulation – Exchange

Today post will be about very useful feature in exchange online - Attack Simulation Training. This feature allows to simulate phishing attack on organizational mail accounts. Phishing is most popular type of attack today. Despite that fact very users still is clicking and providing credentials on that attack. Prerequisites To have full functionality of AST you have…

Fine-grained password policy- Active Directory

Fine-grained password policy- Active Directory
To increase security of AD, administrators implements policy passwords. That policy specify how should passwords looks like. It is regarding complexity, lenght, time for change etc. Default policy password set in GPO could be set as a only one and for whole domain. Fine-Grained password policy is available since Windows Server 2008 and allow to create multiple…

Searching text inside files – PowerShell

Searching text inside files – PowerShell
Today I will show you how to search for specified patterns in text files. We can say that it will be similar to known findstr in traditional cmd. In PowerShell there is a command: Select-String As a example file I will use text file with lorem ipsum content. Example command which will find pattern will be like…

Searching for files – PowerShell

Searching for files – PowerShell
In today post I will show you how to use PowerShell in order to file search. Will use Get-ChildItem command or if some of you like shortcuts - gci. In general this command is used to list objects in some location specified in parameter -Path. That location could be file system or registry. The simplest usage of…