We did a recent survey and discovered that 38% of the people who participated didn’t know how much of their web site traffic is coming from mobile devices.
We asked, What was the percentage of your web site traffic coming from mobile (smartphones and tablets) in 2012?
This is how our users answered:
Well, for those of you who don’t know how much of your traffic is coming from Mobile clients, we have SmarterStats to help you find out.
If you haven’t enabled SmarterStats for your hosting account, here’s how to do it:
Log in to Control Panel and go to Stats / Raw Logs.
Click the Enable button next to SmarterStats (Free) (Yup, that’s right! We provide this to you for free. 
)
Alright Martin I have enabled SmarterStats what do I do now?
Well now all you have to do is relax for about an hour and let SmarterStats process the HTTP logs for your site. SmarterStats processes our HTTP server logs for your site to provide you a nice interface.
After the hour has passed, login to your SmarterStats account. You can find the login information in the Stats / Raw Logs section of Control Panel.
When you log in, expand the Report Items folder and expand the Browsers folder too.
Now click on Mobile Phones.
Cool Martin! Now how do I save this report and change the date range at the same time?
Well… if you like the report you see and you would also like to change the date range, all you have to do is click on the Add Favorite icon in the report you just clicked on.
This will then open the Following Window:
Click on the drop down menu next to Default Date Range and choose the date range you wish to use. Then go ahead and choose any of the other settings you wish to use and click on the OK button.
This report will be placed in the Favorites section in SmarterStats.
Another cool thing you can do to stay in the loop is to set up a Custom Report. That way you can have the report emailed to you daily, weekly, or monthly.
Expand the Custom Reports folder. Now click on the New Custom Reports.
The following web page will appear:
Go ahead and enter a name for your report in the name field, choose the Default Date Range, and click on the Report Items tab.
Click Add Item.
Click the drop down menu next to Report Item and select the favorite report you just created.
Now click Save.
This report will now be in your Custom Reports folder.
Click on the Scheduled Email Reports icon.
Click on the Add Email Report icon.
From the Reports drop down menu select the report you just created.
In the Frequency field select how often you wish to receive this report.
In the To field enter the email address you wish to send to.
Now click on Optional tab to add more email address to send to.
You might also want to place a check next to Enable graphical charts (HTML only) that way you get a nice graphical chart to refer to in your email message.
Click Save when finished.
Well, with all that said and done, I hope this helped some of you stay up to date with what type of traffic your web site is receiving.
I already provided some reasons why you see this error in the Control Panel in a previous blog post:
so I won’t bore you with the details again. Instead, I will be covering another error that is thrown and trapped on the back end:
“MODIFY FILE failed. Size is greater than MAXSIZE.”
Your database add-on space is capped depending on the type of database you ordered and how much extra disk space you purchased. You can view the maximum size of your database using the tools in the DiscountASP.NET Control Panel by clicking on the MS SQL Manager link under the Database Management section in the menu to your left:
Your transaction log disk space is also capped at 1000 MB (1 GB). Below are instructions on how to create and fix the problem.
How You Can Create the Problem
As in my last tutorial, I will be using the AdventureWorks database in this example. First, I’ll attach both the database and log file to my local SQL Server instance.
Next, right click on the database and select Properties. Go to the Files section and notice the initial size.
Go ahead and change these values to 500 and 1500, respectively, and click on OK.
Backup the database, upload it and try to restore it using the tools in the DiscountASP.NET Control Panel. A base SQL Server 2005 database is 300 MB and the transaction log size is 1000 MB, so it will fail when you try to perform the restore and throw the error mentioned earlier.
Now, if you had only set the primary data file (.mdf) to 500 and left the transaction log (.ldf) with a value under 1000 MB and tried restoring to a higher version such as SQL Server 2012, it will work because the newer versions have a higher base value. This problem will also create itself naturally as your database grows and fills up with data, or if you issue too many SQL commands in an instance, causing the transaction log to fill up too quickly.
The Solution
The solution is fairly simple. You can try recovering unused database space by shrinking it. Right click on your local database instance and select Tasks -> Shrink -> Database. You can also shrink your database by opening a New Query window in SQL Server Management Studio and executing this SQL Statement:
DBCC SHRINKDATABASE (N’DatabaseName’, TRUNCATEONLY)
For example:
DBCC SHRINKDATABASE (N’AdventureWorks’, TRUNCATEONLY)
You can check the new values in the Initial Size (MB) column by right clicking on the database, selecting Properties and then Files. Make sure the Initial Size (MB) of the primary data file is less than the value found in the DiscountASP.NET Control Panel and that the Initial Size (MB) of the transaction log file is less than 1000 MB (1 GB). If the Initial Size (MB) of the primary data file is greater after you shrink it, then that means you just need to order more SQL Server disk space.
Earlier this week, jQuery 2.0 was released.
I’ll save you the rehash, you can look to their site for information regarding the updates. The interesting thing I wanted to mention was that as of 2.0, they dropped support for IE 6, 7, & 8. This means everybody else is going to start following suit.
I often see developers on social networks asking if they really need to still support these browsers. I always take it as code for “If you guys stop, I finally can too.” So unless you have a strong user base stuck in a time-warp, I think this clearly marks the end of a very painful era – kind of.
CodeProject recently put out a poll that stated only 25% of developers are committed to still supporting the older versions of IE. Frankly, I think that number is going to get smaller really quickly. But again, it all depends on your user base and your needs. I also want to share one more statistic that I think you have to see.
DiscountASP.NET is proud to sponsor the Kansas City Developer Conference, happening May 2-4!
It’s over 100 sessions and over 500 developers at the Kansas City Convention Center. Go network, go learn, go get educated on the latest in .NET, Ruby, Java, Python, iOS, JavaScript and Agile.
In fact, go for free! We are giving away two tickets!
So Web Matrix 3 launched this afternoon and, as always, we are here to help out the Web Developer community.
I’m happy to announce the launch of a FREE Web Matrix 3 Hosting Sandbox. Head on over to our DiscountASP.NET Labs Site and you can sign up for a free hosting account to test out Web Matrix 3.
Web Matrix v3 integrated Git and remote site editing.
This is a limited program on a first come first serve basis. The program ends August 1st.
