Hide And Group Columns In SSRS Using A ParameterMar 16, 2018. Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I&#39;ve embedded some links to MSDN to help you along the way.

SharePoint Custom Search ScriptMar 14, 2018. This article will explain the PowerShell script searches for files within Document libraries in SharePoint (farm level, site collection level, web level etc.) based on the search parameters you provide. It can also be used for searching in SharePoint for any files with the specified extension. The results are returned in a .CSV format.

Delete SharePoint List Items In Browser ConsoleMar 05, 2018. This article demonstrates how to delete SharePoint list items in browser console using REST API without writing any code in the SharePoint site. To delete list items just copy paste the code in the console window of the browser and then call the function by passing the List name whose items have to be deleted.

Execute SQL Server Stored Procedure With User Parameter In Power BIFeb 28, 2018. Sometimes there is a situation in which we need to get data by consuming SQL Server stored procedure. SQL Server stored procedure has parameters which we need to pass dynamically.
Power BI provides a functionality to execute Stored Procedure using Managed Parameters.
During this article we will talk about,
• How to create Manage Parameter
• How to pass manage parameter to a Stored Procedure
• Invoke Query Result and load data to Power BI Desktop

How To Get Started With Always Encrypted For Beginners - Part ThreeFeb 15, 2018. A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the project was to prevent the DBA from being able to view salary information, while still allowing the application to function without issue.

How To Sell Your CLOUD ServicesFeb 09, 2018. While responding to this question, keep in mind that you are requested to talk about additional benefits over and above the cloud services from your competition. For example at that time, the key difference which MS Azure services had was per minute billing as compared to other cloud providers. Then probably there were more functions and features available in the overall cloud dashboard as compared to others.

Basics Of Angular And Its Versions - Part SixFeb 01, 2018. In this article, I am going to discuss more about async/await support. This async/await feature officially announced in TypeScript 2.1. We can say this is one of the very import feature in TypeScript 2.1 release.

Introduction To Serverless Computing Using Azure FunctionFeb 01, 2018. Serverless Computing is driven by performing some action as a response to the specific event or trigger. While building serverless apps you don’t need to provision a server or infrastructure. Billing is based on resources consumed or actual time code is running. There&#39;s no need to build app to run the code, no need to set up infrastructure, no need to setup deployment infrastructure. Just focus on code.

View Customization With JavaScript In Dynamics 365Jan 24, 2018. You need to write a JS function with 2 parameters, when you’ll add it to view, first parameters will recieve rowData(value with metadata shown below for one cell) and userLCID(i.e. language code fof current user). Based on those 2 inputs you can decide what icon to show. And name of this function goes in Function Name: field in View’s property.

Model Driven Forms In AngularJan 15, 2018. I have opened the same solution I have explained in my previous article, and i have app.component.ts with onsubmit function and I have html elements in app.component.html.

Google Chart With ASP.NET Core And Visual Studio CodeJan 13, 2018. The Google Chart API lets you dynamically generate charts with a URL string and embed these charts on a web page, or download the image for local or offline use. The Google Chart Tools enable adding live charts to any web page. They provide advantages such as a rich gallery of visualizations provided as image charts and interactive charts and they can read live data from a variety of data sources. Users embed the data and formatting parameters in an HTTP request, and Google returns a PNG image of the chart. Many types of chart are supported, and by making the request into an image tag the chart can be included in a web page.

Setup React App Using Node.js, Webpack And TypeScriptJan 09, 2018. React is one of the leading technologies that is used to create single page applications(SPA). Some others are Angular and Vue.js. In this article we will learn how to set up a React project using Webpack, Node.js and Typescript.

Statistical And Standard DAX Functions In Power BIJan 06, 2018. This article describes the Power BI DAX functions and their definition, overview, basic syntax and use. This article specially describes the statistical and standard DAX functions of Power BI.

Hello World With TypeScript 2.0Jan 02, 2018. TypeScript is a language which is a super set of JavaScript language. It compiles the code written to plain javascript code. So all the correct javascript code is valid in TypeScript. Apart from that TypeScript provides extra features also, which is very useful for writing good code.

Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.

How To Create Azure Function App To Delete SharePoint Online List Using CSOMDec 19, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer Azure Functions for more details.

How To Create A Simple Azure Function App Using C#Dec 18, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of your choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer to Azure Functions for more details. In this article you will see how to create a simple Azure Function using C# that will run whenever an HTTP request is received.

Paging In ASP.NET Core 2.0 Web APIDec 11, 2017. Paging information; i.e., page number and page size, is usually received via query parameters. The POCO PagingParams simply holds this information and passes it to service (or repository).

Filtering In ASP.NET Core 2.0 Web APIDec 10, 2017. Filtering information is usually received via query parameters. The POCO FilteringParamssimply hold this information and passes to service (or repository).

Callback Concept And Events In Node.jsDec 06, 2017. Hello friends, today I explain you about callbacks and events in Node JS. People who are new to Node JS please learn previous articles NodeJS - Getting Started With Some Basic Functions .

How To Schedule Timer-Based Callbacks With ExampleNov 16, 2017. In this article, we will look at how the JavaScript timer functions - settimeout, setinterval, and Cleartimeout -- are used to schedule and cancel timer-based Callbacks, with a simple example of stopwatch program.

Passing Parameters To Middleware In ASP.NET Core 2.0Nov 15, 2017. I discussed in an earlier post that it is good practice to define middleware in a separate class and add to the pipeline using extension methods. We may also need to pass information to our middleware classes though and I’ve come across two patterns for this when digging into ASP.NET Core source code and other samples online.

Using Optional Query Parameters With Microsoft Graph API - Part TwoNov 14, 2017. When you fire an API call to MS Graph, it will return the JSON result with all the properties. You may not need all the properties of a result set always. When you want MS Graph API to return only certain properties, then use $select parameter to specify which properties you want in result set.

Creating Azure WebJob To Access SharePoint Using Typescript And Node.jsNov 14, 2017. Create a new folder in the solution by the name &#39;src&#39; and create index.ts file inside the folder. In this folder we will keep all the source files which will get executed when the Job runs. Remember to keep the index.ts at the root of the src and all other files (if any) keep them in the folder otherwise the job will fail.

ASP.NET Core 2.0 MVC Model BindingOct 30, 2017. In a previous post on Routing, I showed how MVC maps URLs to Controller and actions to execute. We touched on the topic of the model binding mechanism through which MVC binds routing template tokens to action parameters.

Angular Pipes With ExamplesOct 29, 2017. The first parameter &#39;USD&#39; is currency type which can be of INR, USD or any currency type in the world. The Second parameter &#39;true&#39; is a Boolean indicating whether to display currency symbol or not .By default it is false and, if we change it to true then the symbol will be displayed.

How to use NPM Install (The Command) behind Corporate Proxy ServerOct 14, 2017. When you want to install packages for angular, angular CLI, typescript etc. via NPM using Command Prompt and you are working in an office environment where everything runs behind a corporate proxy server, you will most probably get the below exception.

Using Optional Query Parameters With Microsoft Graph API - Part OneOct 12, 2017. While Microsoft already has all the documentation to cover all its technology, in this article I will try to explain these ODATA query parameters with some different angles and usage scenarios. I’m sure you will enjoy reading this article and learn something new.

Angular Components (With Examples)Oct 12, 2017. A Component is nothing but a simple typescript class, where you can create your own methods and properties as per your requirement which is used to bind with an UI (html or cshtml page) of our application.

Create Simple Azure FunctionOct 07, 2017. Azure functions allow up to run the code in a server-less manner. That means we do not have to create the VM to host the running code nor do we have to create a web application and publish code to web applications to run continuously.

Default(T) In GenericsSep 27, 2017. Default represents default value of T parameter in generics intructions. In several cases, the default keyword is an absolute unknown and we think it’s unnecessary or its functionality is null. There are many development moments with the generics classes where the default keyword can be useful.

Understanding And Controlling The Windows Mixer APISep 27, 2017. This tutorial is going to be a three part introduction to playing and recording audio files using winmm.dll (a WinAPI). This first part is about understanding, opening and controlling windows mixers. The other tutorials will be about recording and playing audio .wav files. We will not be working with .mp3 (you can see the documentation to understand those functions.)

New String Function In SQL Server 2017Sep 06, 2017. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.

Platform Mobile Analytics Tools For Efficient App ManagementSep 04, 2017. Analytics is crucial for an effective app management. Modern app analytics tools let you know whether your app is functioning as it should or there is a need for upgrading. Nowadays, the selection of these tools is impressive. The choice of the right tool helps not only speed up your return on investment for, let’s say, the cost of outsourcing app development or any other development expenses but also arrange future business outgoings.

More Details About Razor Pages In ASP.NET Core 2.0Aug 27, 2017. I built a simple web app to show you the new feature named Razor Pages in ASP.NET Core 2.0 . However it doesn&#39;t contain some useful and basic functions. So I decided to write one more article to show more details of Razor Pages.

Round Image In Xamarin.FormsAug 25, 2017. In this article we are going to display a rounded image in Xamarin forms PCL application. In Xamarin forms there is no default function available to make an image round. So, we need a plug-in for this.

Building Serverless Mobile App With Azure Functions Using Xamarin.FormsAug 20, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. We can create, execute, and test our custom logic function without creating a VM or web applications and also without needing to install any software or infrastructure to run the function. In this article, we&#39;ll learn how to implement azure functions and directly call through HTTP from Xamarin Forms Application

Normal Equation Implementation From Scratch In PythonAug 19, 2017. Normal equation is a more closed-form solution of figuring out the value of a parameter that minimizes the cost function. It&#39;s called closed-form solution in the sense that it gives the result directly though the equation.

Swift Programming - Zero To Hero - Part ThreeAug 17, 2017. Statements are the building blocks of any program. We can perform any function with the help of statements, such as checking values or declaring variables, calling methods, or even creating objects.

Custom Model Binding In ASP.NET Core MVCAug 17, 2017. Model binding in MVC maps HTTP request data to the parameters of the controller&#39;s action method. The parameter may either be of simple type like integers, strings, double etc. or complex types. MVC binds the request data to the action parameter by parameter name.

Getting Started With Microsoft Azure Functions Using Visual Studio 2017Aug 17, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. We can create, execute, and test our custom logic function without creating a VM or web applications and also without needing to install any software or infrastructure to run the function.

How To Create And Test Azure Functions Using Azure PortalAug 15, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. We can create, execute, and test our custom logic function without creating a VM or web applications and also without needing to install any software or infrastructure to run the function. In this article, you will learn about create and test azure functions using azure Portal.

Getting Started With Azure Functions Using Azure Free Trial AccountAug 09, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. Azure Functions let you develop serverless applications on Microsoft Azure. In this article, you will learn how to create Azure Functions without creating an Azure account.

Introduction To Sweet Alert Library In ASP.NET MVC RazorAug 08, 2017. Sweet Alert is a library that acts as a replacement for the JavaScript’s alert() function. This shows very pretty model windows. It’s a library that has no dependencies, and is made from a JavaScript file plus a CSS file.

Routing In Angular 2 With TypeScript And Visual Studio 2015 - Part OneJul 29, 2017. In this article, we are going to learn how to implement routing in Angular 2 with an example. Routing is a concept which helps users to navigate from one view to another view of the application. Similarly, routing in Angular 2 helps users to navigate from one view to another view depending upon the URL which user enters in the browser.

Using PowerApps - Authoring Made Simple And PowerfulJul 16, 2017. I am glad to bring you up with the latest change in the PowerApps Studio, in the latest version (2.0.660), the enhanced capabilities are showed and discussed in this article, PowerApps Studio had changes in the Properties Panel, Viewing data with the edit form, global variables, and the reset function.

Arithmetic Operation In ASP.NET MVCJul 16, 2017. In action result method I passed one string parameter named command and using this command I assigned some arithmetic operation string value and based on that the operation will be performed.

React Tutorials - Day Five - RouterJul 10, 2017. Today we learn about the routing in React, we learn how to setup routing configuration and also learn how routes work in React. If we want to create a single page application then we need the routing to redirect from one page to another and read the route parameters. To perform the routing in React we should have to install the “react-router-dom” packages.

Simulate SharePoint Online Timer Jobs Using Azure FunctionsJul 05, 2017. SharePoint Server provides native Timer Jobs that inherit SPJobDefinition class to run at regular intervals defined in the SPSchedule object. This way we can create solutions that have to be iteratively run to process logic at regular intervals. However, in case of SharePoint Online Native Timer Jobs cannot be used.

ECMAScript5 Features - Strict Mode, JSON And MoreJun 28, 2017. Strict Mode is a new feature in ECMAScript 5 that allows you to place a program, or a function, in a “strict” operating context. This strict context prevents certain actions from being taken and throws more exceptions (generally providing the user with more information and a tapered-down coding experience).

When To Perform A Search Full Crawl In SharePoint 2013Jun 24, 2017. Search is indeed a mission critical component in SharePoint 2013 and it’s very important that it functions properly so that you get the desired results. As we all know, the search results and their relevancy is directly proportional to how often your content sources are crawled and what sort of crawling you’re running in your SharePoint farm.

Writing Complex Queries Using LINQ And LambdaJun 22, 2017. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ &amp; Lambda expression which consist of joins / groupby / aggregate functions