This article explains, with detailed examples, how to use PIVOTING to take maximum advantage of queries making use of GROUPING SETS. Besides, ROLLUP and CUBE operators will be analysed as well. We'll see throughout the article that it's very easy to get simple, practical and powerful queries by integrating all of them in the same query.

I think that master these operators contributes to make cleaner code and save a lot of time when developing. Thus, I hope this article will be useful to both improve your knowledge and develop faster cool queries for your reports, forms or views.

Exploring Azure Virtual Machine networking settings for ICMP, RDP and SQL Server

In this post, I will be exploring the Azure Files Storage Services to manage files by using the SMB (Server Message Block) protocol. The most relevant part of the use of this service is that you can attach it to a virtual disk on your Windows machine to deal with files as it were an external disk.

This post is a quick guide to start dealing with Azure BLOB Storage Services. I will create a simple .Net Console Application to upload and download a simple file within BLOB Storage Services. Before going ahead, I highly recommend take a look to How to create an Azure Storage Account. It is not complex but mandatory before interacting with BLOB Storage Services.

This post is a quick guide to start dealing with Azure BLOB Storage Services. I will create a simple .Net Console Application to upload and download a simple file within BLOB Storage Services. Before going ahead, I highly recommend take a look to How to create an Azure Storage Account. It is not complex but mandatory before interacting with BLOB Storage Services.

Row-Level Security let us control access to data at row level for any SQL Server table based on users, roles, membership or working context. It tremendously simplifies and improve the options we have to secure, filter, implement restrictions or eventually deal with our data over certain scenarios. What is most relevant for me is that all the security policy can be set centrally at a database level preventing developers from taking care of adding custom where clauses to enforce security. It makes the management of data much more reliable and maintainable.

Based on previous posts and playing a little more with some useful JavaScript functions, I came across a very inefficient way of determining whether a given user was member of a role based on its provisioned list of roles

A simple way of achieving it is by using the map() and join() JavaScript functions:

The map() method creates a new array with the results of calling a provided function on every element in the calling array.

The join() method creates and returns a new string by concatenating all of the elements in an array.

This post aims to come up with some useful workaround to filter data in Telerik Kendo Grid over multi-select column fields bound to complex data by using multi-check-boxes filters.

While I was dealing with some potential vulnerability issue affecting to some of "my" MVC 5.0 application in .Net Framework 4.5 and coming from a wrong management of user roles, it turns out that I didn't remember clearly how role management was related to User principal or even, where roles came from in order to IsInRole method were able to work properly to check roles for users. So, let me add this post as a reminder to clarify and shed light on this.

In a nutshell, the provider model is a design pattern largely used by Microsoft components for allowing an application to make use and choose from multiple implementations of a given contract based on the settings of a configuration file. So, for instance, management of user membership or roles are usually carried out by means of classes based on this pattern (see MemberShipProvider or RoleProvider classes). This way, the application can choose the default provider for dealing with membership or roles, add or remove providers, etc. in a declarative way. It brings a lot of benefits for developers as they can plug new components easily without refactoring code.

This article explains how to create a simple Multi-Language ASP.NET MVC 5 Web application. The application will be able to deal with English (United States), Spanish and French languages. English will be the default language. Of course, it will be very easy to extend the solution for including new languages.

Some months ago, I came across an unexpected rare issue when dealing with AJAX calls in a MVC Web App that was making use of OpenID Connect (OIDC) protocol to provide authentication on Azure Active Directory (Azure AD). This MVC Web App was set up to call several Web APIs protected by Azure AD authentication too.

You can find more information about this basic scenario made up of a Web App connecting to a Web API here. More in detail, Web APIs were employed in a simple straightforward way as if they were microservices, but this specific point is only for further information, not related to the main issue.

There are times you want to get comma (or another character) delimited values from a given field in a SQL table. There are several ways of achieving this goal but I am going to show you a simple manner I usually employ to obtain the desired format.

In my previous article Simple way to get comma delimited values from a field by using SQL I showed how to get a comma delimited string from a field in a SQL table. But, there are other times you want to get the same but the other way around, that is, converting each element in a comma (or another character) delimited string variable into a row value in a table. How to get this, then?