Windows 2012 Hosting - MVC 6 and SQL 2014 BLOG

Tutorial and Articles about Windows Hosting, SQL Hosting, MVC Hosting, and Silverlight Hosting

SQL 2014 Hosting - ASPHostPortal.com :: Handling Divide BY Zero Exception

clock March 16, 2015 07:24 by author Ben

Some instances whilst undertaking Calculation within your query you got an error or exception "Divide by Zero" and some time you will have Output value Like NULL So how you can manage these Problem and Exception.

Use NULLIF -To Manage Divide by zero Exception
Use ISNULL -To Show some worth rather of NULL in your output

Below will be the total explanation
select 10/0

in case you run the above query it is going to throw an error

Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Now to be able to Resolve this we'll use Nullif function

 select nullif (10/ nullif (0,0),0)

Output NULL

Now it's going to not throw an error and your output will likely be null. Explanation: NULLIF function takes two arguments verify wheather they're equal or not if they are equal it'll return NULL as output
IF both expressions are not equal it is going to return the very first expression with identical data kind. Now inside the denominator it checked wheather 0 is equal to 0 The conditon was true it returned Null in denominator. now the expression was like

select Nullif(10/null,0)

now again it will check wheather 10/Null is equal to zero condition fails and you will get.

Output  NULL

Note : AnyNumber divide multiplied,added subtracted with NULL will Resultant to NULL only. Now how to use NULLIF and ISNULL in your Code or in TSQL to avoid exception and NULL Values. In the below code i have used nullif with ISNULL function. For this we will  Create a table

CREATE TABLE Test_NULLIF1
(
   col1            int   IDENTITY,
   col2      int   NULL,
   col3   int   NULL
);
INSERT Test_NULLIF1  VALUES(10, 20);
INSERT Test_NULLIF1 VALUES(NULL, 23);
INSERT Test_NULLIF1 VALUES(0, 18);
INSERT Test_NULLIF1 VALUES(NULL,75);
INSERT Test_NULLIF1 VALUES(300000, 21);
Go

If you will divide column 3 by column 2 for Row 3 it will throw Divide By zero Exception Run this query to generate error.. select col3/col2  from Test_NULLIF1  where col1 =3

Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

In order to handle this Use nullif function as explained in above example

select nullif(col3/nullif(col2,0),0)  from Test_NULLIF1  where col1 =3

Output NULL

Now You can Use ISNULL function after handling divide by zero exception to give a value when you have output like NULL
for eg like instead of NULL you want to show value like 0 or 1 or anything

select ISNULL(col3/nullif(col2,0),1)  from Test_NULLIF1  where col1 =3

Output 1

Explanation: ISNULL Function takes two argument check wheather first expression is NULL if null provide a replacement for that NULL in second expression it can be any value.
IN query ISNULL checked the first expression it was NULL so it replaced the NULL Value with 1,
and return output  as 1.

IN case if first expression is not null it willl return the first expression value only. .

Test IsNULL function with below queries

eg
Select ISNULL(null,2)

output 2

select isnull(3,1)--as first expression is not null so it returns first value i.e. 3

output 3

Best SQL 2014 Hosting Recommendation

ASPHostPortal.com

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offers SQL 2014 hosting starts from $5/month only. We also guarantees 30 days money back and guarantee 99.9% uptime. If you need a reliable affordable SQL 2014 Hosting, we should be your best choice.



SQL 2014 Hosting Tutorial - ASPHostPortal.com :: How to Add Data in SQL Server 2014

clock October 31, 2014 06:03 by author Ben

In the earlier publish, we all know about The Best Way to Create a Table in SQL Server 2014. We now possess a databases, and table, but no data.

There are lots of techniques of obtaining data into your database in SQL Server 2014. Listed here are the primary ones that come to mind:

  • Manually: Type data directly into your table rows.
  • Copy/Paste: Similar to the earlier alternative, but this 1 is in which you duplicate data from an additional source, then paste it into a table within your databases.
  • Import: You are able to utilize the Import and Export Wizard to import info from yet another source.
  • SQL Scripts: You can operate a SQL script which contains all info to insert.
  • Application/Website: Consumers update the database via an application or site.

Here's much more element on each of these methods.

Manually

We will make use of the Edit Top 200 Rows option to manually kind info directly in to the table rows.

Manually getting into data is Okay should you have only just a little little bit of data to enter. But it's a little bit clunky and might impractical if you have lots of information. Furthermore it doesn't actually match most company requirements, in which non-technical customers need to be capable of update the database.

In any case, here's how to manually enter data directly into the table :

  1. In the Object Explorer, right click on the table you wish to open, and select Edit Top 200 Rows:

  2. You can now start entering the data directly into your table.

Copy/Paste

You could use a similar method towards the above by copying from an additional datasource and pasting into your databases table. Of course, this may require which the resource table has the same columns since the destination table. Comparable towards the manual method above, this really is Okay to get a small quantity of information but not for any good deal of data.

Here's how to copy/paste into your table:

  1. Select all required records from the datasource
  2. In the destination database (i.e. the one you want to populate with data), right-click on the destination table and select Edit Top 200 Rows
  3. Select an empty row by right-clicking in the left-most column (it's more of a button to the left of your left-most column that allows you to select the whole row) and select Paste from the contextual menu:


    If you need to paste more than 200 rows, click the Show SQL Pane icon from the toolbar to display the SQL statement behind the 200 rows being displayed. Simply change the 200 to a larger number of rows as required.



    Note that this will work up to a certain extent, but you may encounter times where have so much data to transfer that you need to use another method.

Import

You are able to import data from yet another datasource. The top end result is comparable towards the copy/paste method (i.e. information is copied across to the location databases), but importing the data is a lot more flexible and could be more appropriate on several occasions. For instance, you can choose info from several views and tables, and you can compose a question on the fly to import only the data you'll need.

To import data, right-click on the database and select Tasks > Import Data... and follow the Wizard from there.

The SQL Server Import and Export Wizard can copy data to and from any data source for which a managed .NET Framework data provider or a native OLE DB provider is available. These include:

  • SQL Server
  • Flat files
  • Microsoft Office Access
  • Microsoft Office Excel

You may also commence the SQL Server Import and Export Wizard in the Windows Commence menu, from inside of SQL Server Data Tools (SSDT), and through the command prompt (by running DTSWizard.exe which you will locate in both C:\Program Files\Microsoft SQL Server\100\DTS\Binn or in C:\Program Files\Microsoft SQL Server\120\DTS\Binn or other location depending on your configuration and push letter).

SQL Scripts

In many circumstances, you'll find it much more efficient to run a SQL script which contains the data you need to insert. You'll be able to make use of the SQL INSERT assertion to insert just the info you specify inside the statement.

SQL scripts are excellent for inserting static/reference data (like say, countries/regions). They are able to be saved and run once more any time it really is required (for example on another database). Scripts aren't generally so excellent for data that continually changes (like customer particulars). You almost certainly would not be maintaining a duplicate of outdated data within a SQL script. But you'll find often exceptions. For example, you may use this kind of a script to populate a client table inside your testing/development atmosphere.

More about SQL scripts arising.

Application/Website

Most SQL Server databases are the backend data storage for any front-end application. Customers from the application are responsible for including data towards the databases (as well as editing it). As a result, many of the tables in your database will likely be up-to-date via the application. Within this situation, the applying is updating the database utilizing SQL scripts.

The main difference between these scripts and the kinds we mentioned over is the fact that, the scripts being used within the software will probably be dynamic. They'll accept data as a parameter that is handed to the script. Hence the user can enter say, an e-mail tackle in to the application, and unbeknownst to him, the application runs a SQL script that requires his e-mail tackle, validates it, provides it to the script, and when it passes each of the business/validation principles, inserts it in to the database.

These SQL scripts may be placed directly into your site code (PHP, ColdFusion and so forth), or they're able to be stored within the databases as Saved Processes or Views and operate only when the application says so.




SQL 2014 Hosting Tutorial - ASPHostPortal.com :: The Best Way to Create a Table in SQL Server 2014

clock October 24, 2014 07:04 by author Ben

Seeing as our database is actually a task-tracker database, let us get in touch with our initial table "Tasks". This desk will hold all duties - regardless of their status (eg. done, to do, in progress, and so on). Then we are able to develop yet another table known as "Status". Then when our tables contain information, we'll be capable of operate queries towards these tables to discover what jobs have to be carried out and which of them are in a offered position, and so on.

But let's not get forward of ourselves. Let's develop our first table.

They are the measures to make a table in a SQL Server 2014 databases using SQL Server Administration Studio (SSMS).

  1. Ensuring you have the correct database expanded (in our case, the TaskTracker database), right click on the Tables icon and select Table... from the contextual menu:

  2. A new table will open in Design view. While you have this screen open, do the following:
    • Utilizing the values in the screenshot, full the details inside the Column Name column, data Type column, and allow Nulls column.
    • Make the TaskId column a Primary Key discipline by right-clicking the button close to TaskId (i.e. exactly the same area exactly where the true secret seems in the subsequent screenshot) and picking Set Primary Key.
    • Make the TaskId column an identity column by placing Is identity to yes (you can discover this feature underneath the Id Specification area in the bottom pane). Be aware that to set values in the base pane, you should pick the column name within the leading pane initial. We are environment this column to be an auto-number column - it's going to immediately produce a brand new amount for every document that is created.
    • Set the Default Price from the DateCreated column to (getdate()). (This will automatically insert the present date into that field for each new file).



    What we are carrying out is creating the column names, specifying the sort of data that may be entered into them, and setting default values. Restricting the data sort for each column is extremely crucial and aids maintain data integrity. For example, it may stop us from accidentally entering a task title right into a field for storing the existing day. SQL Server will avoid information from getting into tables in which the data does not adhere towards the rules that we have established for each column.

  3. Save the table by selecting File > Save Table_1 or by right-clicking on the Table's tab and selecting Save Table_1 from the contextual menu:

  4. When prompted, name your table (we'll call it Tasks):


Your New Table

Now that you've created a new table, it will appear under your database in the Tables section. If you don't see it immediately, try refreshing the Object Explorer. You can do this by right-clicking on Tables and clicking Refresh from the contextual menu:

Here's a screenshot of the table with the Columns folder expanded:




SQL 2014 Hosting Tutorial :: How to Create Histogram Chart in SQL

clock September 15, 2014 08:42 by author Ben

SQL Server 2014 will be an amazing release regarding all the various performance enhancements that are part of this new release. And know I wanna tell you about how to create Histogram Chart in SQL.

In this tips we will create a histogram chart in SQL 2014 to show how to aggregate data will very little effort.

Step 1
Let's create a sample table called Employee that has columns EmpID and EmpAge with the data as shown in the below screenshot.

Step 2
Create a new SSRS report and configure it to use the data from the table we just created. Add a bar chart to the report and configure it as shown in the below screenshot.

Step 3
Execute/Preview this report and your report should look like the below screenshot and you will see data listed for all fifteen employees.

In reality, an employee table can contain records for hundreds to thousands of employees and therefore if the requirement is to analyze age distribution this type of report won't serve the purpose. A typical approach to solve this issue would be to retrieve the count of employees falling into a few predefined age categories and show it in a distribution chart like a pie-chart. In the next few steps we will see how a histogram chart can be a much simpler approach.

Step 4
Select the EmpAge chart series and open the properties window. In the CustomAttribute category, select "ShowColumnAs" property and set the value as "Histogram" as shown in the below screenshot.

Step 5
Execute the report and you should find results similar to the below screenshot. This is a histogram chart, but the problem with this chart is that by default the chart has selected all fifteen distributions, so you get one employee for each age category which is not very helpful.

Step 6
Let's say we want to see the data in three age groups 20 - 25, 25 - 30 and 30 - 35 and the number of employees in each age group. In the CustomAttribute category, you will find a property "HistogramSegmentIntervalWidth" and the default value is zero. Change this value to "5", so that the age group we have is divided into 3 categories as desired. Execute the report and the report should look like the below screenshot. This chart shows 4 employees in the 20 - 25 group, 5 employees in the 25 - 30 group and 6 employees in the 30 - 35 group.

Also note that the "Percentage of Total" axis is generated and calculated automatically without any programming efforts and this axis is very useful in statistical analysis. This type of axis is not possible out-of-box in charts like pie-charts and hence charts such as histogram charts are preferred.



Reason Why you Must Choose ASPHostPortal.com
ASPHostPortal.com offers the newest Microsoft SQL 2014 database with all our hosting plans. We are your dependable SQL web hosting provider who will fulfill your needs!


Full Remote Access
We allow you full remote connectivity to your SQL Server 2014 Hosting database and do not restrict access in any way.

Easily transfer your existing SQL Server database
With our SQL Server hosting package, there's no need to rebuild your database from scratch should you wish to transfer an existing SQL Server database to us. If you already have a database hosted elsewhere, you can easily transfer the contents of your database using SQL Server Management Studio which is fully supported by our packages. SSMS provides you with an Import/Export wizard which you can use to upload your data and stored procedures with a couple of clicks.



SQL 2014 Hosting with ASPHostPortal.com :: Semantic Search Functions on SQL 2014 Hosting

clock September 8, 2014 05:59 by author Ben

Introductions Semantic Search

Text mining is also becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understand the meaning of documents.

The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014. Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases. Then it also uses these key phrases to identify and index documents that are similar or related.

For example, users can query the index of key phrases to build the taxonomy for an organization, or for a corpus of technical documents. Or for example in an HR scenario, a recruiter can query the document similarity index to identify resumes that match a job description. Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios.

Semantic Search Functions on SQL 2014 Hosting

Here are some search function on semantic that we have to use to our program because it’s can make maximized sql 2014 features.

  •  semantickeyphrasetable (Transact-SQL)

Returns a table with zero, one, or more rows for those key phrases associated with columns in the specified table.

  •  semanticsimilaritydetailstable (Transact-SQL)

Returns a table of zero, one, or more rows of key phrases common across two documents (a source document and a matched document) whose content is semantically similar.

  •  semanticsimilaritytable (Transact-SQL)

Returns a table of zero, one, or more rows for those columns whose content is \semantically similar to a specified document.

How to install Semantic Search Functions on SQL 2014 Hosting

There are some steps that you must completely implemented before using semantic search

1. Install the semantic language statistics database.

Download the appropriate version of the Windows installer package named SemanticLanguageDatabase.msi. This file contains a compressed database file and log file.

Run the SemanticLanguageDatabase.msi Windows installer package to extract the database and log file. You should change the default destination directory to a location where SQL Server has necessary file permissions for attaching a database (SQL Server data folder for example). Optionally, you can move the extracted database file and log file to the preferred location in the file system.

2. Attach the semantic language statistics database.

Attach the database to the instance of SQL Server by using Management Studio or by calling CREATE DATABASE with the FOR ATTACH syntax. By default, the name of the database is semanticsdb. You can optionally give the database a different name when you attach it. You have to provide this name when you register the database in the following step:

CREATE DATABASE semanticsdb
ON (FILENAME = 'C:\Microsoft Semantic Language Database\semanticsdb.mdf')
FOR ATTACH;


Important

When the semantic language statistics database is extracted, restricted permissions are assigned to the database file and log file in the file system. As a result, the user may not have permission to attach the database. If an error is raised when you try to attach the database, check and fix file system permissions as appropriate.

3. Register the semantic language statistics database.

Call the stored procedure sp_fulltext_semantic_register_language_statistics_db and provide the name that you gave to the database when you attached it:

EXEC sp_fulltext_semantic_register_language_statistics_db @dbname = N'semanticsdb';
GO

Our Special SQL Server 2014 Hosting Complete Features
What we think makes ASPHostPortal.com so compelling is how deeply integrated all the pieces are. We integrate and centralize everything--from the systems to the control panel software to the process of buying a domain name. For us, that means we can innovate literally everywhere. We've put the guys who develop the software and the admins who watch over the server right next to the 24-hour Fanatical Support team, so we all learn from each other.



Cheap YetAnotherForum.NET 1.9.6.2 Hosting :: Installing YetAnotherForum.NET 1.9.6.2 on Your Server

clock July 23, 2014 06:29 by author Ben

YetAnotherForum.NET (YAF) is a Open Source discussion forum or bulletin board system for web sites running ASP.NET with SQL Server as the back-end database. The source code is entirely written in C#, and is licensed with the GPL license. And now YetAnotherForum.NET (YAF) has release the new version YAF.NET 1.9.6.2

Here is the important features of YetAnotherForum.NET 1.9.6.2:

  • Added Admin Page to Import List of Banned Ip Adresses (You can find Huge list of Bot IP Lists here: StopForumSpam.com)
  • DNN YAF Whats New Menu List Item is now fully Templatable
  • Host Admins can control admin groups access to YAF event log by event type. They can set permissions to delete events by type too, i.e. readonly mode for each event.
  • Added New Host Admin Page for Host Admins to restrict simply admins to various admin pages individually.
  • Added New Notification Bar for System Messages (In the Host Settings you can choose Between Modal Dialog or Notification Bar for Messages, also the Display Duration can be defined there). Also added an option to show the alert dialog for messages on Mobile Devices.
  • Added new "Fancy" Theme
  • Added Keystroke For Quotes to the YAF BBCode Editor you can now use CTRL+Q for inserting and "[quote]"..."[/quote]"
  • Added Indicator to a Private Message if its an Reply
  • Added new BB Code Feature to the Editor for indent text
  • Added HoverCards to Username. If enabled it shows an Hover Card (Which shows some quick info about the user) when you hover an user name. This will also show an Hover Card on the Twitter & Facebook Profile Button.
  • Added Display Options for the Event Log, you can define Start and End Date and also Event Type
  • Added settings to control number of records in the event log.
  • Added Option to send PM to all Buddies of a User
  • Added DNN Option to Remove Tab Name/Title from the Current Page Title you can choose between "Dont Remove", "Always Remove", "Remove only if matches the Board Name". Default Value : "Always Remove"

This article will give you a step by step guide on how to install YetAnotherForum.NET on your server:

Make sure your server / Host has the following requirements:

  • Microsoft .NET Framework 3.5 SP1 (Use version 1.9.3 or earlier for .NET Framework 2.0) or the latest .NET Framework.
  • Microsoft SQL Server 2005 or above. SQL Server 2000 works, but requires removal of some SQL forum database optimizations.


1. Download YAF from http://www.yetanotherforum.net. Note that current version available is YAF 1.9.6.2 and my article is based on this version. For future versions the installation and Integration instructions may change.

2. Create a virtual directory in IIS pointing to D:\YAF-v1.9.6.2-FINAL-SRC\YetAnotherForum.NET. Above is the assumed path where you have downloaded YAF.

3. SQL Server database is required for installing the YAF. SO keep SQL Server installed on the machine. Then Create an empty SQL Server database for YAF named yafnet(say).

4. If Web.Config is not present in the forum root,copy one of the samples provided in the "webconfigs" folder into the root of the web application and rename it to web.config.

5. Setup a valid connection string in db.config as per the format provided by YAF.

6. Configure the SMTP settings in mail.config as per your hosting environment and as per the format provided by YAF.

7. Then try to open http://localhost/YetAnotherForum.NET/install/Default.aspx and install the forum as per instructions appearing on the installation wizard. It will create/update the forum database and create admin user. Note that all the passwords should have a special charector in it.

8. After the installation the URL will come something like http://localhost/yaf/default.aspx if the above page opens without any error that means your installation is complete.

9. Then you need to copy your installation folder to the root of your website.

10. Suppose you want the forum to appear on the Default.aspx Page, Then Merge the Default.aspx page from the forum with Default.aspx page from your website.Also you need the merge the web.config file from the forum to web.config file of existing website.

11. Now run the default.aspx page of the website and forum should appear on the page.


Best and Cheap YetAnotherForum.NET Web Hosting with ASPHostPortal.com


ASPHostPortal.com YetAnotherForum.NET optimised hosting infrastructure features independent email, web, database, DNS and control panel servers and a lightning fast servers ensuring your site loads super quick! Reason why you should choose us to host your YetAnotherForum.NET site:

  • Top of the line servers optimized for your YetAnotherForum.NET installation
  • 24/7/35 Technical support from YetAnotherForum.NET hosting experts
  • We provide full compatability with YetAnotherForum.NET hosting and all popular plug-in.
  • Free professional installation of YetAnotherForum.NET.
  • We provide 30 days money back guarantee

 



Cheap Web API 2.2 Hosting :: The Important Features on Web API 2.2

clock July 22, 2014 10:48 by author Ben

ASP.NET Web API 2.2 was released last week, and one of the key new features is the ability to extend and plug in your own custom logic into the attribute routing engine.

Commonly known as “attribute routing”, it’s actually officially called “direct routing”, because, as they are about to show here, it’s not necessary to use it with attributes at all, and you can plug in any route provider into it. The Web API 2.2 release is particularly noteworthy as it is the first Web API release with support for OData v4 with selected highly demanded features.

ASPHostPortal.com is Microsoft No #1 Recommended Windows and ASP.NET Spotlight Hosting Partner in United States. Microsoft presents this award to ASPHostPortal.com for the ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2012, .NET 4.5.2/ASP.NET 4.5.1, ASP.NET MVC 6.0/5.2, Silverlight 5 and Visual Studio Lightswitch. Click here for more information


Here is New features :

1. Protocol and format changes from V3 to V4.

2. OData attribute routing: This release allows you to define the routes in your controllers and actions using attributes.

3. Support for functions: This release allows you to define functions in your OData model and bind them to actions in your controller that implement them.

4. Model aliasing: This release allows to change the names of the types and properties in your OData model to be different than the ones in your CLR types.

5. Support for limiting allowed queries: This feature release the service to define limitations on the properties of the model that can be filtered, sorted, expanded or navigated across.

6. Support for ETags: This release allows to generate an @odata.etag annotation based on some properties of the entity that can be used in IfMatch and IfNoneMatch headers in following requests.

7. Support for Enums

8. Support for $format: Added support for $format, so clients are able to specify the desired format of the response in the URL.

The OData v4.0 protocol includes a lot of new features and many changes to existing ones that improve the protocol and the modeling capabilities for the services implementers, but at the same time, those changes make difficult to support multiple versions of the protocol in a single implementation.

For that reason, we have decided to create a new assembly to support the v4.0 version of the protocol while maintaining the current assembly for those people who want to implement services based on previous versions.

Here are the most important changes:

1. The package ID for the v4.0 is Microsoft.AspNet.OData.

2. The assembly name and the root namespace are now System.Web.OData instead of System.Web.Http.OData.

 3. All the extension methods have been moved to System.Web.OData.Extensions.

4. We have removed all the extension methods that used to exist for HttpRequestMessage like GetODataPath or GetEdmModel and we have added a single extension method, ODataProperties that returns an object containing the common OData properties that were accessible by the old extension methods, like the IEdmModel of the service or the ODataPath of the request.

5. MapODataRoute has been changed to MapODataServiceRoute.

6. QueryableAttribute has been changed to EnableQueryAttribute.


Recommended extras for your Web API 2.2 hosting website:

Feature Rich Services
Offering feature rich, on-demand reliable and secure web hosting services is why our customers stay here. We are constantly working to improve our services and the product line we offer. We firmly believe in a long lasting customer relationship. We want our customers to stay and grow their business with us.

Cost Effective Pricing
We provide our services at the lowest cost possible by utilizing our in house architecture coupled with carefully chosen software. We strive to keep our operating costs low so we can deliver quality web hosting services at very reasonable prices.

Money Back Guarantee
We are absolutely sure that you will be satisfied with our service that we offer our unconditional money back guarantee. Feel free to take a ride with us without any risk!



JSON Hosting on Windows Server:: How to Add JSON Handler in IIS

clock July 22, 2014 09:37 by author Ben

JSON is a text format that is completely language independent but uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others. These properties make JSON an ideal data-interchange language. JSON is very useful when developing a web application where fast, compact and convenient serialisation of data is required, however it's flexible nature is the very thing that makes it less suitable than XML for transferring data between separate systems, or storing data that will be read by 3rd parties.

JSON is built on two structures:

  • A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array.
  • An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence.

These are universal data structures. Virtually all modern programming languages support them in one form or another. It makes sense that a data format that is interchangeable with programming languages also be based on these structures.

Advantages of JSON

  • Smaller message size
  • More structural information in the document
  • Can easily distinguish between the number 1 and the string "1" as numbers, strings (and Booleans) are represented differently in JSON.
  • Can easily distinguish between single items and collections of size one (using JSON arrays).
  • Easier to represent a null value
  • Easily consumed by JavaScript

Sometimes we need to create JSON in a text file with extension .json, however by default IIS 7 or any of the IIS are not configure to handle .json extension. So below is a very simple method to do that. You can apply the method on the root of IIS so .json can be handled by every site or virtual folder in the IIS or just to the specific site.

  1. Open IIS Manager
  2. Display properties for the IIS Server
  3. Click MIME Types and then add the JSON extension:
    File name extension: .json

    MIME type: application/json
  4. Go back to the properties for IIS Server
  5. Click on Handler Mappings
    Add a script map

    Request path: *.json

    Executable: C:\WINDOWS\system32\inetsrv\asp.dll

    Name: JSON

Reasons To Use IIS 7 Hosting

IIS 7 makes extending Web server functionality easier. A new integrated pipeline lets developers create custom modules that can be plugged into the IIS7’s new request-processing pipeline. Developers can write native modules with C++ or managed modules in a .NET language such as C# or Visual Basic.Net. The advanced features of the .NET Framework, combined with deep integration into the IIS 7 pipeline, lets developers create custom modules quickly and easily. Any application can leverage the .NET Role and Membership providers, which are integrated in the new IIS 7 pipeline. Existing ISAPI applications built for IIS6 will also run without modification in IIS 7’s Classic mode.

IIS 7 builds on the security and reliability established by IIS 7.0. The modular design lets you reduce the attack surface of your server by uninstalling the modules that you do not need for your application. You can also write your own modules to support your custom security requirements. New automatic application isolation adds a layer of protection to keep applications safe from each other. IIS 7’s ability to set up rules to control access to URLs and filter requests lets administrators manage access to sites, folders, and files without requiring ACLs. And admin delegation lets you assign limited administrative rights to users for specific sites instead of granting server-wide admin rights.



Cheap SQL SSRS 2014 Hosting :: How to Configure Available Memory for SQL Server Reporting Services 2014

clock July 18, 2014 07:35 by author Ben

Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enables developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.

Today we're going to cover how to configure available memory for SQL Server Reporting Services 2014. If you need to configure the amount of memory available to an instance of SSRS 2014 you have to get your hands dirty and edit the RsReportServer.config file. The RsReportServer.config file stores settings that are used by Report Manager, the Report Server Web service, and background processing.

The location of the rsconfile file is generally:

\Program Files\Microsoft SQL Server\MSRS1111.MSSQLSERVER\Reporting Services\ReportServer

Within the RsReportServer.config file, configuration settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum, MemorySafetyMargin, and MemoryThreshold. If you were to open the file you will see that the WorkingSetMinimum and WorkingSetMaximum are not present by default.

<Service>
 <IsSchedulingService>True</IsSchedulingService>
   <IsNotificationService>True</IsNotificationService>
     <IsEventService>True</IsEventService>
       <PollingInterval>10</PollingInterval>
         <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
           <MemorySafetyMargin>80</MemorySafetyMargin>
         <MemoryThreshold>90</MemoryThreshold>
       <RecycleTime>720</RecycleTime>
    <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
 <MaxQueueThreads>0</MaxQueueThreads>


This is because you have to enter them yourself, as if you are hosting multiple applications on the same computer and you determine that the report server is using a disproportionate amount of system resources relative to other applications on the same computer.

<Service>
  <IsSchedulingService>True</IsSchedulingService>
    <IsNotificationService>True</IsNotificationService>
      <IsEventService>True</IsEventService>
        <PollingInterval>10</PollingInterval>
          <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
        <MemorySafetyMargin>80</MemorySafetyMargin>
      <MemoryThreshold>90</MemoryThreshold>
    <RecycleTime>720</RecycleTime>
 <WorkingSetMaximum>786432</WorkingSetMaximum>
<WorkingSetMinimum>524288</WorkingSetMinimum>
 <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
   <MaxQueueThreads>0</MaxQueueThreads>


The Reasons To Use SQL Reporting Service (SSRS) 2014 Hosting with ASPHostPortal.com

  • Fully Integrated with SharePoint
  • The report development environment is a Standard Microsoft Platform - SSRS Reports are developed in BIDS (Business Intelligence Development Studio).
  • Customizable Report Rendering - SSRS provides a .NET Web Service programmatically accessible to extend the delivery of reports beyond the browser. The SSRS reports can be rendered to HTML. PDF(Portable Document Format), Microsoft Excel, XML, MHTML (MIME HTML), TIFF (Tagged Image File Format). Microsoft Word, and ATOM. The SSRS .NET Web Service allows embedding reports in custom applications where the look and feel of the report viewer can be easily controlled and customized.
  • Mobile Support - Starting SQL Server 2012 Service Pack 1 (SP1), SSRS supports viewing and basic interactivity with reports on Microsoft Surface devices and devices with Apple iOS6 and Apple Safari Browser such as iPAD. SSRS reports can also be view on Windows 8 devices.


Cheap Moodle 2.7 Hosting :: Top Features on Moodle 2.7 to Improve Your Moodle Application

clock July 16, 2014 07:27 by author Ben

ASPHostPortal.com, a leading innovator in Windows Server hosting, announces support for Moodle 2.7 on their Windows Server 2012 hosting platform and available for all of the ASPHostPortal Windows hosting plans.

Moodle 2.7, the latest major release from Moodle.org was released yesterday May 12th. With Moodle 2.7 there are a few major enhancements and improvements such as Atto text editor and the More and Clean themes as the only that will ship by default. An additional point of interest is that Moodle 2.7 will receive long term support of Moodle HQ.


Moodle 2.7 brings a suite of new features, improved tools and streamlined workflows to administrators, educators and students. The free Moodle learning platform continues to strengthen with several new capabilities and improvements, including:

Modern Appearance
Moodle now uses Bootstrap themes by default for improved responsive design and usability.

Easily Create and Manage Quiz

A number of productivity improvements have been added to Quiz and Question Bank, including an added option ‘Save changes and continue editing’, improved quiz reports, and an updated question type selector makes duplicating and moving questions much easier.

Support the Cloud
Moodle now is linking with the cloud and other clustered systems to enable this.  Systems administrators will find more features than ever which will enable them to scale Moodle to millions of learners if required.

Improved Logging
A new logging subsystem with plugins allowing detailed and external logs provides opportunities for improved reporting as well as advancements in better learning analytics.

Improved Conditional Activities Supporting More Complex Boolean Operations and Plugins

Adding a restriction
Within the settings for the activity or resource you want to restrict access to, first click the Add restriction button. A dialogue box appears allowing you to select the type of restriction you wish to apply to the current activity, resource or section.


Adding the restriction type

Having chosen the restriction type, you can then define the specifics of the restriction. In the case of the example below, participants have to complete the Holidays quiz.

Scheduled Tasks Management
With an improved scheduling system, tasks can be scheduled precisely, even on complex clustered servers.

Support
There’s another thing that will make administrators happy. Moodle 2.7 is a long term supported release. It will have an extended support of 3 years (until May 2017) for security and data-loss fixes.

Big Data
You will have heard this term mentioned several times before, now, Moodle has incorporated better use of data and reporting.

Improve Assignments
Teachers can now notify students when providing feedback, easily keep track, edit or delete student submissions, set a word limit and add comments directly to text assignments.

Reasons to choose ASPHostPortal.com as your cheap Moodle 2.7 Hosting
ASPHostPortal.com have Moodle™ experts on staff who are available 24/7 to help, a one click install script to make installation a breeze, and we guarantee our service, money back. What makes ASPHostPortal.com the premier place to host Moodle? Here are 5 reasons why we are the best:

Easy to Use Tools
ASPHostPortal.com use World Class Plesk Control Panel that help you with single-click Moodle installation.
   
Best Programming Support
ASPHostPortal.com hosting servers come ready with the latest PHP version. You can get access directly to your MySQL from our world class Plesk Control Panel.
   
Best Server Technology
The minimal specs of our servers includes Intel Xeon Dual Core Processor, RAID-10 protected hard disk space with minimum 8 GB RAM. You dont need to worry about the speed of your site.
   
Best and Friendly Support
Our customer support will help you 24 hours a day, 7 days a week and 365 days a year to assist you.
   
Uptime & Support Guarantees
We are so confident in our hosting services we will not only provide you with a 30 days money back guarantee, but also we give you a 99.9% uptime guarantee.



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions


Author Link


Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in