SQL Server – Testing backups (part III)

Welcome to the final step of your future automatization 🙂 Quick reminder what we have done previously. This one forced me to learn new stuff – writing SQL queries and grabbing the results. It was fun to do 🙂 So the general idea was to create a script that will connect to the SQL server,…

Read More

SQL Server – Testing backups (part II)

Welcome back to a resolution of  Admins nightmare – Primary site is down and backup files are useless. Today we will go through the short procedure of getting the data from Blob storage to a local drive. The script is very similar to the previous one, with few specifics which are well commented 😉 Don’t…

Read More

SQL Server – Testing backups (part I)

Everyone who has ever installed a SQL Server has also set up a backup procedure (hopefully :)) But, besides backing up your valuable data, how many of you are actually testing what has been backed up? Do you have a disaster recovery procedure? If you do – how often do you do it? How much…

Read More

Extend AlwaysOn SQL cluster in Azure – Step by step

Hi fellows, Over the past few days, I dealt with a client request to configure SQL AlwaysOn cluster in a hybrid environment. At the first look, that should have been a simple task, especially because I have configured AlwaysOn in dozens of projects. Unfortunately, project brought me a lot of problems during configuration, but I…

Read More

SQL AlwaysOn – Step by step

Hello everyone, In this post, I will describe process of configuring AlwaysOn on SQL Server 2016. Always On availability groups feature is a high-availability and disaster-recovery solution for your SQL databases. Before you start with configuring, you need to meet some prerequisites. For successful implementation, you need: SQL Server Standard 2016, or older in Enterprise…

Read More

How to install SQL Server 2016

This is a first post in “How to install” series. I will show you how to install SQL Server 2016, ie. how I like to install SQL Server, and for this purpose I will use SQL Server 2016 Enterprise edition. At the first place, hardware need to be prepared before installation. This means that the disks for…

Read More

How to check installed SQL components

Have you ever had the need to install an identical SQL server what you currently have? Of course, you need information about the installed components, but you’ve wondered how to easily do so. You can do that on two ways, and each of them are pretty simple.   Solution 1: Open start menu / screen on…

Read More

How to transfer logins and passwords between SQL Servers

In one of previous posts, Mismatch SQL account SID, you see how to find account SID and create new SQL account with same SID. With that queries you can manually do that, but if you don’t know password, you will still have same problem – incompatible account between SQL servers in cluster. Also, if you need to “replicate”…

Read More

Mismatch SQL account SID

My first project of creating highly available AlwaysOn SQL infrastructure was very challenging. Although I was prepared, and many tasks passed smoothly, I had a big problem after database failover. Database doesn’t work properly, and I had problem with orphaned user. After researching, found that SQL accounts are not same on both nodes although have a…

Read More