Tiago Salgado

.NET / SQL Server / IT / etc...


News

My Stats

  • Posts - 37
  • Comments - 26
  • Trackbacks - 0

Twitter












Recent Comments


Recent Posts


Archives


 

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:

  1. CREATE PROCEDURE encrypted_SP(@var varchar(10))  
  2. WITH ENCRYPTION  
  3. AS  
  4.     -- this is an encrypted stored procedure  
  5.     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:

Droid Explorer

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

    Virtual Router – Wifi Hot Spot (Windows 7 / 2008 R2)

    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


     

    Chris Pirillo have made a great video of iPad 2 unboxing.

    See it below


     


    from: http://9gag.com/gag/87566

     

    The final version of Visual Studio 2010 SP1 is available for MSDN subscribers and can be downloaded here.

    For general public, it will be available on Thursday, March 10.

    You can see the annoucement at http://blogs.msdn.com/b/jasonz/archive/2011/03/08/announcing-visual-studio-2010-service-pack-1.aspx


     

    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.