Report Data Window in Sql Server Business Intelligence Development Studio

Report Data window in Visual Studio 2008 / SSRS 2008 / SQL Server Business Intelligence Development Studio

Microsoft has placed option for report data window in unusual place. You would expect it in View -> Other Windows section but it is located on the bottom of View option in the menu bar.

Changing fritzbox 7270 DNS Servers to OpenDNS

Step 1: Enable Telnet access in the Fritz!Box

Dial # 96 * 7 * from a connected telephone to the box. You will hear a short tone, from now on it will be enabled until disabled.

Step 2: Connection to the Fritz!Box

From windows based operating system, a telnet command is available. Use command prompt and type "telnet Fritz!Box" or "telnet 192.168.1.1" assuming its ip of the router. If you can not use this command, use "putty", a utility to connect to the Fritz!Box. Upon successful connection to the box, it will ask for the password for the web interface.

Step 3: Edit Configuration File

After successfully connecting to the box, it shows the console of the Fritz Box. It shows BusyBox running system. First to navigate with "cd / var / flash" in the firmware directory.

Next, you open the editor with the configuration file "nvi ar7.cfg.

Commands:

cd / var / flash
nvi ar7.cfg

NVI is editor command for unix so you are editing configuration file using above commad. In the file search for lines: "overwrite_dns1 = 0.0.0.0;" and "overwrite_dns2 = 0.0.0.0;.

Search command is "/" followed by

These lines must be replaced by the OpenDNS servers. Replace them with: overwrite_dns1 = 208.67.222.222; overwrite_dns2 = 208.67.220.220;

To start edit give NVI command "i"

Note: The entries are found in the file 2 times, you have to replace both. Now you can save the file and exit NVI editor.

:w to save and :q to quit the editor.

Restarting The Fritz!Box by entering reboot command. After the successful reboot new DNS server is used.

Note: If you made a mistake and the configuration file is corrupted and the box is automatically set to factory defaults.

Step 4: Disable Telnet access in the Fritz!Box

Dial "# 96 * 8 *" from the phone connected to Fritz!box to disable the telnet access again.


Disclaimer:
I take no responsibility of any harm if it may cause to your Frtiz!Box.

Extending XSD TableAdapters : Dynamic SQL

Objects or typed tables is the preferred way of interacting database but creating those objects and then serialising is not an easy deal if done manually. There are many 3rd pary OR mapper providers for .Net. LLBLGen is one which I used while working in .Net 1 and 1.1

After TableAdapters were introduced in ADO.NET 2.0 creating typed tables (objects) is piece of cake and Visual Studio 2005 has wizards to create the whole Data Access layer by "drag and drop". It uses XSD to create as many schemas per project you like and each schema can have as many typed objects (TableAdapters) you like. TableAdapter lets you connect to a database, run queries or stored procedures, return a new table or fill existing DataTables.

I am not going to create a tutorial for this topic and there are many "How-to" articles available on internet. But soon after you go through "Hello World" type of scenario, you realise that you need to create a table adapter which could cope with any number of parameters at run time. Luckily I found an interesting article about Extending TableAdapters for Dynamic SQL on code project and as usual I was saved from re-inventing the wheel. Here is the link.

http://www.codeproject.com/vb/net/tableadapter.asp

Learn to Use Compass - Scouting Skills

Its been ages since I was soucting last .. about 14 years to be exact and learnt how to use compass while hiking trips.

Following is an excellent site to learn how to use compass, read maps etc ...

http://www.compassdude.com/

Accessing 3 GB of memory space in 32 bit OS - LARGEADDRESSAWARE apps

Step 1:
Update boot.ini - change operating system section like following so you have option to boot with both of the option as required:

[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Microsoft Windows XP Professional 3GB" /fastdetect /noexecute=optin /3GB
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Microsoft Windows XP Professional" /fastdetect /noexecute=optin

Step 2:
use editbin.exe to make app aware of large address space:
edibin.exe /LARGEADDRESSAWARE <app.exe>

editbin is usually in: :\programe files\microsoft visual studio 8\VC\
To change it back: edibin.exe /LARGEADDRESSAWARE:NO <app.exe>

References:
Memory Support and Windows Operating Systems
Additional information and help with the boot.ini
A discussion about the Bootcfg command and its uses
Driver may not be loaded with the /3GB switch
http://support.microsoft.com/?kbid=316739
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328269

Enterprise Library 2.0 Configuration Console customisation

While working on a project to customise EL2.0 configuration console I spent ages to find relevant material on internet but after initial searh I understood articles/posts are scattered or quite difficult to find. Main purpose of this post is to put the link I found together.

Very first article comes after a quick search is http://blog.hishambaz.com/archive/2005/01/30/197.aspx

But it seems that domain is down and the only way to find it was to get it from cache/archive. Hence the following link should work:

http://web.archive.org/web/20060527200135/http://blog.hishambaz.com/archive/2005/01/30/197.aspx

Speed Development With Custom Application Blocks For Enterprise Library
http://msdn.microsoft.com/msdnmag/issues/06/07/PatternsAndPractices/default.aspx

Some of the foundation/basic articles:
Unraveling the Mysteries of .NET 2.0 Configuration
http://www.codeproject.com/dotnet/mysteriesofconfiguration.asp

Decoding the Mysteries of .NET 2.0 Configuration
http://www.codeproject.com/dotnet/mysteriesofconfiguration2.asp

Creating a Simple Configuration Section Handler Using ASP.NET 2.0
http://aspalliance.com/924

Enterprise Library 2.0: Building Named Extensions in the Configuration Console
http://www.developer.com/net/net/article.php/3595371

Enterprise Library Integration
http://msdn2.microsoft.com/en-us/library/ms998170.aspx

Adding Configuration Support for Custom Providers in Enterprise Library in ASP.NET 2.0
http://www.devx.com/dotnet/Article/33476

Reference Article:
Creating Custom Providers for Enterprise Library
http://www.devx.com/dotnet/Article/33055

I hope this post saves some time for others.