SQLSaturday #208 - Riyadh 2013 5/23/2013 12:00:00 AM (GMT+03:00) Kuwait, Riyadh SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat208 Holiday Inn (AlQasr), Olaya. Riyadh , Saudi Arabia http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 3275 Microsoft Gold Sponsor https://www.Microsoft.com http://i.s-microsoft.com/global/ImageStore/PublishingImages/logos/hp/logo-lg-1x.png 60 170 3284 Starways Information Technology Bronze Sponsor http://www.starways.com.sa http://devlifestyle.net/UploadedFiles/Sponsors/logo123.png 60 170 3425 Red Gate Software Bronze Sponsor http://redg.at/14XyR3l http://www.red-gate.com/assets/images/common/logo.png 60 170 3453 Development Space Bronze Sponsor http://www.dev.sa http://www.dev.sa/DevLogo/DevSpace%20LOGO_S.png 60 170 3459 Pluralsight Bronze Sponsor http://pluralsight.com http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png 60 170 12770 SQLSatruday 208 Track 1 Room 1 5/23/2013 10:15:00 AM 5/23/2013 10:30:00 AM 12770 SQLSatruday 208 Track 1 Room 1 5/23/2013 3:15:00 PM 5/23/2013 3:45:00 PM 12770 SQLSatruday 208 Track 2 Room 2 5/23/2013 10:15:00 AM 5/23/2013 10:30:00 AM 12770 SQLSatruday 208 Track 2 Room 2 5/23/2013 3:15:00 PM 5/23/2013 3:45:00 PM 12771 SQLSaturday 208 Track 2 Room 2 5/23/2013 11:45:00 AM 5/23/2013 12:45:00 PM 12771 SQLSaturday 208 Track 1 Room 1 5/23/2013 11:45:00 AM 5/23/2013 12:45:00 PM 12772 SQLSaturday 208 Track 1 Room 1 5/23/2013 8:30:00 AM 5/23/2013 9:00:00 AM 12772 SQLSaturday 208 Track 2 Room 2 5/23/2013 8:30:00 AM 5/23/2013 9:00:00 AM 12773 SQLSaturday 208 Track 2 Room 2 5/23/2013 5:00:00 PM 5/23/2013 5:30:00 PM 12773 SQLSaturday 208 Track 1 Room 1 5/23/2013 5:00:00 PM 5/23/2013 5:30:00 PM 12914 Joe Chang Track 1 Room 1 Modern server systems are incredibly powerful, and yet it is clear that a brute force approach to SQL Server performance does not always work. Learn how to identify situations that require good SQL,indexes and statistics. Additional topics are automating performance analysis and parallel execution strategies. 5/23/2013 2:00:00 PM 5/23/2013 3:15:00 PM 12915 Joe Chang Track 2 Room 2 Today it is possible to achieve exceptional storage performance for SQL Server without excessive costs. Unfortunately the solution proposed by storage system vendors generally ignores the special characteristics of database engines (not just SQL Server), resulting in marginal if not poor performance. Learn how to match the hardware elements of storage including IO channels, the role of cache, and the components hard drives, SSD - both enterprise class and lower cost options to the characteristics of SQL Server IO to achieve realizable query performance. 5/23/2013 10:30:00 AM 5/23/2013 11:45:00 AM 13057 Hossam Alfraih Track 1 Room 1 Hossam will be your guided tour to the indexing world! We will visits index types, know where to use them, how they work, interesting facts, and best practices. We will see how to keep our indexes healthy for better performance as well. 5/23/2013 9:00:00 AM 5/23/2013 10:15:00 AM 13919 Niko Neugebauer Track 1 Room 1 This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis. 5/23/2013 10:30:00 AM 5/23/2013 11:45:00 AM 13920 Niko Neugebauer Track 1 Room 1 There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations. 5/23/2013 3:45:00 PM 5/23/2013 5:00:00 PM 14502 Shehap El-Nagar Track 2 Room 2 To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users is exists there but actually they seem totally strange once going to live and they become performing badly ending up with standstill cases sometimes , this is due to lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs so I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be analyzed within this session) 5/23/2013 3:45:00 PM 5/23/2013 5:00:00 PM 14603 Umit Tiric Track 2 Room 2 PDW is a massively parallel processing data warehousing appliance built for any volume of relational data (with up to 100x performance gains) and provides the simplest integration to Hadoop. SQL Server 2012 Parallel Data Warehouse introduces PolyBase, a fundamental breakthrough in data processing used to enable seamless integration between traditional data warehouses and “Big Data” deployments. - Use standard SQL queries (instead of MapReduce) to access and join Hadoop data with relational data. - Query Hadoop data without IT having to pre-load data first into the warehouse. - Native Microsoft BI Integration allowing analysis of relational and non-relational data with familiar tools like Excel. Scale and perform beyond your traditional SQL Server deployment with PDW’s massively parallel processing (MPP) appliance that can handle the extremes of your largest mission critical requirements of performance and scale. 5/23/2013 9:00:00 AM 5/23/2013 10:15:00 AM 14748 Satya (SQLMaster) Shyam Jayanty Track 2 Room 2 Why Upgrade? This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices. Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits. In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, SQL Server 2008 R2 (with a good overview on 2012 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution is offered. 5/23/2013 12:45:00 PM 5/23/2013 2:00:00 PM 14759 Mohamad Halabi Track 2 Room 2 The session first explains transactions architecture, tackling topics such as Resource Managers, Transaction Protocols, and Transaction Managers. Then it shows how DTC is used to aid in .NET and WCF distributed transactions. 5/23/2013 2:00:00 PM 5/23/2013 3:15:00 PM 15069 Nabeel Derhem Track 1 Room 1  Understanding when and how to use NoSQL is already becoming critical for all database professionals currently focusing only on the RDBMS world. This session is about explaining NoSQL for the SQL Server professional  where we will discuss the history and needs that led to the NoSQL solutions, and the strengths and weaknesses in comparison with the RDBMS. We'll also explore the several NoSQL Data Models available in the market today (Key-Value, Column-Family, Document, and Graph) along with explaining the current solutions implementing them (Cassandra, MongoDB, Redis, Neo4j, etc..). 5/23/2013 12:45:00 PM 5/23/2013 2:00:00 PM