Microsoft Silver Partner Status Renewed with Three Competencies

Takeshi Eto I’m proud to announce that we have successfully renewed our Microsoft Silver Partner status with three competencies –  Silver Datacenter competency, Silver Cloud Platform Hosting competency and the Small and MidMarket Cloud Solutions competency.  So we got to expand our Microsoft Partner logo with the new competencies!

Microsoft Silver Partner

Visit DiscountASP.NET to learn more about our ASP.NET hosting services.

April 2019 Web Application Gallery Updates

Ray Huang Below is a list of our Web Application Gallery updates for April 2019.

 

 

  • Acquia Drupal 7.65
  • BlogEngine.NET 3.3.6
  • DotNetNuke (DNN) 9.3.1.2 Platform
  • Gallery Server Pro 4.5.0
  • Joomla 3.9.5
  • mediaWiki 1.32.0
  • mojoPortal 2.7.0.0
  • Moodle 3.6.3+
  • phpBB 3.2.5
  • phpMyAdmin 4.8.5
  • Umbraco CMS 8.0.1
  • WordPress 5.1.1

 

Visit DiscountASP.NET to learn more about our ASP.NET hosting and PHP hosting services.

 

SQL 2017 Hosting is Available

Takeshi EtoSQL 2017 hosting is now available as an add-on option. Customers can order SQL 2017 through their Control Panel. All of the SQL tools available for SQL 2016 are available for SQL 2017.

 

sql 2017 hosting

 

Some of the new features of SQL 2017 include general performance improvements, new string functions, query processing enhancements like adaptive query processing,  graph database capabilities, and security enhancements like Always encrypted and row level security.

Visit DiscountASP.NET to learn more about our ASP.NET hosting and SQL hosting services.

 

How to Change the Default Value of Select Top Rows in SQL Server Management Studio

In SQL Server Management Studio (SSMS), the quickest way to open or edit a database table’s content is by right clicking on the table and choosing Edit / Select.  But, how many of you are aware that SQL Server Management Studio’s settings allows you to change the default value?

One of the main reasons this setting was added to SQL Server Management Studio is to prevent unresponsiveness of the system if the table consists of large amount of data.

By default in SSMS, you can select 1000 Rows and Edit 200 Rows.

If you would like to change the default value then go to SSMS > Tools > Options:

In the Options dialog box, highlight SQL Server Object Explorer and change the default values to any number as per your requirements.

In this example, we are changing the value to “2000”.

Press OK.

After saving the changes, go ahead and right click on your database table.  You should see the new value as shown below:

 

Visit DiscountASP.NET to learn more about our ASP.NET and SQL hosting solutions

 

About Guest Blogger: Lavish Kumar

Based out of New York, USA, Lavish Kumar is a full stack web developer by profession and founder of Striving Programmers, a trusted community for developers that offers a wealth of articles and forums to assist individuals with improving their software development skills. He is passionate about writing tech articles and building great web applications. Lavish specializes in custom web applications, e-Commerce platforms, CMS implementation and CRM systems.

 

 

Orlando Code Camp on March 30th, 2019

John MeeksThe Orlando Code Camp is coming up this weekend, Saturday, March 30th and will be held at Seminole State College. We’re a proud to be a repeat sponsor for the Orlando Code Camp. We are sure that everyone going will have an amazing time! If interested in going, you can register to attend here!

Visit DiscountASP.NET to learn more about our ASP.NET hosting services and our Community Sponsorships.

 

The End of Google’s Great Social Experiment – Google+ Shutting Down April 2nd

John Meeks Google+ always was two steps behind in the social media space. Google’s late to the game entry into the social media tidal wave always seemed an afterthought with both Google and users. Early evolutions of the service always felt more of a correction to the service than an enhancement. So to hear Google announce that they were shutting down Google+ was only shocking in that it took so long for them to finally get to this point.

Google+ wasn’t Google’s first attempt at social networking, but it was the most widely pushed by the company. Launched in June 2011 Google+ was aimed squarely at the rising influence of Facebook and Twitter. Google built Google+ to tie your social actions to other properties within the Google network. Meaning instead of sharing that YouTube video on Facebook, you would share it on Google+ thus keeping everything within the Google network. Google+ and it’s “+1” feature also showed positive ranking affects within search indexing on Google and Youtube, meaning sharing and giving a “+1” to something could possibly help with your search ranking. Google would regularly deny that G+ had any search ranking influence, but SEO and Marketing experts would point to their own analytical data to contradict Google’s claims.

But Google+ was late to the game. Facebook and Twitter were both firmly established, in what was already becoming a crowded social media space. Google+ never gained enough ground to justify regular usage from users or businesses. So when Vic Gundotra, the person who championed the creation of Google+, left Google in April of 2014 it was seen as the beginning of the end for Google+. In October of last year Google announced the consumer version of Google+ would be shutting down August 2019. Then in December 2018 Google moved up the shutdown to April 2, 2019 when they reported that a Google+ API update exposed customer data for 6 days before it was discovered.

Many of you know that we were early adopters of Google+, with our own Google+ pages and even experimenting with Google Hangouts. Google+ at one time seemed like it might become a social network for more of the tech focused crowd and we saw that reflected in many of the interactions we had with users on Google+. But over time it became clear that Google+ was an afterthought within Google and with many users. If you haven’t noticed yet, we have slowly removed many of the links to our Google+ pages and the Google+ integration within our forums. The Google announcements in October and December helped to validate what we were seeing, that Google+ was heading to that great social network in the sky.

 

For Social Media, you can catch us here:
DiscountASP.NET on Facebook
DiscountASP.NET on Twitter

Visit DiscountASP.NET to learn more about our ASP.NET hosting services .

Monthly Billing Date Explained

Takeshi Eto A concept that is not often talked about, much less understood, is the Monthly Billing Date on a hosting account. What customers may not realize is that the Monthly Billing Date affects all aspects of charges on an account. It affects when statements are generated, when services renew, the pro-ration of services ordered in the middle of a billing cycle, the charge for a plan change, and more.

So what exactly is the Monthly Billing Date on an account and how is it determined?

The Monthly Billing Date on an account is the monthly date on which billing activities are based. The date is determined when the account is first activated. Once set, the Monthly Billing Date cannot be changed in the billing system.

Let’s say we have an annual hosting service ordered on January 17th. The Monthly Billing Date will be the 16th of every month. The initial charge for the hosting service will be for the period from January 17 of the current year, through January 16th of the following year.

If the hosting account was ordered on the 22nd, then the Monthly Billing Date would be the 21st.

What happens on dates affected by changing month lengths?

Accounts ordered on the 1st still have their Monthly Billing Date set to the 31st, even if there is no 31st in the previous month. So accounts ordered on March 1st, July 1st, October 1st, etc. have a Monthly Billing Date of the 31st.

So how does the billing system handle the Monthly Billing Dates on months that do not have that date?

In other words, how are February 29th, 30th or 31st, June 31st, September 31st, etc handled? Our billing system simply groups them to the last day of the month. E.g., All accounts with billing activity in a non-leap year February along with a Monthly Billing Dates of 29th, 30th and 31st are handled on February 28th.

Billing for customers with base hosting plan only

The simplest scenario is if the customer only has the base hosting plan on the annual billing cycle. Here, for an account with Monthly Billing Date of January 16th, the annual hosting fees will be charged every year on January 16th. If the billing cycle is quarterly, the hosting renewal fees are charged on the 16th of every three months after the initial signup.

What happens with Addons and plan changes?

DiscountASP.NET hosting customers can order Addons to enhance their hosting services at any time. The two most common questions when customers order an Addon are

  • How much will I be charged?
  • When can I get a statement (for my records or accounting department)?

Let’s go back to our example of an annual account which renews every January 16th. If a new MS SQL database is ordered on April 5th, how much will the charge be? The charge will be pro-rated from April 5th of this year, through to the account’s next renewal, January 16th of the next year. At $10/month, the charge will be approximately $91.00.

The statement for the charge will be available on the next Monthly Billing Date, which will be April 16th.

We hope this post didn’t make your head explode and answers some questions regarding how our billing system works.  Remember, if you ever have any billing related questions, please send them to the Billing team.