Learn About SSMS Output WindowMar 17, 2018. In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases. SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually did respond and life was good again.

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.

Host An ASP.NET Core Application As A Windows ServiceMar 15, 2018. ASP.net core applications can be hosted using various way such as Hosted with IIS, Hosted with HTTP.sys Server, etc. This article is to about hosting ASP.net core application as Windows service. Windows services feature is available only with Windows platform. This is one of the way to host Asp.net core application on Windows platform without using IIS.

WPF - Data Storage Using SQL ServerMar 15, 2018. For any development domain, be it mobile or web or desktop or service-based, data storage is an essential component whether it is done on the server side or the client side. WPF application is a client-side application and it also supports many data storage resources which depend on the business requirement or business choice.

Four Rules Of Right When Running A QueryMar 13, 2018. Earlier this year, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Monica Rathbun (B|T) and her topic for the month was “SQL Server Bad Habits in Configurations, Security, and Code”. It was a fun and entertaining way to spend an hour over lunch. Plus it helps to get you engaged with the SQL Server community, which is never a bad thing.

Using SWITCH On A Single PartitionMar 12, 2018. Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar with partitions in SQL Server, you can “divide” up a table into different segments or partitions. Often this is found in large tables (think millions/billions of rows) in order to quickly and efficiently move data around. Moving partitions around is a meta-data operation which is what makes it so efficient.

How To Insert Bulk Records Into SQL Server Using XML Data TypeMar 11, 2018. Sometimes, there is a need to insert bulk records into a database. In some cases, we have multiple unique records and that all needs to be inserted into the database. Instead of hitting the database for each record, we need to insert bulk records into database.

Certificate Pinning In Xamarin.FormsMar 08, 2018. Securing communications between applications and services is extremely important, and mobile apps are no exception. Even if you use an encrypted channel based on HTTPS, you should never completely trust the identity of the target. For example, an attacker could easily discover the URL your application is pointing to, and put a fake certificate in the middle of the communication between an application and the server, thus intercepting the communication.

Azure Logic Apps - Hello WorldMar 05, 2018. Logic Apps are a relatively new feature of Microsoft Azure that makes it simple to build complex workflows using one or more of the over 200 plus different connectors. Since the Logic Apps are serverless, you do not need to worry about server sizing. The platform will scale to meet your demand, and better yet, you&#39;re only charged for what you use.

O365 Consuming Azure PAAS SQL DB Through BCSMar 03, 2018. This document explains the steps to configure BCS using Office 365 that can pull data from Azure PaaS SQL DB and also to configure firewall IP ranges and network possibilities.

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

What Is Date Correlation Optimization?Feb 28, 2018. OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do a little research. Who knows, it may actual help me solve one of the many problems I run into day to day for clients.

Learn About MEAN StackFeb 26, 2018. MongoDB, Express.js, AngularJS, Node.js are abbreviated as MEAN, these are application development packs all by Javascript. In this sample, we are going to use MSSQL Server instead of MongoDb.

Demystifying Azure Logic AppsFeb 25, 2018. This article explains what Azure Logic Apps are, various designing and deployment options available for Azure Logic Apps, along with the various building blocks of Azure Logic Apps.

What Does This Little Check Box DoFeb 21, 2018. Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty handy. Use query governor to prevent long running queries.

How To Fetch Data From Task List Using Rest For Workflow History In SharePoint OnlineFeb 20, 2018. I got a requirement to make a history form for a workflow. For that, I had to fetch the data from a task list. We can use Rest API, SP Services, or any other methods for this kind of task. So, I chose REST API for the same. Now, the question is, what will be the scenario? Because Workflow status columns of Assign to and Modified Date are not available in the normal list. Then, I learned that we can fetch it from the task list or history list as in workflow all the information resides in Task list &amp; History List.

A Beginners Guide To Microsoft BizTalk Server - Part TwoFeb 16, 2018. This is the next part of the BizTalk Server article series. Here, we are going to explain why BizTalk is still the number one choice for ian ntegration tool. BizTalk is considered the best tool for integration. We will be seeing the list of some companies which are using BizTalk as an integration tool and the future of BizTalk developers.

Download User License Information For PowerApps And Microsoft FlowFeb 16, 2018. PowerApps is one of the services available in the Office 365 environment that enables us to create apps or forms for business and other uses without coding experience. We can connect against external data sources like SQL, SharePoint, Salesforce, etc... to develop an application. PowerApps has its own data source called Common Data Service.

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.

A Beginners Guide To Microsoft BizTalk Server - Part 1Feb 15, 2018. BizTalk Server is a middleware product from Microsoft that helps to connect various systems together. Let’s take an example: If you look at any modern organization it will run its operations using a variety of software products. SAP for their ERP needs, Salesforce for their CRM needs, Oracle for their Database needs, + tons of other home-grown system like HR, Finance, Web, Mobile etc.

SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.

Lightweight Raspberry Pi 3 Web Server Using PHP And HTMLFeb 13, 2018. This article demonstrates how to make a lightweight Web Server for the home using Raspberry Pi 3 and Python 3 IDE. The Pi can even handle Web Server so if you want to launch your own website with a proper back-end you can easily do it. This web server is a small amount of traffic and development purposes.

Microsoft Operations Management Suite (OMS) - A Beginner's GuideFeb 13, 2018. Operations Management Suite (also known as OMS) is a collection of cloud-based services for managing your on-premises and cloud environments from one single place. Rather than deploying and managing on-premises resources, OMS components are entirely hosted in Azure. In simple words, what basically happens is that OMS goes and talks to different servers, applications in your environment, collects information about how they&#39;re doing, consolidates this information in the form of nice colorful graphics and searchable records, after that presents it to you in one single, convenient place, and it doesn&#39;t matter where your servers or applications are running, Azure, AWS, on-premises or which operating system they&#39;re running on, Windows or Linux, it just works. Configuration is minimal, and you can be up and running literally in a matter of minutes.

How To Get Started With Always Encrypted For Beginners - Part TwoFeb 12, 2018. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or through our applications. You’ll be surprised to see how easy it is.

Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.

SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).

Email Directly From C# .NET On Azure With No Mail ServerFeb 05, 2018. One of the background parts of most systems I write involves messaging of some kind ... more often than not, the default is email notification of one thing or another. When I need to carryout large scale mail-outs I always use one for the major Azure services, but when I only need adhoc mail operations or low volume, I use a combination of an SMTP Client and a DNS MX Lookup.

Automating SVN Check-Ins And Building A Project Via JenkinsFeb 05, 2018. A few weeks back, while sitting with my team, I learned that they run a Jenkins job which has to execute the automation scripts using the robot framework, daily around 1:00 a.m. The primary purpose of the job is to place all the necessary files and folders over the node machine of Jenkins (after copying them from the machine pointed as master on Jenkins), execute those scripts accordingly, generate the reports, and finally copy the output files back to the master machine to analyze the logs for the overall reporting and analysis purposes. This whole efficient job starts with a slack manual step which was enough to tag this activity &#39;not fully automated&#39; because they had to place the updated work regularly on the specified path over the master machine before leaving the office (this includes taking the updated code, files, and automation scripts, building the project to take the DLLs etc.). This may sound tedious but more than that, there is no sense to do it manually.

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.

How Can You Integrate A JSON Framework With iOSFeb 01, 2018. JavaScript Object Notation, or JSON in short, is commonly used for representing structural data and data interchange in client-server applications, serving as an alternative to XML. It has grown in popularity as it is simple to use and human-readable. It is technically a part of the JavaScript language and provides a way to serialize JavaScript objects. It is supported in a wide variety of programming languages. A lot of the services used every day have JSON-based APIs.

Office Online Server For SharePoint 2016Jan 29, 2018. SharePoint portals are mainly used for document collaboration. End users add and manage documents in SharePoint. Viewing and editing the documents in a browser experience is a more preferred option for everyone rather than downloading a copy of document and working on it.

Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.

SharePoint Modern UI - Column FormattingJan 23, 2018. Microsoft is focusing more on Modern UI in SharePoint online. Microsoft is releasing new and very nice features to Office 365 on a frequent basis. SharePoint in its online version is also experiencing the addition of new useful features.

CRUD Operation With Angular 5 HTTP Client And ASP.NET Core Web APIJan 23, 2018. HTTP is the messaging system between the client and the server-client which sends the request and server responds with the proper message. Angular HTTP client is the toolkit which enables us to send and receive the data over the restful Http endpoints.

CRUD Operations In SharePoint Using REST API - CREATE OperationsJan 18, 2018. REST API is a powerful CSOM concept that can be leveraged in SharePoint for converting sophisticated business designs into working and efficient SharePoint Artifacts (Add-Ins, CSOM solutions, etc.). REST does not require any separate references for its working unlike other frameworks (SPservices!)

Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.

Identity Server 4 With ASP.NET Core 2.0Jan 16, 2018. OAuth 2 provides several flows or grant types for various use cases. I personally group them into two categories; flows that require user interaction with authorization server and flows that don’t.

An Introduction To Q#Jan 15, 2018. In this article, I will be explaining about Q# - the new programming language introduced by Microsoft for quantum computing. We will understand the data type, expressions, and statements of Q# with the help of code snippets.

Bulletproof Disposable Types In .NET CoreJan 14, 2018. Whenever I do code review on .NET projects, hands down the number one issue is developers not calling .Dispose() on disposable objects. Ever since .NET was released, I have been preaching how important this is. If not done properly, it’s most likely to create virtual memory issues that will eventually cause the application to stop and possibly freeze server or users’ computer.

How To Take Screenshot Using jQuery And PHPJan 10, 2018. Hello all, today in this article we will learn how to take screenshots using jquery and php. So, basically we will create a webpage and in the webpage we create a button which will take screenshot using the help of library called html2canvas . So once we take the screenshot we will save the screenshot in a json file using the help of jquery, javascript and php. We will be using for jquery and javascript to handel client side request and php to handel server side request. We will also learn about file handling using php.

How To Remove And Create User Profile Service Application In SharePointJan 09, 2018. The purpose of this article to is to delete an existing UPA service from the SP server and create the same from scratch. As we know, there are two ways to configure or delete UPA server, Using UI and SharePoint PowerShell. We are going to delete and create UPA using UI.

Say Hello To Swift GenericJan 08, 2018. If you have not been introduced to Swift generic yet, then definitely you are missing one of the most beautiful things. In this article, we will try to understand generic in a simple way and we will see how we can beautify our Swift codes with generics.

Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.

R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don&#39;t, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.

ASP.NET Core 2.0 Cookie AuthenticationJan 02, 2018. Cookie Authentication allows developers to hook into events at various lifecycle stages of the authentication process. For instance you could log successful sign-ins using OnSignedIn or use OnValidatePrincipal (runs on every request) to invalidate the user (e.g. if you want to force sign-out).

A Potentially Dangerous Request.form Value Was Detected From The ClientDec 26, 2017. This error can occur in any page, but mostly a client receives this error while entering a new or modified item / product in admin panel of any portal because in admin panel we mostly write html code to fill in blanks, and also to display the product feature in ordered or unordered list.

ASP.NET MVC 5 - Buttons In Datatables jQuery PluginDec 26, 2017. Table view is one of the most important and basic forms of presenting data on a web page. However, adding action to each row is equally important simply because action for each row leads to different results. Jquery Datatables plugin is one of the most used plugins, as I have demonstrated its integration in ASP.NET MVC5 - Datables Plugin Server Side Integration in one of my articles.

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.

Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB

Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.

Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner.
Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.

An Introduction To Quantum ComputingDec 13, 2017. In this article, I am going to cover some of the basics of Quantum computing and also set up an environment on our local machine with Visual Studio 2017 to get started with Quantum programming.

Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.

How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.

Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.

Tips And Best Practices To Improve ASP.NET Web Application PerformanceDec 01, 2017. This article suggests you a few tips to improve the performance of an ASP.Net application. There are many more things which may ensure a better performance and faster response time for a web application. I am discussing only a few of the best practices that will help you avoid some unwanted performance hitters from your application. So, you will have a more light weight application which runs quicker and gives a better response time.

Building SPA With Angular And ReduxDec 01, 2017. In the current application development era, Single Page Application (SPA) is a great feature to develop modern web based applications. In these SPA applications we tend to move the data level dependency from the server side to browser level as much as possible to improve the application performance. So as much as application level functionality moves to the browser level the amount of the data and way to manage these data is also increased. Modern SPA application frameworks like Angular and React use component based architecture that divides our application into small-small sections. Each component contains its own HTML page, stylesheet and its own state(data). This approach is very efficient because it divides our application into small sections that we can manage very easily and also we can reuse these components in our application.

Difference Between MySQL DATETIME And TIMESTAMP DataTypesNov 29, 2017. A simple question that may come to one&#39;s mind while working with MySQL is &quot;Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let&#39;s check those things out with the help of a small example.

A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.

Getting Started With Kotlin - BasicsNov 29, 2017. Google announced Kotlin as an official language for Android Application development in Google I/O 2017.Kotlin is a statically-typed language, developed by JetBrains and Open source Contributors in the 2011, that runs on JVM(Java Virtual Machine) and is compiled to JavaScript source code. It is very suitable for server-side application development with full compatibility of Java frameworks. You can use multiple frameworks like - Spring, Vert.x, Ktor etc. for web application development.

How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don&#39;t use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and &#39;server-less computing&#39; are two technologies that most developers are going to have to embrace in the next short few years.