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 focus…


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…


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 can start being interactive. well not…


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…


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 2012. Amr Al Asway will…


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…


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, and can routinely give a tenfold speedup for a…


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 in workload group ‘default’” Well don’t…


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 the target server version. (Microsoft.SqlServer.Smo)” oh…!!!…


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 Preview download it and start exploring http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27721