I showed you a while ago the improved SQL Azure management portal. After having nothing in 2008, Project Houston was a great step towards a Cloud only management portal. But December 2011 they renewed the complete SQL Azure management portal. Besides a more Metro look-and-feel they added also some extreme helpful tools and utilities.
When clicking on Administration in the lower left corner, you get an overview of your Database health etc. Information about the utilization of your database, connections and users. In this case the database was fairly new and unused, so the query usage is empty.
On a database with more activities this part of the portal looks like this. Yes, my SQL Azure database are not very busy .
As you click on the Query Performance link, you get detailed information about the queries on your database and their performance. This gives you a first impression about the overall performance of your SQL Azure instance.
Imagine you have a problem with a certain query. I am talking about the performance of course . To get a good view of the query you need a Query plan. Previous your only tool was SQL Server Management Studio and a few SQL Azure Management views.
Ok, this was good. But the downside of this approach was, there was some latency between your client and the SQL Azure instance etc. So it wasnât perfect.
Now with the new portal there support for query plans in the Cloud . Via the portal you can create a new query and this query of course can be executed. But now there a two more options. So there is RUN, Actual Plan and Estimate plan.
With RUN you get the result of your query. Simple as you are used to with the Project Houston site.
But when choosing for Actual Plan, you get an extra tab: Query Plan.
On this tab you get a graphical representation of the query plan. And due to the cool Silverlight 5 environment it looks nicer then the âoldâ SQL Server Management Studio. There are three options: Total, CPU and IO.
Besides that you can also choose for more details by selecting a Grid or tree representation.
More detail can also be in the imaged version of the query plan, if you play with the zoom level.
So how cool is that! There is almost no need for a Client tool like SQL Server Management Studio. Almost everything can be done in the cloud.
QUOTE:Â Clicking âAllowâ will give the scammer access to your Facebook data at any time and the application will be able to post to Facebook as you. This will allow them to spam their scam messages to all of your friends. This particular application is called âPr0file Watcherâ, but scams like this are known to use multiple Facebook apps. Anytime you install a third party Facebook application, you give the application developer access to your personal data. Always be very selective on the apps you install, and only install them from well-known, trusted sources.
QUOTE: We often have readers ask us questions about specific Facebook applications. Some apps generate an enormous amount of spam and can annoyÂ your Facebook friends. Others are outright scams and should be avoided entirely. For example, any application offering to show you who has viewed your profile, who your Facebook stalkers are etc., are guaranteed to be fraudulent. Facebook doesnât allow developers access to the data required to create apps like this.
QUOTE: Last week, we posted a blog informing Android users of the discovery of new versions of Android.Tonclank, which we have named Android.Counterclank. The blog generated a bit of discussion over whether these new versions should be a concern to Android users. When classifying applications, our focus is on whether users want to be informed of the application’s behavior, allowing them to make a more informed choice regarding whether to install it.
Android.Counterclank – SYmantec Malware description http://www.symantec.com/security_response/writeup.jsp?docid=2012-012709-4046-99
PC Magazine: Zscaler – Analyzes URL safety http://securitywatch.pcmag.com/internet-crime/293516-zscaler-zulu-flags-dangerous-sites
Zscaler – Analyzes URL safety (Home Page) http://zulu.zscaler.com/
QUOTE: Security experts constantly warn you to avoid clicking links in tweets, emails, Facebook posts, and so on. Even if the sender is a friend, the link might have been added by a virus. So does that mean you can never check out the latest viral video? Sure, you can do that. Just check the URL with ZScaler’s free Zulu URL Risk Analyzer first.
SuperBowl – Six ways to avoid online scams http://securitywatch.pcmag.com/none/293485-super-bowl-xlvi-6-ways-to-avoid-an-online-scam
QUOTE: Six methods of protection include:
1. Buy tickets from legitimate or licensed resellers 2. DON’T leave sight of the site 3. Pay using encryption (SSL) 4. Scrutinize your ticket 5. DON’T share personal information 6. 6. DON’T fall for online scams
For more, seeÂ 11 Tips for Safe Online Shopping
FaceBook – Valentines Malware themes circulating http://blog.trendmicro.com/facebook-valentines-theme-leads-to-malware/
QUOTE:Â Itâs never too early to get ready for Valentineâs day, it seems, even when it comes to malicious attacks. Recently, I came across a scam in Facebook that leverages the upcoming occasion.Â Â The said attack begins with a post on affected usersâ wall inviting other users to install a Valentineâs theme into their Facebook profile
MS12-004 Early malware attacks starting to appear in wild http://blog.trendmicro.com/malware-leveraging-midi-remote-code-execution-vulnerability-found/
MS12-004 is rated as a highly critical security patch by Microsoft & ISC http://technet.microsoft.com/en-us/security/bulletin/ms12-004
QUOTE:Â Earlier today, we encountered a malware that exploits a recently (and publicly) disclosed vulnerability,Â the MIDI Remote Code Execution VulnerabilityÂ (CVE-2012-0003). (Ed. Note: addressed in MS12-004).Â The said vulnerability is triggered when Windows Multimedia Library in Windows Media Player (WMP) fails to handle a specially crafted MIDI file, consequently allowing remote attackers to execute arbitrary code.
What does your name mean? Find out here â Facebook Scam http://facecrooks.com/Scam-Watch/what-does-your-name-mean-find-out-here-facebook-scam.html
QUOTE: What does your name mean? Find out Here â >Â Installing the application gives the developer access to your basic information. You are also asked on the next screen if you would like to give the application the ability to post to your Facebook Wall. (How nice of them to ask â usually they donât give you the optionÂ The end game of the scam is the follow survey:
Android Counterclank BotNet – Over 1 million downloads http://securitywatch.pcmag.com/none/293451-millions-download-new-trojan-discovered-in-android-market
QUOTE:Â SymantecÂ has discovered a new Android botnet that is still thriving in the Android Market and has already been downloaded several million times this year. The Trojan ‘Android.Counterclank’ was packaged in at least 13 free games published by three different publishers, making it harder to trace. Symantec notified Google on Thursday and at press time, 9 of the apps were still available in Google’s official app store.
According to Symantec researcher Irfan Asrar, âCounterclankâ can carry out commands from a remote control center on your mobile device. According to Symantec’s virus definition, it steals information and can potentially display ads on your device.Â âWhen the package is executed, a service with the same name may be seen running on a compromised device. Another sign of an infection is the presence of the Search icon above on the home screen,â Asrar wrote. No information on geographic scope has been given, but Asrar said that the sheer number of downloads, 1-5 million, makes it the most widespread piece of mobile malware found so far this year.