en-UShe-IL
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

TNWikiSummit


Awared MVP 


 


Microsoft® Community Contributor 


Microsoft® Community Contributor


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

Recent Entries

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 16/01/2020 14:19

Microsoft official Documentation state that "Read/write data filegroups and log files cannot be placed on an NTFS compressed file system. Only read-only databases and read-only secondary filegroups can be put on an NTFS compressed file system", but is is this accurate?!?

By ronen ariely on 07/01/2020 18:13

This is a simple compare I do for the sake of a question in the forums. Since I don't have time now, I will add other solutions and dive into better and I will check further comparisons in the future. At this time I will add the result of two suggested solutions.

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 13/10/2019 10:00

This post includes two simple demo code to demonstrate (1) how order of columns can impact the size of the table and the database, and (2) That order of columns can be related to errors in the execution.

By ronen ariely on 13/10/2019 09:56

Understanding what we have under the hood is not only done for the sake of learning a theory, but it directly impacts your daily work, and it can help us to improve performance and reduce resources dramatically.

During this session we will go over the structure of tables behind the scenes. We will see the changes behind the scenes related to DDL actions which we execute on tables.

Using this information, I will demonstrate several real case scenarios, and the dramatic impact of understanding the internals on choosing our solution.

Is the order of columns important? Is dropping a column the right solution? Questions like those are very common in the forums and usually does not get the right answers. The answers might be a game changer in production environment

This session is a live demo!

By ronen ariely on 13/10/2019 00:30
The issue: SQL Server grand Server level permissions and database level permissions to all new users, which is a security issue. In this post I will present some of the permissions which any new login gets and how we can revoke or deny these permissions. This post based on the question asked in the MSDN forum and presents some theoretical options. Whether you should do it in production is another discussion...
By ronen ariely on 29/09/2019 07:36

OPENJSON is a build-in SQL Server table-valued function (return tabular structure), which parse text that formatted as JSON. By default, the function only parse the first level of the JSON document, but using explicit path to the nodes in the document we can parse the entire document including unlimited level of hierarchy. This sound great except the fact that JSON document is commonly used for unstructured data, meaning we do not know what nodes the document will have and what is the the path to each node... OPENJSON does not provide a dynamic parsing for hierarchy structure.

In this blog, I will present a simple recursive table-valued function, which based on OPENJSON and provide full dynamic hierarchy parsing of JSON document.


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 22/08/2019 10:39

SQL Server 2019 release candidate is now available! So what does it brings?