Moustafa Arafa Blog : SQL 2008

How to set parameters' values to SSIS packages

Mostafa Elzoghbi — Thu, 13 Jun 2013 17:20:00 GMT

Hi, This post to walkthrough step-by-step how to pass parameters to a SSIS package. Usually you have set of parameters and you want to set the values at run time before the package runs. The methodology that i will implement in this post, is to export...(read more)

How to parse comma delimited string into IN Clause in SQL Server

Mostafa Elzoghbi — Thu, 13 Dec 2012 22:22:00 GMT

Hi Folks, Today i was trying to pass multi-value parameter into my select query in SQL Server. To accomplish this i stored the multi-value parameter in a comma delimited string. Then, i want to pass it in my IN clause of the select statement. here is...(read more)

Error: unable to retrieve column information from the data source in SSIS

Mostafa Elzoghbi — Wed, 12 Dec 2012 17:55:00 GMT

Hi Folks, I was trying to call a stored procedure from OLE DB Source in SSIS. and i getting this error: "Error: unable to retrieve column information from the data source" I wasn't even able to get the columns returned from this stored procedure...(read more)

Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

Mostafa Elzoghbi - C# MVP — Wed, 02 Nov 2011 17:17:00 GMT

Hi Folks, I was deploying an asp.net website which configured to store session data in a custom databases in SQL Server 2008. After i scripted the whole DB and moved it to a new server and after deploying the website and try to run the application, I...(read more)

Best Practices for SQL 2008 in SharePoint 2010 Farm

Mostafa Elzoghbi - C# MVP — Fri, 28 Oct 2011 14:19:00 GMT

Hi All, In this post i'd like to share with you best practices for SQL 2008 R2 in SharePoint 2010 farm and the operations and configuration that need to be taken in place when installing, configuring and administrating SharePoint 2010. 1) Designing...(read more)

Building PPS solutions in SharePoint 2010

Mostafa Elzoghbi - C# MVP — Sun, 14 Aug 2011 21:56:00 GMT

Hi All, During giving my session in SharePoint "The Conference" in DC, I provided some few links for my attendees that helps them to start working with PerformancePoint Services in SharePoint 2010. To start working with SharePoint 2010 that...(read more)

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Mostafa Elzoghbi - C# MVP — Mon, 09 May 2011 20:09:00 GMT

Hi All, If you are experiencing a problem connecting to your SQL Server 2008 R2 DB server from any remote machine in your network, Please make sure of the following: 1) You are able to ping the machine from the remote server. 2) Try to connect make sure...(read more)

Create Reports by Business users and deploy it to SharePoint 2010

Mostafa Elzoghbi - C# MVP — Tue, 28 Sep 2010 02:54:00 GMT

Hi All, Usually the business users are trying to create reports for their backend DBs. You can build your own Report and deploy it to SharePoint 2010. Without using VS.NET you can develop and create your reports using FREE Reporting tool called "Report...(read more)

Troubleshooting Cloud Service Deployment in Azure

Mostafa Elzoghbi - C# MVP — Thu, 26 Aug 2010 19:46:00 GMT

Hi All, I was working on last few days to deploy a sitefinity CMS website to the cloud on Windows Azure. I faced different problems and stop points while trying to deploy my Cloud service to Azure. In this post i will share the main check points that...(read more)

WebMatrix and RAZOR for web development with no cost

Mostafa Elzoghbi - C# MVP — Wed, 07 Jul 2010 14:10:00 GMT

Hi All, Microsoft released the WebMatrix platform (FREE) that has all you need to build any websites, with WebMatrix you can do: 1) Design your websties. 2) Develop/Deploy your websites using RAZOR: is a new declarative simple language to build your websites...(read more)

How to configure Reporting Services 2008 in SharePoint 2010

Mostafa Elzoghbi - C# MVP — Wed, 30 Jun 2010 17:34:00 GMT

Hi All, In This post i will show how to configure SQL Reporting services in SharePoint 2010. If you have a SharePoint 2010 site and you navigate to site settings and try to click on "Managed Services Schedule" you will get this error: Unsupported...(read more)

SQL 2008 Troubleshooting Tip : "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender".

Mostafa Elzoghbi - C# MVP — Tue, 20 Apr 2010 18:58:00 GMT

Hi Folks, I was trying to send Emails using SSIS package deployed in SQL 2008. I was getting this error when i am trying to run the SQL Agent Job which sends Email address on the success of this job. Error message in event log: "Mailbox unavailable...(read more)

Cloud computing in action presentation

Mostafa Elzoghbi - C# MVP — Mon, 22 Mar 2010 14:53:00 GMT

Hi All, Last week i presented "Cloud Computing in Action" presentation in Reston,VA. In this presentaion i talked about Azure cloud computing platform, and i covered the following topics: - Windows Azure - Windows Azure Storage. - SQL Azure...(read more)

Cloud Computing Thoughts with Azure

Mostafa Elzoghbi - C# MVP — Wed, 10 Mar 2010 02:20:00 GMT

Hi All, Today i attended the Government Cloud Computing event at Washignton DC sponsored By Microsoft which held on Ronald Regan Conference center. I had cool conversation with the DPE team and Azure Technical guys in the event with some few business...(read more)

How to shrink SharePoint_Config DB

Mostafa Elzoghbi - C# MVP — Mon, 25 Jan 2010 23:10:00 GMT

Hi all, I had one of my SharePoint Configuration database for one of my sharepoint sites reached 122 GB since i had a problem on having any operation from the FE server to the DB server. My installation for the DB server is SQL 2008, the problem is the...(read more)

How to build your DB on MS SQL Azure

Mostafa Elzoghbi - C# MVP — Fri, 11 Dec 2009 16:59:00 GMT

Hi Folks, I would like to share with you some tips for how to move your on-premise DB to MS SQL Azure on the cloud. First, To be able to connect to SQL Azure Prepare your environment with the following: 1) Install MS SQL 2008 R2 on your machine - Nov...(read more)

WOW... Get Started with SQL 2008

Moustafa Arafa - C# MVP — Fri, 24 Oct 2008 21:09:00 GMT

Hi Folks, New Site has been published for New MS Product SQL 2008, if you are developer,IT Professional or want to know about the product for fun,Get started with this site : http://www.microsoft.com/sql/experience/html/Default.aspx?loc=en Regards, Mostafa...(read more)

Download SQL Server 2008 NOW

Moustafa Arafa - C# MVP — Sat, 11 Oct 2008 17:29:00 GMT

Hi All, Now you can download MS SQL 2008 for 180 Days Evaluations period ,try it : http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx Site contains other very useful demos and virtual labs : http://www.microsoft.com/sqlserver/2008/en/us...(read more)