Sign In
Mohamed Sharaf's Blog
My small window to post any technical thoughts. All posts as is.
Options
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
.NET Framework
ASP.NET
General
SQL Server
Archive
Archives
September 2010
(1)
June 2010
(1)
January 2009
(1)
July 2008
(1)
June 2007
(1)
May 2007
(1)
March 2007
(1)
February 2007
(1)
January 2007
(1)
December 2006
(2)
October 2006
(2)
August 2006
(1)
December 2005
(1)
November 2005
(4)
October 2005
(2)
September 2005
(4)
August 2005
(3)
July 2005
(2)
Social Media Sharing
MSDN Blogs
>
Mohamed Sharaf's Blog
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Mohamed Sharaf's Blog
SQL Server 2008 R2 Express
Posted
over 2 years ago
by
Mohamed
0
Comments
Good news for independent developers who are using SQL Express as backend database. With SQL Server 2008 R2, SQL Express supports databases up to 10 GB. For more information and download, go to product site
Mohamed Sharaf's Blog
Free e-book from MS Press
Posted
over 2 years ago
by
Mohamed
0
Comments
Microsoft Press has just released a new free e-book for SQL Server 2008 R2 " Introducing Microsoft SQL Server 2008 R2" Can be downloaded from http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server...
Mohamed Sharaf's Blog
How to handle expired SQL logins’ passwords in client code
Posted
over 3 years ago
by
Mohamed
0
Comments
Microsoft is always advise customers to use the new security features for SQL Logins in SQL Server. As you know SQL Logins are the logins where the login name and password are saved inside SQL Server and SQL Server is responsible for authenticated this...
Mohamed Sharaf's Blog
Moving the tempdb to unknown location
Posted
over 4 years ago
by
Mohamed
1
Comments
One of my friends called me for a problem at a customer site. The problem simple is that the customer wanted to move the tempdb in SQL Server 2005 to a new location but because of a typo the new path of the file is pointing to a folder not a file. Something...
Mohamed Sharaf's Blog
MS File Encryption
Posted
over 5 years ago
by
Mohamed
0
Comments
As I promised in my last post, here's the MS File Encryption program (MS stands for Mohamed Sharaf not Microsoft of course ;)) based on the MSSecurity Library . The application is pretty simple; you can encrypt a single file or entire folder. The application...
Mohamed Sharaf's Blog
Back to MSSecurity library again
Posted
over 5 years ago
by
Mohamed
3
Comments
If you have seen my previous post about the class library that I developed to encrypt text or files using symmetric encryption ( Rijndael algorithm ). So you would already know that it was developed using .NET Framework 1.1. I've upgraded the library...
Mohamed Sharaf's Blog
Cross post with Master pages
Posted
over 5 years ago
by
Mohamed
8
Comments
I got a feedback for the Master Pages post asking about mixing master pages with cross post. Here's the scenario. We have a content page that has one textbox and one button, the page code would be like this <% @ Page Language ="VB" MasterPageFile...
Mohamed Sharaf's Blog
How to move objects from Schema to another in SQL 2005
Posted
over 5 years ago
by
Mohamed
0
Comments
If you are building CLR stored procedure and you want this stored procedure to be part of a schema called xyz. When you write the name of the procedure in the SqlProcedure attribute "xyz.myproc" and deploy this procedure, the visual studio deployed it...
Mohamed Sharaf's Blog
Changing application settings programmatically in .NET Framework 2.0
Posted
over 5 years ago
by
Mohamed
8
Comments
As I promised to provide a component to enable you to change the values of the application-scope settings in .NET Framework 2.0, I'm now providing it. It's a very simple dll written by C#, you can find the Source code here . To use this dll you...
Mohamed Sharaf's Blog
Using application/user settings in C# 2.0
Posted
over 6 years ago
by
Mohamed
10
Comments
This is a quick post for using application or user settings in C# 2.0. I found most of the articles dealing with it in VB which is pretty easy. All you need to access a setting called "ServerName" in Visual Basic is this line My.Settings.ServerName...
Mohamed Sharaf's Blog
Misleading error message when you create foreign key constraint
Posted
over 6 years ago
by
Mohamed
1
Comments
When you create new foreign key constraint in SQL Server 2005 and this constraint conflict with the data already exists in the tables, you will get an error message that might be misleading. Let's say that you have 2 tables (depts and employee) and you...
Mohamed Sharaf's Blog
How to add null value in Management Studio (SQL Server 2005)
Posted
over 6 years ago
by
Mohamed
3
Comments
Updating database tables using Management Studio is a the easiest way during the development phase. If you do so, you probably need sometimes to update column to add a null value instead of the current value. To do so you just need to press CTRL+0...
Mohamed Sharaf's Blog
Using test certificate with Reporting Services 2005 to establish SSL connection
Posted
over 6 years ago
by
Mohamed
4
Comments
If you are planning to publish your Reporting Services site to the internet then you need to secure the communication between the server and the clients. The industry standard to do so is to buy an SSL certificate from a public certificate authority ...
Mohamed Sharaf's Blog
Are you using IE7 and have a problem in accessing some site?
Posted
over 6 years ago
by
Mohamed
2
Comments
Internet Explorer 7 is the newest version of Internet Explorer(IE) will be launched on Windows Vista time. It will also be available for XP SP2 and 2003 SP1 users. It has many fancy features like new rendering engine(you will love it especially in LCD...
Mohamed Sharaf's Blog
Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)
Posted
over 7 years ago
by
Mohamed
70
Comments
If you are one of the people who used and enjoyed SQL Server Reporting Services (SSRS) in SQL 2000 and you wanted to use it in your windows/web applications without the server side components (just like what you are doing with Crystal Reports). So you...
Mohamed Sharaf's Blog
Encrypting configuration files using protected configuration
Posted
over 7 years ago
by
Mohamed
42
Comments
One of the cool security features in ASP.NET 2.0 is the ability to parts of web.config. Web.config encryption uses XML encryption standards at its core. Protected configuration uses a class derived from the abstract class ProtectedConfigurationProvider...
Mohamed Sharaf's Blog
A quick post: Where's my "Sync with table of content"
Posted
over 7 years ago
by
Mohamed
2
Comments
If you are a one who wants to know where's the content that you are reading the in the MSDN library table of contents then you would miss this button in the new Microsoft Document Explorer. Microsoft Document Explorer is the new Microsoft Help system...
Mohamed Sharaf's Blog
VistaDB solved database hosting problems.
Posted
over 7 years ago
by
Mohamed
11
Comments
I've been invited to test a new product, VistaDB . I found it amazing. It's a tiny database engine with huge benefits. VistaDB engine is only a dll with 32 Kb foot print and it works with almost all development platforms (.NET, COM, Delphi , C/C++...
Mohamed Sharaf's Blog
MSecurityLibrary library for symmetric encryption and hashing
Posted
over 7 years ago
by
Mohamed
0
Comments
This time I'm introducing one of the most favorite codes for me. I built this library a year ago while I was working with symmetric encryption. I felt that I need to do it myself instead of using any ready-made components because I either found a very...
Mohamed Sharaf's Blog
How to take your web application offline with simple action [ASP.NET 2.0]
Posted
over 7 years ago
by
Mohamed
1
Comments
If you are deploying your web application and you don't the users to browse your web application until the deployment process finishes or you want to take you web application offline for a while. Just put a file with the name App_offline.htm and write...
Mohamed Sharaf's Blog
The complete picture of ASP.NET 2.0 compilation
Posted
over 7 years ago
by
Mohamed
0
Comments
ASP.NET 2.0 compilation is much different than ASP.NET 1.x compilation. In ASP.NET 1.x there was two classes for each web form: 1) Code-behind class ---> which is compiled inside the assembly in the bin folder along with all other classes for...
Mohamed Sharaf's Blog
You have a problem with Hijri dates and SQL Server?
Posted
over 7 years ago
by
Mohamed
14
Comments
Let’s first discuss the problem. We use Hijri calendar and SQL server uses Gregorian calendar. And SQL server has restriction on the Gregorian dates earlier than 1753. But SQL server saves dates internally in another format (It’s neutral and doesn...
Mohamed Sharaf's Blog
Installing Microsoft Enterprise Library on production servers
Posted
over 7 years ago
by
Mohamed
14
Comments
Many of us encountered a lot of problems when installing Microsoft Enterprise Library on production servers, you may face or see error like " System.Security.SecurityException: Requested registry access is not allowed" Simply to deploy your web...
Mohamed Sharaf's Blog
Simple application configuration reader/writer class
Posted
over 7 years ago
by
Mohamed
5
Comments
app.config and web.config are very powerfull techniques for managing application settings. For more information about using configuration file please check this article in MSDN But the manipulation of these files has 2 issues 1) There’s no class...
Mohamed Sharaf's Blog
Want to ecrypt all your stored procedures with one click?
Posted
over 7 years ago
by
Mohamed
2
Comments
I was working in a small project in which I should deploy the database on the production server with Encrypted Stored Procedures . I had to open each and every stored procedure in the database to add WITH ENCRYPTION keyword to them to be encrypted. I...
Page 1 of 2 (30 items)
1
2