Recover your DB from Log Files in MS SQL DBMS

Hi Folks:

I got a call from one of my friends "Fady" regarding one of the guys dropped his tables without taking a backup of his DB.

This is my Support and answer to him.

"
Dear My Firend Fady,

Regarding your question yesterday, for that person who Dropped his tables, anyways this email has good news for him, as I told you he can recover the DB from its log file, simply pass these Urls to him, to recover your DB from Log File.

Urls:

http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html

http://www.apexsql.com/sql_tools_log.asp

"

Hope this help you guys.......


Regards,
Moustafa arafa

November Rosario CTP now available

7 days after Visual Studio 2008 RTM’d, we have a preview of the next version of VSTS available. Get it while it’s hot.


http://blogs.msdn.com/jeffbe/archive/2007/11/28/november-rosario-ctp-now-available.aspx

I'm happy to announce that the next Community Technology Preview of Rosario (officially known as Microsoft® Visual Studio® Team System code name “Rosario” November 2007 CTP) is now available. Customers can immediately begin downloading the VPC images from our download page.

For this release we worked on a number of key scenarios that we'd like you to try out. To help facilitate your evaluation, we've included samples and walkthroughs within the VPC to demonstrate these new features. Here's a list of walkthroughs broken out by product:

Architecture Edition
• Visualizing Interaction Sequences between Service-Oriented applications
• Using the Distributed System Designers and the Web Service Software Factory to build WCF applications
• Designing and Visualizing Interactions between classes
Development Edition
• Simplify Code Analysis rule selection with Rule Sets
• Find and fix a bug using the historical debugger
• Identify the test impact of code changes
• Find a bug on a separate machine using the standalone debugger
Test Edition
• Planning a testing effort
• Executing manual test cases
Team Foundation Server
• Managing user stories with the Agile Process
• Managing features with the CMMI Process


Read more on Jeff Blog :

http://blogs.msdn.com/jeffbe/archive/2007/11/28/november-rosario-ctp-now-available.aspx


Regards,
Moustafa arafa

Part 2 : when ? where ? i have to use NotBot Ajax control

Hi Folks,

I got some questions regarding the using the NotBot Ajax control : Where we can use it ? when ? and some visitors requires the code to use this control.

The answer of when ? You have to plug NotBot Control on your business applications,if it uses Forms authentication then you can put it on Login Page,OW you can put it on your master page incase your site for anonymous users.

The answer of where ? You can drop it on your login page or your master page instead of putting it on each page of your applications or websites.

The code you have to put : (in C#)

protected void Page_Load(object sender, System.EventArgs e)
{
if (!NoBot1.IsValid())
{//trying to automate requests to the page....
// to do..............

}

Hope this helps.....

Regards,
Moustafa arafa

Part 2 : when ? where ? i have to use NotBot Ajax control

Hi Folks,

I got some questions regarding the using the NotBot Ajax control : Where we can use it ? when ? and some visitors requires the code to use this control.

The answer of when ? You have to plug NotBot Control on your business applications,if it uses Forms authentication then you can put it on Login Page,OW you can put it on your master page incase your site for anonymous users.

The answer of where ? You can drop it on your login page or your master page instead of putting it on each page of your applications or websites.

The code you have to put : (in C#)

protected void Page_Load(object sender, System.EventArgs e)
{
if (!NoBot1.IsValid())
{//trying to automate requests to the page....
// to do..............

}

Hope this helps.....

Regards,
Moustafa arafa

Secure your Website by using NoBot Control on asp.Net Ajax

Hi All,

Today i have used one of the important controls on ajax framework which secure my website/Application from automated attacks on your websites in away to hack your application without any human interaction.

NoBot is a control that attempts to provide CAPTCHA-like bot/spam prevention without requiring any user interaction. This approach is easier to bypass than an implementation that requires actual human intervention, but NoBot has the benefit of being completely invisible. NoBot is probably most relevant for low-traffic sites where blog/comment spam is a problem and 100% effectiveness is not required.


NoBot employs a few different anti-bot techniques:

1)Forcing the client's browser to perform a configurable JavaScript calculation and verifying the result as part of the postback.
2)Enforcing a configurable delay between when a form is requested and when it can be posted back.

NoBot can be tested by violating any of the above techniques: posting back quickly, posting back many times, or disabling JavaScript in the browser.


add it on your application and secure it by checking on NotBot status and add your custom behavior for catching website spams.

Read More :

http://en.wikipedia.org/wiki/Captcha

http://asp.net/learn/ajax-videos/video-141.aspx



Regards,
Moustafa arafa

CDO Error when creating Person Object

Dear All,

If you are using CDO DLL for Integration with Exchange server in your application,you might face problems when you are trying to initiate an object from CDO.dll Class Library.

i used to create contacts in exchange server,and my application was working fine with cdo.dll after migrating to vs 2005,the cdo stop working,after alot of investigation,i found that the dll wasn't registered on .net framework 2.0 and register on .net framework 1.1,this is one of my bad luck...and to see the related posts,kindly visit below links :

http://forums.asp.net/p/1002362/1996021.aspx#1996021

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=310987



ex.Message "Retrieving the COM class factory for component with CLSID {CD000107-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 80040154." String

to fix it,register the cdoex.dll on .net framework 2.0 :

regsvr32 cdoex.dll

This will fix the problem..........


Happy .Netting.



Regards,
Moustafa arafa

ASP.Net 2.0 Tip : CSS is not applied on my aspx page

Hi Folks,

You might face this problem on asp.net 2.0,if you create an aspx page and you reference the css file on the header of this page,you will face that the css classess are not applied on that page even if the css reference is right.

And css link is working on other pages but is not working on the new created page.

The workaround of this issues is to remove the below line of the html code :



!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"


this will instantly apply the css classes on your page.

Happy .Netting..... :)


Regards,
Moustafa arafa

Release of VS 2008 & .Net 3.5 by the end of november

Hi All,

For those who didn't go to TechEd 07 this year which is running nowadays,MS Announced the release date for VS 2008 and .Net 3.5 by the end of november this year.

It is amazing specially the release of .Net 3.5 which has alot of enhancement and new features which doesn't exist on .Net 3.0.

Read more on MS Press :

http://www.microsoft.com/presspass/press/2007/nov07/11-05TechEdDevelopersPR.mspx


Regards,
Moustafa arafa

Next Event : TechNet & MSDN Road Show @ Gulf

Hi Folks,

Execlusive to my blog readers,the agenda of Gulf TechNet & MSDN Roadshow.

Next Event will be held on Gulf during november-Dec based on your location.

Register now :

https://profile.microsoft.com/RegSysProfileCenter/wizard.aspx?wizid=e1dcb941-a365-4d4b-8e0f-1c3a8946ecb1&lcid=1033

For Kuwait : its on 14th of November 07 - Movenpick
Read more on the event site .


Dates

City Venue Date
Kuwait Movenpick Hotel Wednesday Nov 14th
Oman Shangri la Hotel Saturday Nov 17th
Bahrain Sheraton Hotel Monday Nov 19th
Dubai Habtoor Grand Hotel Tue/Wed Dec 4 & 5
Qatar Intercon Hotel Sunday Dec 9th

Agenda


TechNet Track Speakers MSDN Track Speakers
Session 1 - UC
Session 2 - WS08 First Look at Visual Studio 2008 - Part I

First Look at Visual Studio 2008 - Part II


Lunch
Session 3 - System Center Configuration Manager
Exploring the Building of Software + Services Applications
Session 4 - Data Protection Manager Best Practices for Team-Based Software Development
Break
Session 5 - Virtual Machine Manager IIS7, Orcas & Team System
Session 6 - SQL Server Building Silverlight Applications Using .NET
Closing and Raffle Closing & Raffle




Regards,
Moustafa arafa

Astoria

Hi Folks,

New tool has been shipped to expose your data on your applicaitons as Data Services,These data services can be used by Ajax web enabled applications.
This tool provdes the facility to expose your data over HTTP which is an added value for your application to easily consume the edata exposed by Astoria SDK.



Download Sept CTP :
http://www.microsoft.com/downloads/details.aspx?FamilyID=0FA1413C-CB55-4577-960E-0F3491847F58&displaylang=en

Regards,
Moustafa arafa

VSTS Mind Map

Hi Folks,

You can check VSTS Mind Map which contains alot of resources,Guide,Blogs...etc and all related to VSTS.

Check it :

http://www.cshost.members.winisp.net/blog/vstsresources.html

Regards,
Moustafa arafa

Ajax Activity Loading Controls

Hi Folks,

if you want to get nice gif files you want to use in the progressBar control,simply check the below checks :

http://mentalized.net/activity-indicators/
http://www.ajaxload.info
http://www.napyfab.com/ajax-indicators/

Enjoy to use them all....its free.




Regards,
Moustafa arafa

Free Blog Engine

Hi Folks,

I have found new and open source Blog Engine built on .Net with source code.

Download url:

http://www.codeplex.com/blogengine/Release/ProjectReleases.aspx?ReleaseId=4459


Regards,
Moustafa arafa

Groove vs. Sharepoint

Hi All,

Big confusion between 2 MS Products : MS Groove Server and MS Sharepoint Server.

There is a big difference between the 2 products,and since there are similarity on as a collaboration solution but still the projects size which are handled by both products are really different.


Read More about the difference:
http://www.microsoft.com/midsizebusiness/businessvalue/groove.mspx



Regards,
Moustafa arafa

MSDN Gulf newsletter Issue 2

Hi Folks,

MSDN Gulf newsletter issue 2 has been released......subscribe.

http://www.microsoft.com/middleeast/msdn/newsletter/Aug2007.htm


Regards,
Moustafa arafa

WCF Developers,What's new on .Net 3.5 March CTP

Hi Folks,

One of the most important questions for all .net developers,since most of the developers are new on .net 3.0 and its technologies,and meanwhile they heard on .Net 3.5 Beta releases and CTP (now March CTP is availble),to know main changes and difference/fixes and new features on .Net 3.5,i will advice all of you to read Thom Robbins Blog Post for the details of the changes on .Net 3.5 :

http://blogs.msdn.com/trobbins/archive/2007/02/28/microsoft-pre-release-software-visual-studio-code-name-orcas-march-2007-community-technology-preview-ctp.aspx

Hope this helps... :)

Regards,
Moustafa arafa

Problem when installing SQL 2000 Reporting services with .Net 2.0

HI Folks,

if you have .net 2.0 on your server and you want to install SQL 2000 Reporting services, the installation will show that ASP.NET 1.1 is not registered on your web server even if you run aspnet_regiis command for asp.net 1.1 on yor web server.

To resolve this problem :

1) Un Install asp.net 2.0 from your web server by running the command :
aspnet_regiis -u

2) Register asp.net 1.1 :
aspnet_regiis -i

3) Install your SQL 2000 Reporting Services.


4) install your asp.net 2.0 on your web server.
aspnet_regiis -i



Hope this helps.

Regards,
Moustafa arafa

Loading Controls Dynamically problem on ASP.Net 2.0

Hi Folks,

If you load your controls dynamically on asp.net 2.0 web site,you will face a problem that all handlers of server side controls doesn't work and not fire on the server side.

Even you try to put a break point on your server side handler,it will not fire,this is not because of a problem on any of your user controls or your code has something wrong.

the problem is : if you try to write the same line of code on asp.net 1.1 web application this problem will not happen at all,and if you tru to load the same controls on asp.net 2.0 web site the problem will happen.

The solution and Tip for this problem,is to just give an ID for your user control which will be loaded dyamiccly,and the problem will not happen.

This the code which run on asp.net 1.1 perfectly and doesnt run on asp.net website :

C#:
PlaceHolderID.Controls.Clear();
Control c = Page.LoadControl(”UCPath”);
PlaceHolderID.Controls.Add(c);

The Solution :
C#
PlaceHolderID.Controls.Clear();
Control c = Page.LoadControl(”UCPat”);
c.ID = “IDForYourControl“;
PlaceHolderID.Controls.Add(c);

Hope this helps.

Read more on the problem and the solution on Scott Blog :
http://scottonwriting.net/sowblog/posts/3962.aspx







Regards,
Moustafa arafa

Mount your ISO Images on Vista

Hi All,

I tried to mount ISO images and image files on windows vista,and i try all tools i used to mount images and it didnt work on vista.

i looked for a new tool,i found a free new tool to mount your images and ISO files on vista,easy to use...download it now :

http://www.howtogeek.com/howto/windows-vista/mount-an-iso-image-in-windows-vista/


Regards,
Moustafa arafa

WCF Security Limitations

Hi Folks,

i discovered some points which you have to take it in your consideration if you are working to deisgn a WCF solution,specially the security issues with WCF :

1) You can't apply Message Level security with WCF Streaming which is used to pass Large binary data between the service and WCF Clients.

2) In Case you want to apply WCF Streaming on your WCf Host,you have to change your security level from message to transport level.

3) Maximum received message size to a WCF service is 64 KB;if the message exceeds this limit size the WCF runtime will throw an exception.

Note : if you want to increase the Max. Message Size,on the Bindings properties you can change/increase the message size as per your request.


Hope this Tips helps WCF Architect and Developrs :)

Regards,
Moustafa arafa