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 insite…
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.…
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 my…
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 Group…
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 like…
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 out…
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 using…
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 all…
My first blog post
HA, my first blog post and I have already a problem. In which language should I write? polish? is my native language, but I am not sure if I this found an attention german? hmm, I’ve lived in Germany for over 10 years now and have still a problem with der, die, das and so…
Follow My Blog
Get new content delivered directly to your inbox.
Home 