Microsoft Virtual Academy – MVA is a fully cloud-based learning experience focusing on Microsoft Cloud Technologies. You can access a variety of training content online and become one of the renowned experts in the IT Pro community around the world. MVA provides its users with a virtual university experience: the student can select a course and study the material and then do the self-assessment. By doing so, he will collect points that will promote him to a Bronze, Silver, Gold or Platinum Level. Students on MVA can get access to all the information, statistics and advancements of their training career, allowing them to maintain a long-term relationship with Microsoft. Learning through MVA is free of charge, and you can study the contents at any time and at your own pace.
The MVA platform is hosted on the latest Microsoft Azure technology, which guarantees that your learning experience will flow uninterruptedly for the best online learning experience ever!
https://www.microsoftvirtualacademy.com
When we don't want to others have access to our Stored Procedures, Triggers or Views code, created on a database, you can create and encrypt easily, just by adding a "WITH ENCRYPTION".
Here’s an example to create a Stored Procedure:
- CREATE PROCEDURE encrypted_SP(@var varchar(10))
- WITH ENCRYPTION
- AS
- -- this is an encrypted stored procedure
- print @var
CREATE PROCEDURE encrypted_SP(@var varchar(10))
WITH ENCRYPTION
AS
-- this is an encrypted stored procedure
print @var
Thus, our SP will appear in the Object Explorer as follows:

As you can see, is very simple to create an encrypted stored procedure.
But sometimes, we need (realy) a way to see that code, and its necessary to use third party tools.
This is where the SQL Decryptor Optillect is useful. By accessing our database by this application, with only one double-click on the stored procedure that is encrypted, we can quickly see the code that we want.

Since .NET Framework 3.5, to show the Header row in empty GridView, you need to do some trick like:
List<string> rows = new List<string>(
new string[] { "line1", "line2", "line3" });
rows.Clear();
if (rows.Count > 0)
{
gv.DataSource = rows;
gv.DataBind();
}
else
{
rows.Add("");
gv.DataSource = rows;
gv.DataBind();
gv.Rows[0].Visible = false;
}
Obvious, the “else” condition will be always executed, but this is only for exemplify.
On .NET Framework 4.0, was introduced a new property, who makes the Header always visible without any trick. That property is ShowHeaderWhenEmpty.
<asp:GridView runat="server" ID="gv" ShowHeaderWhenEmpty="true">
</asp:GridView>

Last year we had the WebDay 2010, an event where were announced some news from Microsoft, including the release of Windows Phone 7.
For those who did not attend, you can now see all sessions that are available on Channel9. Who was, could ever remember those sessions that did not attend.
http://channel9.msdn.com/Series/Webday-2010-Portugal

For the first time, will be realized in Portugal the SQL Saturday event, on the 15th April, and it will be organized by SQLPort community.
This is a free event but with a limited number of entries (150).
You can see all details on event official page and make your register too.
http://www.sqlsaturday.com/78/eventhome.aspx

Now you can download the final version of Internet Explorer 9.
Download now
There’s a significant number of useful projects at Codeplex who were meeting with some of our needs.
As such, here are two that already have been useful to me:
As the name implies, allows us to explore an Android device and has features such as:
Copy local files to device Reboot device Reboot device in to recovery mode Open files for viewing / execution locally with the default file type executable Package Manager (Install & Uninstall) Take a Screen Shot (landscape or portrait) etc Allows you to create an Access Point, sharing your local Internet connection, with other wireless devices. Its no doubt an application to be always installed, by the simple way to create a resource like this one.
Employee Info Starter Kit is an open source project that is highly influenced by the concept ‘Pareto Principle’ or 80-20 rule, where it is targeted to enable a web developer to gain 80% productivity with 20% of effort with respect to learning curve and production.
It is intended to address different types of real world challenges faced by web application developers when performing common CRUD operations. Using a single database table ‘Employee’, the current release illustrates how to utilize Microsoft ASP.NET 4.0 Web Form Data Controls, Entity Framework 4.0 and Visual Studio 2010 effectively in that context.
More information on codeplex project site.
Who has not seen the Code Project's Tech Virtual Summit on Mobile Development, you can now see all the sessions on demand.
The sessions are:
- The Mobile Development Landscape
- Android Push Notifications
- Beginning Android Flash Development
- Android for .NET/C# Developers Using MonoDroid
- iPhone 101: Introduction to iPhone and iOS Development
- Building Rich Mobile Apps with HTML5, CSS3 and JavaScript
- Building MVVM apps for Windows Phone 7
- Using Panorama and Pivot Controls for WP7 apps
- Building Data Visualization Applications for Windows Phone 7
To access the sessions, you need to register at the following link:
http://www.virtualtechsummits.com/Register.aspx?EventID=11
Hello everyone, this is only a Hello World post, just to start my English blog.
I'm blogging since a long time ago, but in Portuguese. You can follow up my other blogs in http://oito.geracaohd.com and http://pontonetpt.com/blogs/TiagoSalgado
Hope i can update this space regularly.
See you in next post.