• 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...
  • 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...
  • 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...
  • 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...
  • 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...