Author Archives: admin

SQL Server Dumper

SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file.

This program implements the following special features:

  • Foreign Keys> order tables in text file in order to insert data without colisions/errors
  • Primary Key IDENTITY> guarantees the value of the IDENTITY field
  • Reference to itself> eliminates the constraint and at the end create it again

http://sqldumper.ruizata.com/

GMaps Geocoder Accuracy and Zoom level

Geo Address Accuracy

The Google Maps API development team released a small  improvement to their Geocoding API: the ability to get the response’s accuracy level for a given address.

This feature enables applications to modify their zoom level according to the precision of the address that’s being geocoded, for example, “Paris” at the city zoom level, but “1 rue Royale, 75008 Paris” at the much more precise street address zoom level.

What the Google geocoder actually outputs (see reference) is a value between 1 and 8. And the GMaps zoom level is an integer between 1 and 19. So the question is: given a geocoding accuracy, which zoom level should I use to display the place? I didn’t find any answer to that question on the web so I decided to make up my own correspondence between the two scales.

Any such correspondence is bound to be imperfect since two different cities can have very different sizes, however the method usually outputs a decent result.

read more »

TreeView.SelectedNodeChanged Event, doesn’t fire

Occurs when a node is selected in the TreeView control.

If we assign any URLs to the NavigateUrl propery of the TreeNode, it will render as a <a> tag, it will not do postback, so it will not file the event;

If we do not assign any URLs to the NavigateUrl propery of the TreeNode, it will render as a short JavaScript which used to postback.

So I think maybe you have assign URLs to the NavigateUrl propery of the TreeNode.

 

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.treeview.selectednodechanged.aspx

http://forums.asp.net/t/1361178.aspx/1

SQL SERVER – Insert Data From One Table to Another Table

INSERT INTO SELECT – SELECT INTO TABLE

Following three questions are many time asked on this blog.

How to insert data from one table to another table efficiently?
How to insert data from one table using where condition to anther table?
How can I stop using cursor to move data from one table to another table?

There are two different ways to implement inserting data from one table to another table. I strongly suggest to use either of the method over cursor. Performance of following two methods is far superior over cursor. I prefer to use Method 1 always as I works in all the case.

read more »

ASP.NET GoogleMaps User Control

GoogleMaps.Subgurim.NET is the most advanced Google Maps control for ASP.NET 2.0.
Making available the full power of the official GoogleMaps API, yet without the need of a single line of javascript code: you code only in ASP.NET!
To get going, you just drag the control from the toolbox onto the Visual Studio design surface, and with a few lines of code you will be able program powerful Google Maps applications!

http://en.googlemaps.subgurim.net

Microsoft Lync

Windows 8 is going to be including a client hypervisor running a version of Hyper-V

  • Hyper-V on Windows 8 client will require 64 bit and SLAT
  • It will support small to large VMs.  The VM size noted included 32 processors and 512 GB of RAM!
  • Console views for virtual machines can support up to 1600 x 1200 (nice, as I have that resolution on my PC)
  • Support for VHD and VHDX
  • “Live Storage Move” capabilities
  • Virtual Machines with using wireless NICs on hosts
  • Physical machine “sleep” still works (major change from previous releases)

source links:

  • http://media.ch9.ms/ch9/cddc/8b132177-428a-4b5d-8267-9f560134cddc/HyperV09062011_low_ch9.mp4
  • http://blogs.msdn.com/b/b8/archive/2011/09/07/bringing-hyper-v-to-windows-8.aspx
  • http://lync.microsoft.com/pt-br/Paginas/default.aspx
  • http://www.microsoft.com/download/en/details.aspx?id=21129
  • http://office.microsoft.com/en-us/communicator-help/video-what-is-lync-2010-VA102056728.aspx

Testes a velocidade da sua ligação

Speedtest: http://www.speedtest.net/
seepd.io: http://www.speed.io/index_en.html
Speakeasy: http://www.speakeasy.net/speedtest/
Ookla Net Metrics: http://www.ookla.com/
My Speed: http://myspeed.visualware.com/
Bandwidth Place: http://www.bandwidthplace.com/
PC Pitstop: http://www.pcpitstop.com/internet/bw.asp
Speed Test Tool: http://www.internetfrog.com/mypc/speedtest/
my-speedtest: http://www.my-speedtest.com/pt/
McAfee Speedometer: http://us.mcafee.com/root/speedometer/default.asp
Internet Speed Test: http://www.whatismyip.com/speedtest/index.asp
PC911: http://www.pcnineoneone.com/speedtest.html
T1: http://www.t1shopper.com/tools/speedtest/
SG Broadband: http://www.speedguide.net/speedtest/
Speedtest2: http://www.speedtest2.com/
A Beltronica: http://www.abeltronica.com/velocimetro/pt/?idioma=uk
PT: http://qos.sapo.pt/
Speedmeter FCCN: http://speedmeter.fccn.pt/
testesuavelocidade: http://www.testesuavelocidade.com.br/
testeseuping: http://www.testeseuping.com.br/
Copel: http://speedtest.copel.net/speedtest.swf
RJnet: http://www.rjnet.com.br/1velocimetro.php
Velocimetro: http://www.velocimetro.com.pt/index.html

Kim DotCom interview

Liberalização .pt – Sunrise de 1 Março a 1 Maio

O registo de domínios na hierarquia .PT vai ser livre a partir do dia 1 de Maio, tal como acontece com os domínios .COM, .NET e .ORG.

Para evitar que o seu nome ou marca seja registado por terceiros poderá registar o seu domínio .PT com a Esoterica a partir do dia 1 de Março com novas regras:

Pessoas Singulares
Podem ser registados domínios que correspondam ao nome do titular, estabelecimento em nome individual, marca (mista ou verbal), nome de estabelecimento (mista ou verbal), logótipo, nome artístico ou nome profissional.

Pessoas Colectivas
Podem ser registados domínios que correspondam ao nome da pessoal colectiva, marca (mista ou verbal), nome de estabelecimento (mista ou verbal), logótipo, nome artístico ou nome de publicação.

Se o seu domínio se enquadra nas opções indicadas acima pode já efectuar o registo   a partir de 1 de Março, sem ser necessário aguardar pela liberalização do registo de domínios .PT

HTML5 features that we can use in all our projects right now!