Author Archives: Andrzej

How to use findstr like a grep

Since you’re here, you’ve probably looking for solution similar to grep in Linux. findstr is a command-line utility in Windows that allows you to search for specific text strings within one or more files. When running findstr, we will specify the following arguments: Here is some example. We will serach for a word andrzej insiteContinue reading “How to use findstr like a grep”

Create SQL Server for SQL Database in Azure

In this post, we will quickly create a SQL Server in Azure. To achieve this I will use a PowerShell script. Prerequisite is: Azure Subscription existing Resource Group First, we will define a variable. After that, we will check if there is already a server if not, then the script will start to create one.Continue reading “Create SQL Server for SQL Database in Azure”

How to start migration MS SQL Databases to the Azure Cloud

For one of my clients, I had to prepare a presentation on how to start migrating SQL Server databases to Azure Cloud. My goal was to start with the basics and answer the questions that both myself and the client should ask at the beginning of the migration process. I would like to share myContinue reading “How to start migration MS SQL Databases to the Azure Cloud”

Sync Login for SQL Server Availability Groups AG Multiple Server

The Problem: In your SQL Availability Group environment and you have created a new login. After failover the users reports that they cannot connect to the database with the application. Because the connection to database goes via AG Listener, the application will be redirect to the secondary SQL Server Node after failover of Availability GroupContinue reading “Sync Login for SQL Server Availability Groups AG Multiple Server”

Azure RBAC (Role-Based Access Control)

A quick post about Azure RBAC and Role Definition. What I can do with RBAC? Allow for particular user to manage Virtual Machines or for another user to manage Storage Allow for Database Admins to manage SQL Managed Instance in a subscription Allow for a user to manage all resources in a Resource Group likeContinue reading “Azure RBAC (Role-Based Access Control)”

Restore Database on SQL Server with PowerShell

Today is the day of testing database restoration. Such a test should be done every six months to ensure that the backup and restore work as expected. Sometimes I see that the backup is done outside the maintenance window, manually without the CopyOnly CHECKSUM parameter, and saved to another path, etc. Then it turns outContinue reading “Restore Database on SQL Server with PowerShell”

Register SPN for SQL Server authentication with Kerberos

Today a continued work with SQL Server, but for another customer:-), I write this to share with you about my experience with SQL, but also for my as a documentation of my daily work. What is Kerberos? Kerberos is a network authentication protocol. It is designed to provide strong authentication for client/server applications by usingContinue reading “Register SPN for SQL Server authentication with Kerberos”

Join database to SQL Server Availability Group with PowerShell

The customer for whom I am working, need that I check all SQL Server Instances (about 40) for a database that is not joined in the availability group (AG). I am a little bit lazy to do that manually, so I decide to write a PowerShell. Of course, I am using dbatools (thanks to allContinue reading “Join database to SQL Server Availability Group with PowerShell”