ASP.NET Web API and ASP.NET MVC 5 are more difficult for some developers to host on IIS for development purposes. We know to just press the Windows key + R and type inetmgr. Afterwards, go to Visual Studio. Right click on the project properties and under the Web tab, create the virtual directory for our Web app and Web API easily but with the arrival of ASP.NET MVC 5, latest architecture and tools there are some difficulties to host on IIS for the development purposes.

I've been holding off the installation of Visual Studio 2017 for as long as I could; mostly in part due to ongoing projects where I can't risk something not working. However, curiosity has taken hold and the installation has begun. Therefore, I dedicate this short article to those of us who are, or going to continue to, hold off installation until more information is made available on stability and general operation.

This tutorial on React js is the first in a series of articles we will posting. We will be adding links to other React.js tutorial very soon. JavaScript libraries and frameworks like React js have taken the world of full stack development by storm. Because of the capabilities these frameworks provide, the JavaScript language in itself has been getting a lot of attention and as a result, is now being used in non-browser platforms like server, mobile apps and devices. The usage of the la...

Cascading parameters is a very routine and basic requirement of any report. While using SQL Server Analysis Services (SSAS) Multi-dimensional mode as the data source, MDX has to be used as the data source. MDX is a very sophisticated query language and developing the query logic to accept parameters can be complex. In this tip, we will look at a very easy method of how to add cascading parameters in a SSRS report using SSAS as the data source and MDX as the query language.

This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the initial size itself was huge and when they tried to shrink the TempDB database, it was not doing anything. Here was the message in SQL Server Management Studio query window.

Angular Batarang is a tool for watching the scope of Angularjs (Angular1.x) Applications .Batarang is a Chrome extension and you can download this extension from Chrome Web store. Your Angular Application contain lots of forms. I highly recommend you use Batarang for watch scope and form validation status.

We’re still looking for a few more speaker submissions for Southwest Fox 2017. If you have something to share with our developer community, read the Call for Speakers and then use the Submission site to send us your ideas. Please let us hear from you by next Monday, March 27.

I like PowerShell's comment-based help, it is very useful when you want to check the cmdlet basic information, such as basic function descriptions, parameters or sample examples. All this information is extracted from the comments in the cmdlet source files and use get-help to retrieve the information.

Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest is continuously listed as long running SP. Well, the good part was that it was not taking too much of the resources. The page read and write were pretty low and the SP was not blocking anything at all. Initially we decided to ignore this SP as there were quite a lots of other things which we needed to take care to get maximum performance of the server.

This article is intended to help you create your first node.js application with the Visual Studio 2017. Node.js is a JavaScript based platform, built on Google’s Chrome V8 engine. It’s not a JavaScript library, rather, it’s a server side runtime environment which runs JavaScript code. It has following features.

Writing lots of code can become quite tedious. It can also become frustrating at times, especially when you are looking for a Visual Studio feature that either doesn't exist or which you don't know about. This article aims to introduce you to some of Visual Studio's newer tools to make your coding and debugging a bit more productive.

This article will describe all aspects of NUnit starting from Test Driven Development (TDD) to converting it to data driven test. I will also show you how easy it is to compute the code coverage in Visual Studio 2015. I have briefly mentioned NUnit test with Visual Studio in one of my previous articles (Code Quality Tools in Visual Studio 2015).

SQL Server 2016 introduced many new features and improvements for all its products, and Master Data Services (MDS) is no exception. In the past year, over a dozen tips have been written about the changes for MDS. This tip - which continues from part 1 - gives a comprehensive overview of all the new features and links back to the original tips for more details.

If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue related to retrieve data.

My last post on ASP.NET Core and IIS generated a lot of interest and also a lot of questions and discussion in the commment section to warrant a follow up post. In this post I address a few common themes that keep coming up in regards to IIS hosting of ASP.NET Core applications.

SQL Server 2016 has introduced the integration of the popular data science language R into the database engine. R is a powerful language and provides many packages from the community so as to create models and generate predictions using the SQL Server data.

As a part of my passion, I try to help people in fixing simple issues and explain the behavior by looking at logs. Here is an email from my friend about Availability Group Missing or Deleted Automatically. Pinal, We need your services again to help us understand the cause of a strange issue.

There are many choices of articles, blogs, and forums that discuss how often Web sites require redesign. If you're wondering, the consensus seems to be two to three years. However, the discussion does not include the technology used to support and deliver the actual digital experiences visitors to those websites expect. Instead, the focus tends to be on the creative side of the equation.

In the first of this series we looked at TSQL tuning for temp tables, table variables and the Union command , we now turn our attention to User Defined Functions – either Table-Valued Functions or Scalar Functions. A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU

How many times have you worked with SSMS (SQL Server Management Studio) while having multiple connections to different Servers? My answer would be - almost all the time, as I have to connect to local database, staging database, UAT database, and sometimes the PROD database or backup server and sometimes depending upon the kind of application, it may grow to 5-6 connections.

The Database Administrator (DBA) is usually a technical professional who supports one or more hardware and software platforms that provide application solutions. However, technical details such as SQL tuning, hardware and software upgrades, and database designs tend to be tactical in nature. It is essential that the DBA also maintain a strategic outlook in order to get ahead of potential problems. This article addresses two of these strategies: knowing application breaking points and preparing ...

Since I moved our blog from HTTP protocol to HTTPS, there are plenty of questions I have received from various users to share the steps to secure your site with HTTPS. After receiving so many requests, I have decided to build a simple, complete tutorial to move WordPress site from HTTP to HTTPS.

I have administrator responsibility for some legacy SQL Server databases that I did not create and do not use much personally. I have been charged with listing the SQL Server foreign keys within these databases. Can you present some different approaches to developing this kind of information as well as ways of validating the information generated by the different approaches?

Introduction In some situations, we will get a requirement like converting a number into words. Example 568 = Five Hundred Sixty Eight only. Here, I will explain how to convert this numeric value to words (In Indian Currency format), using C#, not only whole numbers but also with decimal and negative values. Example 568.25 = Five Hundred Sixty Eight and two five paisa only. -25 = Minus twenty five only.

Recently I started down the path to learn Elixir and the Phoenix framework. This is a language and framework I intend to use quite a bit, so my goal is to get from “barely able to read it” to “able to ship readable, idiomatic, testable apps”. Having learned a fairly large number of languages, libraries, and frameworks over the years, I know the best way I learn is by combining reading or videos with writing and debugging actual code (some intersection of chasing book smarts + street smarts)...