Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Thursday, January 22, 2009 5:04 PM

How to handle expired SQL logins’ passwords in client code

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
Posted by Mohamed Sharaf | 2 Comments
Friday, July 11, 2008 1:29 AM

Moving the tempdb to unknown location

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
Posted by Mohamed Sharaf | 3 Comments
Filed under:
Wednesday, February 21, 2007 3:53 PM

How to move objects from Schema to another in SQL 2005

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
Posted by Mohamed Sharaf | 0 Comments
Tuesday, December 12, 2006 9:18 AM

Misleading error message when you create foreign key constraint

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
Posted by Mohamed Sharaf | 1 Comments
Filed under:
Monday, October 30, 2006 11:00 AM

How to add null value in Management Studio (SQL Server 2005)

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 It's
Posted by Mohamed Sharaf | 6 Comments
Filed under:
Monday, October 30, 2006 10:08 AM

Using test certificate with Reporting Services 2005 to establish SSL connection

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 (CA)
Posted by Mohamed Sharaf | 4 Comments
Filed under:
Tuesday, December 20, 2005 6:23 PM

Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

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
Posted by Mohamed Sharaf | 73 Comments
Thursday, November 10, 2005 10:23 AM

VistaDB solved database hosting problems.

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++). The
Posted by Mohamed Sharaf | 11 Comments
Filed under: ,
Friday, September 23, 2005 12:53 PM

You have a problem with Hijri dates and SQL Server?

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’t depend
Posted by Mohamed Sharaf | 14 Comments
Filed under:
Sunday, September 11, 2005 12:44 PM

Want to ecrypt all your stored procedures with one click?

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
Posted by Mohamed Sharaf | 2 Comments
Saturday, August 13, 2005 1:19 PM

Passing non-English parameters to reporting services via URL access

Few weeks ago I faced a problem when I was using SQL Server Reporting Services to generate a report in which all parameters' values in Arabic. The problem appeared when I used this report through URL access , and passed the parameters' values throug URL.
Posted by Mohamed Sharaf | 10 Comments
 
Page view tracker