You are here:   Blog
Register   |  Login

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 this before you use the blog! Maximize

Recent Entries

By ronen ariely on 10/11/2022 20:56
Simple script to edit Azure VM Firewall rule using PowerShell and use the current public IP. This can be use to update for example the RDP rule or the SQL Server rule so we will be able to connect the server from local location.
By ronen ariely on 25/07/2022 22:41
לפני יומיים מיקרוסופט הכריזה על האפשרות להשתמש בהצפנת נתונים עם מפתחות מנוהלים על ידי לקוח (CMK) עבור Azure Database for MySQL! האפשרות להביא מפתח משלך (BYOK) להגנה על נתונים במצב מנוחה, יכולה להעלות את האבטחה ולאפשר מיגרציה וסינכרון בין השרתים המקומיים לביןם השרתים בענן. אתה יכול להשתמש בתכונה זו כדי ליישם הפרדת חובות לניהול מפתחות ונתונים. בנוסף, ניתן לנהל ולארגן מפתחות באופן מרכזי באמצעות Azure Key Vault. השימוש בהצפנה מנוהלת על ידי לקוח ניתנת לך את הכוח והחראיות על מחזור החיים של מפתח האבטחה, הרשאות שימוש במפתח ופעולות ביקורת על מפתחות.
By ronen ariely on 01/02/2022 11:41

In the last several weeks I see many questions regarding Microsoft released of the new support to manage backups of SQL Server on premises in the Azure storage. This post is not intended to replace the official documentation, but only to simplify operations in a practical way. This post present step by step tutorial on backup to URL, backup to Azure Storage, and restore back to on-premises.

By ronen ariely on 20/01/2022 10:09
If you get the error: "The subscription is not registered to use <provider name>" then this post might help you understand and solve the issue. This can be related to change which was done in your subscription type.
By ronen ariely on 01/12/2021 21:07
It is quite common, especially when we are using free subscriptions, to have an issue to create Azure service in specific region, creating service using specific tier, or even creating the same service multiple times. These issues related to limitation in the Azure Subscription resource quotas. This post follows such issue which was raised in the Microsoft QnA forum. In this post I will explain the issue and present optional solution or clarify the limitation.
By ronen ariely on 11/04/2021 08:02

Azure Files (שירות קבצים משותף) הוא שירות בענן של מיקרוסופט, אשר משתמש בקבצים השמורים Azure File Storage. הקבצים משמשים כתיקיות שיתופיות וירטואליות. כל קובץ מוגבל ל-5TB אך אתה יכול להפעיל מספר שיתופים באמצעות קבצים מרובים. ניתן להשתמש ב-Azure Files כדי להחליף אחסון מחובר ברשת (NAS) או מערכות קבצים מקומיות. השירות מבוסס על פרוטוקול Server Message Block (SMB) ומאפשר להעביר יישומים ונתונים "כפי שהם" באמצעות פרוטוקול זה. ניתן לגשת לקבצים באמצעות API תוך שימוש בתקשורת מוצפנת, או לנהל את הקבצים באמצעות ממשק המשתמש המובנה בפורטל, דרך Azure CLI או PowerShell.

על ידי שימוש בשירות של Azure File Sync, אתה יכול לסנכרן ו/או לשכפל את הקבצים בין מספר שירותים בענן ואחסון מקומי לטובת גיבוי או שיפור ביצועים. השירות מאפשר ליצור מאגר מרכזי עבור קוד או כלי עזר המשמשים במהלך בדיקות ופיתוח.

שירות קבצים משותף מאפשר לרכז מדדים וקובצי יומן להטמעה על ידי כלי ניטור וניתוח. השירות מספק יתירות לניטור ופתרון תקלות נתונים.

By ronen ariely on 14/09/2020 10:20
In order to open a support ticket we need to login to Microsoft services. This is true in the Azure as well as in other services like Visual Studio Subscriptions(formally called MSDN subscriptions). So this leads direct to the chicken or the egg dilemma in the case our issue is with login to the account. We cannot login so we cannot open a support ticket. This VERY SHORT post simply provides the way to bypass this issue regarding the Azure (in other services you might find other solutions fit better)
By ronen ariely on 31/08/2020 10:57
Convert Azure Virtual Machine with SQL Server installed into Azure SQL Server Virtual Machine
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 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 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 22/04/2020 09:42
When we are trying to create a custom name for a new vNet while creating managed instance using the portal, the default name is not changed. The comment in the portal explicitly says "To create new subnet select option with the prefix (new)". Unfortunately, this does not works (tested on Chrome Version 80.0.3987.122). if you use Azure Web Portal and you are going to create a new Azure SQL Managed Instance service, then you should keep reading, since I found a small bug. More interesting is that I will present a simple workaround I found.
By ronen ariely on 29/03/2020 03:10
We all familiar with computers viruses and we understand that these can affect our applications, but is it posible that a biological virus will impact our applications? Unfortunately the answer is yes. During the last few days it seems that the Coronavirus impacts users that work with Microsoft Azure. 

By ronen ariely on 22/10/2019 14:29

Azure SQL Database and SQL Server 2019 introduce full support for UTF-8. This is a game changer for developers, but it came with a price! Old functions like CHAR() and ASCII() which were designed to be used on Extended ASCII, return strange result and might lead to unexpected result when we are using UTF-8 COLLATE. Moreover! the documentation at this time is wrong and was not updated to cases that the user use UTF-8 COLLATE. 

In this post I will go over the function ASCII, explain how it was designed to work (according to my understanding), show the problematic in SQL Server 2019, and I present full explanation including some internals information which will help us better understand the topic.

By ronen ariely on 22/09/2019 01:41
Microsoft Documentation claims that "The Read Scale-Out feature is enabled by default on new Premium, Business Critical, and Hyperscale databases" but in fact it is not enabled on Hyperscale databases by default!
By ronen ariely on 03/07/2019 02:28

Well, I don't know if you noticed but in the last year or so, blogs on the MSDN and TechNet system were closed or become "read-only". Unfortunately, this includes two of the blogs where I serve as co-administrator (wikininjas and forumninjas) which are in the same situation, but today I do not want to focus on these. In this post I want to focus only on the blogs where the Microsoft Data Platform teams write. The problem is that by closing the blogs on MSDN/TechNet blogs it seems like the blogs of the SQL Server teams has dispersed, and today each person or each group publishes his blog elsewhere in a different interface. It is almost impossible to follow all the blogs this way... I hope this list can be useful to you.

By ronen ariely on 01/10/2018 12:02

המושגים חשבון ענן, מנוי ענן, ושירות תקיות בענן הם חלק מהמנה הלוגי הבסיסי של ניהול השירותים שלנו בענן של מייקרוסופט (Microsoft Azure). עם זה, קיים בילבול דיי רציני בין המתמשים בשירותים השונים לגבי השימוש המדויק של כל אחד מרכיבים אלו וכיצד הם משתלבים ביחד במבנה היראכי. שאלו רבות בפורומים קשורות ישירות או בעקיפין להבנת נושא זה. ככלל אני אוהב לספק תשובות בפורומים ולעזור למשתמשים, אבל מהצד השני אני עצלן ואני לא מעוניין לכתוב תשובה בהיקף של בלוג בכל פעם שאני נתקל בשאלה. לכן אני אוהבמאוד לתת תשובות קצרות יחסית ולהפנות אנשים למאמרים מתאימים ותיעוד רשמי אשר ניתן למצוא באינטרנט.

ואכן, באינטרנט נוכל למצוא מאמרים רבים וטובים בנושא, אבל מייקרוסופט לאמספקים תיעוד רישמי בעברית לצמערי ועד כה לא מצאתי פרסום נאות בעיני, אשר נותן מענה פשוט להבנה, ולכסות נושא זה. לכן אני אנסה בפרסום זה לתת את המענה הנ"ל

By ronen ariely on 21/06/2018 00:28

Central Processing Unit (CPU), CPU Core, Logical cores, vCore…

No… in this short post I am not going to explain about the Azure new vCore-based purchasing model. For more information about this you can read to official documentation. Unfortunately, he documentation does not cover explanation about the meaning of phrase vCore.

In this short post I will try to explain what the hell Microsoft means by vCore and what do we actually get.

By ronen ariely on 09/02/2018 12:56
חדש!!! שירות מופע מנוהל של שרתי SQL באזור (Azure SQL Managed Instance ), הוא שירות חדש ששוחרר היום ל Public Preview וזמין לשימוש.
By ronen ariely on 30/01/2018 01:48
There is a temporarily issue in using Azure Automation with sqlserver PowerShell module, which lead to the error message: Invoke-ProcessASDatabase : The term 'Invoke-ProcessASDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
By ronen ariely on 19/01/2018 06:36

According to the documentation “ReadOnly lock on a SQL Database prevents you from deleting or modifying the database”, but in fact this is not accurate!

* Everything that I write about was tested at the time I write the post, and might be changed in the future!Let’s test it!
By ronen ariely on 23/11/2017 10:22
This is a simple Step-By-Step tutorial, showing how to use Azure BLOB Storage services to store backups of SQL Server databases. During the tutorial I will start with creating a new Azure Storage Account, next I will create new Credential in our local SQL Server and using the Credential I will backup and restore the SQL Server database.
By ronen ariely on 04/07/2017 16:03

Using the SQL Server Management Studio Stretch Database wizard with the option to filter the rows, does not fit for cases that the table does not include data which fit the stretch condition! 

We can use the built-in SQL Server Management Studio wizard in order to enable Stretch on the database and configure the table which will be stretched to the Azure on the same time, but it does not fit for all cases. In this short blog, I want to show example (again) why you should not use wizards.

* The solution is simply to use T-SQL queries, and please forget about using Stretch Database wizard, as I usually recommend regarding most wizards.

By ronen ariely on 07/03/2013 14:20

מדריך קצר צעד-אחרי-צעד לבדיקת מצב החשבון שלנו בממשק החדש של הענן Azure.