You are here:  Blog
Register   |  Login

Awared MVP 

Microsoft® Community Contributor 

Microsoft® Community Contributor

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


Maximize מה בעמוד?

Recent Entries

By ronen ariely on 22/05/2016 18:29

Using "Microsoft Help Viewer", which is a small free tool, we can download the entire official SQL Server Book-Online. In this short blog I will explain how to do it step-by-step from downloading Microsoft Help Viewer to installing the SQL Server documentation.

By ronen ariely on 15/04/2016 12:45


At the beginning of the month I lectured at the SQLSaturday # 481 event about the new support of JSON in SQL Server 2016. During the demonstration I showed queries that returns JSON text. SQL Server returns the JSON text formatted as compact text / dense format (one line, no extra space), which is good for most cases that we want to store the text or pass it between machines for example. But, by using a compact format the structure of the JSON document is not readable. 

In NoSQL servers, which based on JSON, we usually have a built-in method to format the JSON document into a format that is easier for humans to read (for example in mongoDB it named "pretty"). This feature must be added to the SSMS or to the SQL Server, in my opinion. In the mean time, for the sake of the lecture, I created simple app that do the job. it is basically a "one line app" using the nuget package Json.NET (Newtonsoft.Json).

After I uploaded the lecture materials (code and presentation), I got requests to upload the application as well. Since I do not like the idea that people execute code without understanding it, and since this is very simple and short code, and most DBA does not develop dot.net application, therefore I decided to post the code, as a step-by-step tutorial for beginners.

By ronen ariely on 15/04/2016 10:39

In this session we will demonstrate several built-in JSON support functions in SQL Server 2016, and we will finish with some tricks and tips to improve performance.

By ronen ariely on 29/02/2016 21:57

Most people heard about the 2000 year bug, which occur once in 1000 years, but less people familiar with much more common bugs related to February 29, which occur approximately every 4 years. Let's named these as the "February 29 bug" or the "Leap year bug".

This blog based on a message posted at MSDN forum, by Yaniv Cohen, who notice that the use of the function ISNULL returns unexpected result, regarding February 29. Is this really unexpected result and we found a BUG?!? Starting with the original issue, as a starting point, I explain how the relevant functions behaves behind the scenes, and the difference between them. I reproduces the "unexpected behavior" using simpler case, and point to the source of the "unexpected behavior". I will present demos that you can execute in order to figure out how the relevant functions works, and in particular gives you the tools to understand the extent of the problem.

By ronen ariely on 12/02/2016 14:49

A very common question that raise in the forums is: why a FULL BACKUP, which was fast in past becomes slow. It can be a one-time issue (specific backup), or permanent. These question are usually not related to big database (100TB +), which we are not using FULL BACKUP usually, and are more common on small-medium databases. In this blog I will provide information, explanation, tips, and some links to read more. This blog is in permanent process of improving. If you have any comment please post it in my Facebook home page.

By ronen ariely on 31/12/2015 20:29

Simple CLR code for SQL Server

By ronen ariely on 23/12/2015 19:34

Several days ago I stumbled a new blog that was published with what seem to me as partial solution. The original blog based on real customer request, and it discusses on using hash function in order to create a first filter, and then working on the filtered data in order to get the final result as requested (two steps job). The blog included only the first step (as a solution for the client?!?), probably focusing on the main idea of using Hash function and splitting the job into two steps.

In this blog firstly I will discuss a very small improvement to the query in the original post, for the first step. Next, I will show a simple full solution (one-step job) for the client's request. 

* Using the original DDL+DML the full solution seem to use the same resource as the first step solution in the original post. As this is not a real case, and I do not have the full description of the original client request or any information regarding the client hardware, software, SQL Sever versions & edition, This blog will not assume that this is a better solution, but just come in order to give another solution, using different approach.

By ronen ariely on 14/12/2015 10:38

I see in the forum this question raised all the time, and yet the solution that people get usually based on looping and complex math, while there is a simple and much better solution as shown in this code. In this short blog I will wrote a simple and VERY fast solution to convert Decimal number to Binary number, Decimal number to Hexadecimal number, and vise versa without using any loop. My solution for binary base is based on using BITWISE.

By ronen ariely on 22/10/2015 09:02

If the error message "udevadm trigger is not permitted while udev is unconfigured" raise during booting, then there is a simple solution, which worked for me.

By ronen ariely on 22/10/2015 08:42

During simple automatic update the Grub update freezes and stop responding. This issue raise in several forums like the MongoDB were I have seen this question, and recently I experienced it myself. Therefore, instead of writing the solution procedure in each question again and again I will post here the solution that worked for me.