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.

Browse by Tags

Related Posts
  • Blog Post: 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 ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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. #################################################################################################...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 !!
  • Blog Post: 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...
  • Blog Post: 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
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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,...
  • Blog Post: 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...
  • Blog Post: 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...