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 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 12/10/2019 18:36

This post present code to configure default configuration parameters for each new LOGIN created in the server instance. The code configure parameters like: default database, default language, password will not expire, and password policy will not be checked. The solution presented here is based on using DLL TRIGGER ON CREATE_LOGIN event

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 16/08/2019 07:20
I wrote this short script for my personal use. I had over 60k unread massages in specific label and I wanted to mark all the messages before 01/01/2019 as read.
Yes you noticed correct... I have more in other labels! sry but I cannot read all the emails which I get and they just keep coming. If you need me then please contact me on Facebook, linkedin, or Skype.
The problem is that using the GUI Gmail allows us to see maximum 100 emails in a page and manually delete 100 emails at a time might need several hours to end the task. 
Therefore, I choose to use Google script for the task...
By ronen ariely on 07/08/2019 04:38
This post includes sample code for step by step: (1) create database. (2) CREATE TABLE. (3) create folder for the Audit logs. (4) CREATE SERVER AUDIT. (5) CREATE SERVER AUDIT SPECIFICATION. (6) CREATE DATABASE AUDIT SPECIFICATION. (7) Read the log file.
By ronen ariely on 17/07/2019 02:45
According to the documentation if you want to Access the error log files on Linux then you can convert the files to UTF-8. There is only one issue... The files are already written in UTF-8 encoding and not like in windows in UTF-16, which mean that this paragraph is really confusing...
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.