MEA Center of Expertise
We are a 120+ technology enthusiasts helping Microsoft customers around Middle-East & Africa region. We bridge Microsoft tools & technologies to their businesses.
Column Store Index
Free Cool Tools
Lin .NET Code
Lync hardware requirements
lync kit. lync 2010
Lync new features
Lync Port requirements
Lync Server roles
Open Interoperability Program
SharePoint Designer 2010
SharePoint Foundation 2010
SharePoint Server 2010
sql server 2012
windows Phone 7
Browse by Tags
MEA Center of Expertise
Tagged Content List
Update SQL Agent Jobs Schedules with T-SQL
after building your SSIS project and putting it into action you just start doing some JOB Schedules through the SQL Agent, but when you have a lot of schedules updating them starts to get annoying. and you can start getting some queries to list the Jobs, tasks and schedules in our discussion now we’ll...
5 Aug 2012
SQL Server 2012 BI Environment in 12
are you fan of creating VMs? do you like to have your own environment signed by your name as your companion in developing Microsoft BI applications, creating POCs or even trying and learning some new stuff? I Love doing this very much… So I listed below the steps that you need to follow in order...
27 Mar 2012
Can i edit my PowerView Report exported to PowerPoint in Presentation Mode? YES YOU CAN
with the release of SQL Server 2012 different versions until the RTM last week. Microsoft introduced a one kicking feature in the Business Insight Pillar with the new Amazing easy-to-use reporting PowerPivot that you can simply export this report to PowerPoint and when your slides are running the report...
14 Mar 2012
Cumulative Update package 5 for SQL Server 2008 R2
Cumulative Update 5 contains hotfixes for the Microsoft SQL Server 2008 R2 issues that have been fixed since the release of SQL Server 2008 R2. in the middle of the celebrating our new version of SQL Server that will come in the Launch event 1 week from now we need not to forget about the amazing...
29 Feb 2012
Microsoft Egypt Open Door February 20, 21
It’s the time for Open door… Monday and Tuesday in Cairo Heliopolis Fairmont Hotel in Egypt we’re having our annually Open Door even with first day for IT Professionals and second day for Developers. I have a session with Hisham Mortada Monday 12:00 PM for What’s New in SQL Server...
19 Feb 2012
Please join me and welcome "SEQUENCEs" to the family of T_SQL
yes it’s, it’s the Sequence that you can use as a number generator separated from Columns and tables. it’s a new Object added to SQL 2012 ANSI Standard. to be used in many situations. I can remember now that it would made my life easier if I had it before. let’s have a look on...
7 Feb 2012
ColumnStore Index Quick view and Performance test (Video)
SQL Server 2012 introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases,...
6 Feb 2012
Cannot start the columnstore index build; What is Wrong ?
you’re trying to build a ColumnStore Index and Increased the DOP or using multiple columns on the Index and you did received this error message “cannot start the columnstore index build because it requires at least 760040 KB, while the maximum memory grant is limited to KB per query...
5 Feb 2012
Create failed for Index not supported on the target server version. No Panic
ColumnStore Index the New Cool non-clustered index feature in SQL2012 with significant boost in performance while been used. I tried to create it on my newly restored Database but I received this Error “Create failed for Index Either the object or one of its properties is not supported on...
30 Jan 2012
SQL Server 2012 Developer Training Kit Web Installer Preview
The SQL Server 2012 Developer Training Kit includes technical content including labs, demos and presentations designed to help you learn how to develop SQL Server 2012 database and BI solutions. New and updated content will be released periodically and can be downloaded on-demand using the Web Installer...
16 Nov 2011
SQL PASS EGYPT. Out first SQL Server user group in EGYPT
SQL PASS EGYPT CHAPTER It’s a pleasure to announce you the creation of the first PASS SQL Server user group in Egypt as PASS Official Chapter . Through this chapter we look for a monthly gathering of ALL SQL & BI community in Egypt to discuss, share and help in all SQL related matters...
15 Nov 2011
SQL Server 2012 Product Guide V2
now the product Guide V2 is available here This version has the following: - Download size reduction to 212 MB from 412 MB to accommodate slower download link - Welcome page includes a link to the hosted SQL Server Virtual labs to try out SQL Server 2012 CTP3 without installation - 32 (thirty...
29 Oct 2011
SQL Server 2012 VertiPaq Analysis Services installation and Demo (Video)
after the amazing success of PowerPivot in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and compression and it’s called the VertiPaq Engine or the Analysis Services Tabular Mode. this 12 minutes video that I’ve created walk you...
17 Oct 2011
Profiler Replicator, A SQL Server Performance Testing Software based on SQL Profiler
I've developed a small application that will help you test the performance of you SQL engine. the application simply retrieve your Queries from a Pre-set Profiler table and start replicate this in multithreading mode with you set configuration to brute the destination database and you can get out of...
15 Oct 2011
List Connections and Users connected to Lync Registrar Pool
The following script could be copied to %windir%/system32 as connections.ps1 in order to run it from Lync powershell directly. It will list all the number of connectios to the registrar pool; i have added Listing all user aliases connected to Lync within the main Function. #################################################################################################...
19 Jul 2011
Denali CTP3 is here
Did you download it ??... Not Yet... Go NOW and GET CTP3 from the below URL http://www.microsoft.com/sqlserver/en/us/default.aspx
13 Jul 2011
Jumping between database Name and ID in SQL Server
If you're using DMVs or quering the master Database, you'll need to know your database id, and some query results returned with Database Id and your want to know is this my database ? a quick jumping between database id and name From ID to Name select DB_NAME(1); From Name to ID ...
19 Jun 2011
Lync Server 2010 supports SQL Server 2008 R2 !!
It has been announced TODAY that SQL Server 2008 R2 is now supported for Lync Server 2010. Finally !!
20 Apr 2011
Bringing the Transaction mode with SSIS into reality.
Isn’t it a desirable request to run your Data flow Tasks into Transaction Mode that rolls back if something wrong happened in the middle. Will the functionality is there but you’ll need some configuration to bring it into life. Let’s have a look together. First you want to change...
20 Mar 2011
What do you Know about the SQL Server Data pages ?
SQL Server page is 8K so remember when you format your hard disk. Create it in a 64K clusters for the best performance. Let’s no more about the SQL Page · 96 Bytes for the page Header · 8096 for the page rows with a limits 8060 bytes Only for rows. · 2 bytes in the...
15 Mar 2011
The Diagonal Warehouse Design
Have you ever been in a situation when designing your warehouse where you had some measures that could not be grouped together due to dimensionality differences? A few measures that you can’t put into one Fact and of course, like me, you hate the idea of a Fact for each measure. I’ve been...
29 Nov 2010
Page 1 of 1 (21 items)
© 2013 Microsoft Corporation.
Privacy & Cookies
See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums