otgnet.com
 
 

Who is MS. Dewey ?
Saturday, September 04, 2010

HOME
View All Blogs
 
Browsers
Internet Explorer
Internet Explorer GPO
Mozilla
Database
SQL
Development
AJAX
ASP and ASP.NET
C#
vb.net
Digital Media
Digital Media
Game Consoles
PS3
Wii
Xbox
Misc
Adobe Flash
Commentary
Cool Stuff!
Tech News
Tools
Virtual Earth
Mobile
Mobile Devices
MS MOM
MS MOM
MS Office
MS Office
MS Sharepoint
Sharepoint
Security
Security
Training
Webcast
Windows
Cluster and Clustering
Kernel Debug
Terminal Server
User Debug
Windows 2000
Windows 2003
Windows GPO's
Windows Longhorn
Windows Vista
Windows XP







 

Guardian Data Store - free data, and some ideas on how to play with it

Digg!

I was reading the Guardian (a UK newspaper) online today and saw that they have just launched something called Open Platform, basically a set of tools that allow you to access and build applications on top of their data and content. The thing that really caught my eye was the Data Store, which makes available all of the numeric data they would usually publish in tables and graphs in the paper in Google Spreadsheet format. Being a data guy I find free, interesting data irresistible: I work with data all day long, and building systems to help other people analyse data is what I do for a living, but usually I'm not that interested in analysing the data I work with myself because it's just a company's sales figures or something equally dull. However give me information on the best-selling singles of 2008 or crime stats for example, I start thinking of the fun stuff I could do with it. If you saw Donald Farmer's

fascinating presentation at PASS 2008 where he used data mining to analyse the Titantic passenger list to see if he could work out the rules governing who survived and who didn't, you'll know what I mean.

Given that all the data's in Google Spreadsheets anyway, the first thing I thought of doing was using Panorama's free pivot table gadget to analyse the data OLAP-style (incidentally, if you saw it when it first came out and thought it was a bit slow, like I did, take another look - it's got a lot better in the last few months). Using the data I mentioned above on best-selling singles, here's what I did to get the gadget working:

  1. Opened the link to the spreadsheet: http://spreadsheets.google.com/pub?key=phNtm3LmDZEP4i_r7RdVhUg

  2. Followed the link at the very bottom of the page to edit the page.
  3. On the new window, clicked File/Create a Copy on the menu to open yet another window, this time with a version of the data that can be edited (the previous window contained only read-only data)
  4. Right-clicked on column J and selected Insert 1 Right, to create a new column on the right-hand side.
  5. Added a column header, typed Count in the header row, and then filled the entire column with the value 1 by typing 1 into the first row and then dragging it down. I needed this column to create a new measure for the pivot table.
  6. Edited the 'Artist(s)' column to be named 'Artist' because apparently Panorama doesn't like brackets
  7. Selected the whole data set (the range I used was Sheet1!B2:K102) and then went to Insert/Gadget and chose Analytics for Google Spreadsheets. It took me a moment to work out I had to scroll to the top of the sheet to see the Panorama dialog that appeared.
  8. Clicked Apply and Close, waited a few seconds while the cube was built, ignored the tutorial that started, spent a few minutes learning how to use the tool the hard way having ignored the tutorial, and bingo! I had my pivot table open. Here's a screenshot showing the count of singles broken down by gender and country of origin.

image 

Of course, this isn't the only way you can analyse data in Google spreadsheets. Sisense Prism, which I reviewed here a few months ago, has a free version which can connect to Google spreadsheets and work with limited amounts of data. I still have it installed on my laptop, so I had a go connecting - it was pretty easy so I won't go through the steps, although I didn't work out how to get it to recognise the column headers as column headers and that polluted the data a bit. Here's a screenshot of a dashboard I put together very quickly:

image

Lastly, having mentioned Donald Farmer's Titanic demo I thought it would be good to do some data mining. The easiest way for me was obviously to use the Microsoft Excel data mining addin: there are two flavours of this: the version (available here) that needs to be able to connect to an instance of Analysis Services, and the version that can connect to an instance of Analysis Services in the cloud (available here; Jamie MacLennan and Brent Ozar's blog entries on this are worth reading, and there's even a limited web-based interface for it too). Here's what I did:

  1. Installed the data mining addin, obviously
  2. In the copy of the spreadsheet, I clicked File/Export/.xls to export to Excel, then clicked Open
  3. In Excel, selected the data and on the Home tab on the ribbon clicked the Format as a Table button
  4. The Table Tools tab having appeared on the ribbon automatically, I then pressed the Analyze Key Influencers button
  5. In the dialog that appeared, I chose Genre from the dropdown to try to work out which of the other columns influenced the genre of the music
  6. Clicked I Agree and Do Not Remind Me Again on the Connecting to the Internet dialog
  7. Added a report comparing Pop to Rock

Here's what I got out:



image

From this we can see very clearly that if you're from the UK or under 25 you're much more likely to be producing Pop, Groups are more likely to produce Rock, and various other interesting facts.

So, lots of fun certainly (at least for a data geek like me), but everything I've shown here is intended as a serious business tool. It's not hard to imagine that, in a few years time when more and more data is available online through spreadsheets or cloud-based databases, we'll be doing exactly what I've demonstrated here with that boring business data you and I have to deal with in our day jobs.

Up Link Partner cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!4375.entry


GRAB SOME!

Netfirms Web Hosting For Small Business

Query behaviour when you cross the LowMemoryLimit

Digg!

Here’s something that had me stumped for quite a long time earlier this week…

I’m doing some performance tuning work for a customer at the moment, and following my usual approach I took a test query, cleared the cache, ran it and noted how long it ran for and what I saw in Profiler and MDX Studio. However this time I saw some strange things happening: I’d run the same query on a cold

cache more than once and the query times would differ by anything up to a minute; even more confusing, the information I got from Profiler and MDX Studio would be different too – for example, the number of Query Subcube Verbose events in recorded in Profiler for a query might differ from run to run by several hundred. This had me completely confused. There was no-one else on the server and I was running on a cold cache. What was going on?

It turned out that I was running out of memory. I was working on a 32-bit box with a lot of databases on, so even on a cold cache the amount of memory used by SSAS was approaching the LowMemoryLimit threshold (see Marco’s post here, the AS2005 Performance Guide and this white paper
Paltalk Plus Free Trial
for an explanation of what this is). When I ran the query – which had a lot of calculations - memory usage went above the LowMemoryLimit so the cleaner thread was waking up and evicting elements of shrinkable memory, which presumably included data in cache that had been put there by the current query. Since the exact moment that this threshold was crossed would vary from run to run, and as I assume that what the cleaner thread would evict from memory would also vary, this explained the different query times and Profiler activity. As soon as I moved onto a 64-bit box with no other databases this stopped happening.

Of course nowadays I would expect that most people are running on 64-bit so it’s much more unlikely that you’ll ever cross the LowMemoryLimit, but I do see it happen from time to time. So if you’re in the same position and suffer from inconsistent query performance, check your memory usage!

Up Link Partner cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!4430.entry


GRAB SOME!

Go Daddy $1.99 Domains


SQL Server Conference in Italy

Digg!

I'm doing some work with Marco Russo and Alberto Ferrari at the moment, and for the benefit of any Italian (or Italian-speaking) readers

of this blog I thought I'd mention that they are involved in organising a SQL Server conference near Milan. You can find out more and register here:
http://www.sqlconference.it/

It looks like they've got a lot of good BI/Analysis Services content...

Up Link Partner cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!4217.entry


GRAB SOME!

Find, Buy & Sell Domain Names

Windows Live Invitations – The Domain’s I block but keep getting invites from

Digg!

The spam invites keep pouring in! I have put together a list of some of the Top Level Domains I keep getting Windows Live invites from, regardless I have blocked these Domain’s using Hotmail’s Blocked Senders setting, but its just not working. Here are some of the notorious domains I have blocked but still keep on getting spam from: @163.com, @example.com, @wang.com, @yahoo.cn, @msn.cn, @live.com.cn, @sina.com. Thats just the tip of the ice berg.



Spammers

Some of the well known senders of Windows Live Invitation spam

The spam issue issue getting very frustrating. I can’t be going to my inbox every morning just to be spending most of my time trying to clear out spam and trying to tell who is not a spammer. The Blocked senders is obviously not working. If you have any tips about how to control this increasing problem with Windows Live, please feel free to share.

Previously

To the Hotmail Team – your Junk Filter is not working
Windows Live: The Spam Issue – Its putting a damper on the Service
The Issue of Windows Live, Privacy and Spam
The Amount of Windows Live Invitation Spam is Unacceptable
CNET: Microsoft ranked fifth worst spam service ISP

Up Link Partner adacosta.spaces.live.com/blog/cns!E8E5CC039D51E3DB!21924.entry



UPDATE: Windows Internet Explorer 8 RTM Review

Digg!

I have added some performance results for Internet Explorer 8 vs Firefox 3.0.7 using a broad band connection, you can see them in the second table below. Thanks to Jeff Hatfield for the help with this test.

It has been in development for a long time now with the first beta released back in March of 2008. Microsoft is once again back on track with regular releases of the Internet Explorer. Version 7 released back in November of 2006 was what some would say a necessary release that infused the platform with new momentum and reinsured its trust in end users while keeping Mozilla Firefox at bay, who are also continuing their fight against IE with the Firefox 3.5 release which by the way offers some new nifty features. The fundamentals of this Internet Explorer release revolve around Microsoft’s security initiatives, improved compatibility and developer experience. Microsoft also took a different approach to beta testing this release of Internet Explorer, instead of the usual private testing phase then a public test, the Company started out the gate with a public release for the first beta which I consider to be a welcome change to how it engages with customers. It proves that the Company is interested in what we say and want us to help shape the future of the browser which should be a good opportunity.

Setup1 Setup2 Setup3
Setup4 Setup5

Installing Windows Internet Explorer 8 RTM 64-bit

Setup:

Internet Explorer 8 is available for Windows XP x86, x64, Server 2003 x86, x64, Vista x86, x64, Server 2008 x86 and x64. Phew, that’s a lot; I wish the IE Team would just consolidate this down to just two executables, 32 and 64 bit. I focused on testing IE 8 on Vista 64 bit. Installation is a quick and easy 5 step process requiring one restart to complete setup. When you launch Internet Explorer 8 for the first time, you are presented with a configuration wizard; this basically enables features such as Suggested Sites for discovering similar sites of interest based sites you visit. Also, you can let IE gives you the option of choosing a whole sale of Windows Live branded services and tools for Internet task such as Search, Translation, Mapping, Email, Definition and Blogging along with search and compatibility.

Setup 6 Setup 7 Setup 8

Post setup

First Experience

It seems the toolbar area has taken a definite step back, especially where it concerns screen real estate. I respected IE 7’s focus on consolidating and simplifying the Interface. Now with IE 8 where there were only two toolbars, now there are three layers, not to mention the occasional pop-up banner and the fact that the Tab toolbar shares space with a set of browser controls such as Home, RSS, Email, Print, Page and Tools makes the Interface look like a total kludge. I will admit, I don’t own a 24 inch wide screen Dell LCD, but I do own a 17 inch Dell CRT which maxes out at 1024 by 768, so you basically get the idea that I am in a squeeze here. As for that additional toolbar, it’s called Favorites Bar, a place that host snippets of subscribed content from sites you regularly visit. Although you can remove it by right clicking the toolbar and uncheck the Favorites Bar option, it will return to its original state when the Web slices feature is invoked. What the IE Team could have done here was to make the IE 8 Add Favorites buttons be integrated to left of address bar similar to the Refresh and Stop buttons. It would seem like a logical idea that un-clutters the interface and streamline its look and feel, Firefox 3 already has a similar feature.

Checkout: What I like about Internet Explorer 8

Internet Explorer 8 introduces a lot of ease of use comforts though; areas such as the Address Bar are now streamlined to make navigating the interface a sure pleasure for surfers. Auto Completion now suggest websites that you might want to go to, suggestions are based on your history of websites you like to visit, your personal web browsing history and Feeds that you have subscribed to. Typing in a URL offers some address bar tricks, if you click the arrow below the URL in the middle, it will reveal a number of commands:

  • Go to – Enter

  • Navigate to – Ctrl + Enter

  • Open in a new tab – Alt + Enter

  • Open in a background tab – Alt + Shift + Enter

Hands down, this beats Firefox in the Power User category, offering a faster, more intelligent browsing experience. It also lessens the repetitiveness of common takes that users often do in the browser. One thing would have made this feature even more friendly and powerful, an actual command key to reveal the commands, instead of shifting between the keyboard and mouse. Changes such as a single Favourites button, chrome based skin with a flatter appearance and removal of the Tools and Feeds menu (but changes back to Feeds when browsing), are now pushed under the chevron. Taking the spotlight are Web Slices, Read Mail and Safety. Internet Explorer 8’s Address bar also details information such as the type of application protocol along with the domain name and top level domain name. It might not seem readily useful but makes it easier to identify the security of a website along with the domain name.

The search box features new convenience improvements to its search facilities, providing more detailed options when text is typed in called Visual Search. For instance, based on your search history, a list of Search option links are listed by the Search Engine of choice. Type in ‘Mariah Carey’ for example and you will see a number of query filters, which could range from lyrics, songs, soundboard, news, jokes or popular topics. Search suggestions can also be populated based on your history. If you want to get the latest weather report without going to a weather site, Live Search provides results right there, simply enter your location. I also love the new tabbed Search on the fly option which allows you to quickly change Search engines based on your query. I use Wikipedia a lot, it’s very cumbersome having to type in the query through Google, search for it then open Wikipedia. With this feature, you are take immediacy to the source, which is sure to be a hit with those who want a more detailed browsing experience with better results.

Internet Explorer 8 also improves Tab management with Color coordinated tabs a fun, useful way to keep track of the many websites you might have open in the web browser. Whenever you open a link in a tab from within an existing tab, it creates a color set indicating the tab from which it was opened. Coordinated Tabs also works in ‘Quick Tabs’ view and ‘Tabs List’.

Accelerator and Web Slices

Integration with Windows Live would of course be a must. You can see this already through the Search Field, but version 8 takes it a little further by integrating it deep into other parts of the browser, such as the contextual menus called Accelerators. For instance, right clicking a link gives you a choice of options such as blogging with Windows Live Spaces, email with Live Mail or Translate through Windows Live. Highlighted text on a page adds additional options such as Searching through your Default search engine define with Encarta and even search through Live Maps. Users familiar with Smart Tags in Microsoft Office might also find the Accelerator menu share some distant similarities; it gives you additional options for finding and management of these extensions. It ultimately eliminates the mundane task of copying text back and forth between web pages. Internet Explorer 8 introduces Favorites Bar which includes the new Web Suggestions feature for finding similar sites of interest for a particular website you are browsing. Another unique addition in IE 8 is Web Slices which allow for sections of a web page to be subscribed, stored and monitored from the Favourites Bar without having to go to the actual site. The success of Web Slices will ultimately depend on how many web pages out there decide to support it, also It doesn’t work for me sometimes, for example, I tried to get the weather update from a web slice I created for ‘Kingston, Jamaica’ but IE refused to display the results, instead, displaying only a ‘page not available message’. It’s a neat idea though that promises to make information obtained from the Internet more personalized.

Developer and Compatibility

Microsoft has not forgotten about improved performance and compatibility. The browser definitely feels snappier, using IE 8 on a mobile phone connection web pages load respectably faster, it seems like some significant changes have been made to the caching engine itself. The IE 8 Team have noted that considerable improvements have been made to the HTML parse, CSS engine, Jscript runtime and the associated garbage collector. Version 8 offers a compatibility layer, so that sites designed for an older version of the browser will continue functioning as normal. Common problems you might see if a website is not updated to support the latest features in the browser include, out of place menus, images, or text. An integrated contextual compatibility button built into the address bar appears next to the Refresh and Stop button whenever compatibility issues are detected, when clicked it refreshes the website and presents it in its original state as if you were browsing in a supported version of the browser, nice! What I notice when you do enable Compatibility mode is, you lose access to some of the new features of the browser.

Performance

To really gauge its performance I believe I have the perfect setup, my Motorola 350 cellular phone which I use as a dial up modem. To be honest, you are not gonna notice any major difference between the browsers speed if you are running on a DSL connection since pages just load instantly. With the dial up configuration I was able to see some nuances and indicators that proved which browser and which version definitely is faster when it comes to surfing.

Dial up

  Windows Internet 8 Explorer RTM Mozilla Firefox 3.0.7
ActiveWin.com 2 mins 01 sec 31 seconds
NeoWin.net 1 min 17 secs 44 seconds
MSN 2 mins 50 secs (NA) 2 min 53 secs (NA)
Yahoo.com 40 seconds 1 min 05 secs
OSNews.com 53 seconds 20 seconds
Arstechnica.com 40 seconds 40 seconds
Twitter.com 35 seconds 44 seconds
Microsoft.com 1 min 39 secs 1 min 48 secs
YouTube.com 57 seconds 1 min 24 secs
Google.com 25 seconds 6 seconds
My Blog – Live Spaces 2 mins 15 seconds 1 min 15 secs
CNET News 45 seconds 36 seconds
eWeek.com 3 mins (NA) 59 seconds
Microsoft-Watch.com 40 seconds 14 seconds
Macworld.com 1 min 12 secs 1 min 12 secs

NA – Website did not load in a reasonable amount of time to be considered acceptable.
My Blog – Live Spaces – http://adacosta.spaces.live.com
ZDNET Blog – http://blogs.zdnet.com/microsoft

Connection – GPRS
ISP – LIME (formerly Cable & Wireless)
Speed – 5 KBs per second

Broad band

  Windows Internet 8 Explorer RTM Mozilla Firefox 3.0.7
ActiveWin.com 15 seconds 15 seconds
NeoWin.net 7 seconds 7 seconds
MSN 5 seconds 6 seconds
Yahoo.com 4 seconds 5 seconds
OSNews.com 4 seconds 4 seconds
Arstechnica.com 10 seconds 3 seconds
Twitter.com 12 seconds 6 seconds
Microsoft.com 7 seconds 5 seconds
YouTube.com 5 seconds 4 seconds
Google.com 2 seconds 1 seconds
My Blog – Live Spaces 1 second 1 second
CNET News 3 seconds 3 seconds
eWeek.com 4 seconds 4 seconds
Microsoft-Watch.com 5 seconds 10 seconds
Macworld.com 1 min 12 secs 1 min 12 secs

 

Connection – Cable
ISP – Comcast
Speed – 1.5 MBs per second

As you can see in the above table, performance is negligible, this also indicates that results will always vary depending on your Internet Connection. Internet Explorer 8 has improved performance in some scenario’s especially with the proliferation of broadband these days. The majority of users won’t notice a difference in load time for pages, but if you are still using dial up, I will conclude though that Firefox remains faster compared to Internet Explorer 8.

The table features a list of some of the sites I visit daily. Well, given the above indications, IE 8 is not so fast and I have even tried comparing a Firefox 3.0.7 install where web pages are not cached and it still beats IE. What Microsoft does best though is fidelity. I notice when I was trying to load the new Facebook, Firefox loaded it quickly enough, but it would not load properly, while Internet Explorer 8 took its time, but loaded up the web page properly. It’s a weird performance test I know, but this how I prove which is faster. My personal satisfaction really depends on the web paging loading fast enough for me to interact with, not necessarily to load all features of the site immediately.

Security, Reliability and Add On Management

The new InPrivate mode allows users to clear any private information such as cookies, visited web pages and the entire session itself. There is also an improvement to Phishing Filter through Smart Screen which puts greater focus on web pages that try to collect personal information from users; it’s great for preventing scamming sites that utilize URLs such as PayPal or known banking merchants. This is done through a black list of known or suspected phishing sites so it’s an ongoing game of cat and mouse, users should still be cautious about how they enter personal information on the web. Internet Explorer 8 ActiveX permissions are more independent allowing users to define how they run depending on the site. Improved reliability (including automated crash recovery and tab restoration), and enhanced support for accessibility standards. IE 8 has a much cleaner, organized way to manage all your Internet Explorer add-ons in simplified categories. This is one area; I had hoped the IE Team would have also applied to the Internet Explorer 8 Options dialog.

Some things I would have liked:

  • Download Manager - trust me, it needs it, I find it very handy in FireFox and Safari - Pause/Resume, Manage.
  • Non-adjacent Selection of text on web pages.
  • Customizable toolbar, I personally wouldn't mind if buttons such as Home, Feeds, Print, Page, Tools and Help were on a another toolbar group such as the Address bar group, I need more real estate for Tab's that's much cleaner. The new Favorites Bar in particular eats up a lot of space.
  • List View layout for Options, similar to Office 2007 Options dialog. Also make the Advance settings a part of the list view Options, this includes: Accessibility, Browsing, International, Multimedia.
  • Make Print Preview utilize a Tab instead of opening a separate window.
  • Close button Tabs like Firefox.
  • One unified 32-bit and one unified 64-bit installer.

Internet Explorer 8 is an excellent update, the focus on improving the browsing experience, relevancy and synergy with Windows Live services, developer productivity and easing compatibility in addition to the features that focus on making the browsing experience more secure, personal and not intrusive will surely give users reason to stick with the platform and might even bring some users over from Firefox which I personally have had problems with in the memory resource department.

Resources:

Download Windows Internet Explorer 8 RTM


Windows Internet Explorer 8 Compatibility View List
Internet Explorer Team Blog
Internet Explorer 8 Add-ons Gallery

Up Link Partner adacosta.spaces.live.com/blog/cns!E8E5CC039D51E3DB!22066.entry




 
Locations of visitors to this page

Bookmark Us | Send this page
Webmaster ::  Otggroup.com :: design :: marketing :: hosting :: Free Sitemap Generator