You are here:   Blog

Blog Archive:

* Can be used in order to search for older blogs Entries

Search in blogs

Blog Categories:

* Can be used in order to search for blogs Entries by Categories

Blog Tags:

* Can be used in order to search for blogs by keywords


Awared MVP 


Microsoft® Community Contributor 

Microsoft® Community Contributor

 Read first, before you you use the blog! הגדל

Recent Entries

By ronen ariely on 02/07/2020 17:32
Simple working with Primes numbers
By ronen ariely on 14/06/2020 01:51

When we are using Static Public IP, then there is no need to update the DNS records each time that the IP address changed. This ensures us that there will be no downtime to our services, while the DNS servers are not updated (a process that can take few hours).

The Azure public IP is a separate service, which we can associate to a new or existing Network Interface or to a load Balance. The Network Interface is associated to Virtual Machine. Therefore, if we are using a Static IP, then we can migrate IP Address from one machine to another. This is a powerful option in cases that we need to migrate services between virtual machines.

In this post I go over the theory of networking is a glance in order to cover the main terms which we all must know, before we start to play with the powerful options that Azure Static Public IP provide us. Next I present several practical scenarios of using static public IP (create IP, associate to existing VM, Migrate between VM, and so on).

By ronen ariely on 08/06/2020 05:02
Let's "play" with some data and let me show how to use SQL Server to Analyze the Coronavirus Covid-19 data. The source of the data was taken from the CSSEGISandData GitHub project. In this post I will add some useful queries and explain how to use the data and what can we do with it.
By ronen ariely on 06/06/2020 12:53
Multiple reports arrives in the forums starting 9 hours ago but Microsoft Azure subscription Service Health only alert me about one hour ago! My conclusions: follow the forums and report in the forums for others to get the information fast
By ronen ariely on 29/05/2020 21:07

When we create DSN to the Azure SQL Database using Microsoft tool odbcad32.exe, then the password is not saved. Therefore, each time we use the DSN we need to fill the password. Can we skip this task and store the password in the DSN cata?

Note! This is a pure answer to a question in Microsoft new forum interface Q&A. The forum does not allow me to publish the answer raising the absurd error "Exceeded the Normal request".

By ronen ariely on 28/05/2020 02:32

This is a simple step-by-step tutorial to demonstrate how we can create auditing of logout event using Extended events, on Azure SQL Database. It basically present an answer to a question in the MSDN forum.

By ronen ariely on 18/05/2020 18:07

When executing the powershell command Get-AzSqlDatabaseGeoBackup I am getting an error which claim that the Azure logical server does not exists in the current subscription, while the server is alive and I can execute the command Get-AzSqlDatabase and get all the databases in the server!

Get-AzSqlDatabaseGeoBackup : 40647: Subscription '9be5b21d-3676-40f1-baec-16c10ae909ec' does not have the server 'sponsor01'.

By ronen ariely on 08/05/2020 23:29
Does COLLATE important when we use the function UPPER on the text? Just a small sample related to a forum question, since I cannot add images in the comments
By ronen ariely on 07/05/2020 03:07
Application Change Analysis service is monitoring tool that supports viewing changes for all resources across Azure subscription on Azure portal. Sound awesome! So let's review what works and what not so much...
By ronen ariely on 02/05/2020 20:12
Microsoft Build is an annual conference event held by Microsoft, aimed at software engineers and web developers using Windows, Microsoft Azure and other Microsoft technologies. The attendee price is usually above 2000$ each year, but not this year! Microsoft announced that the conference will be held online this year and the registration will be free. Keep reading and register ASAP since there might be limitation in number of registrations!