Event Location:
Holiday Inn (AlQasr), Olaya.
King Fahd Road
Riyadh, , Saudi Arabia
Abstract:
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)
Speaker(s): Shehab El-Najjar,
Abstract:
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.
Speaker(s): Satya Jayanty,
Abstract:
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.
Speaker(s): Umit Tiric,
Abstract:
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.
Speaker(s): Joe Chang,
Abstract:
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.
Speaker(s): Hossam Alfraih,
Abstract:
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.
Speaker(s): Niko Neugebauer,
Abstract:
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.
Speaker(s): Niko Neugebauer,
Abstract:
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.
Speaker(s): Joe Chang,
Abstract:
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.
Speaker(s): Mohamad Halabi,
Abstract:
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..).
Speaker(s): Nabeel Derhem,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/profile/view?id=126446983amp;trk=hp-identity-name
Contact: http://sqlserver-performance-tuning.net/
Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..) He is now Professional Services Manager at Saudi Emircom He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years He is an influencing Database community leader all over the region A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region
LinkedIn: http://pt.linkedin.com/in/webcaravela/
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Umit Tiric has 16 years professional experience though he has started his career in 1989 by releasing his first commercially packaged. Since then, he has also designed, implemented computer network infrastructure projects on network layer but his main focus is designing and developing enterprise applications and integrations using various technologies, programming languages and products mostly focused on Microsoft products and technologies.
LinkedIn: https://uk.linkedin.com/sqlmaster
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
LinkedIn: http://pt.linkedin.com/in/webcaravela/
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
https://mvp.support.microsoft.com/profile/Mohamad.Halabi
LinkedIn: https://sa.linkedin.com/in/nabeelderhem
Nabeel is a data culture passionate who works at Microsoft as a Data Platform Architect. His +15 years of experience with data platform technologies moved him through OLTP, DW, BI, ML, and cloud. As an ex SQL Server MVP (until joining Microsoft), Nabeel is still a regular speaker on international events.
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
Contact: http://www.SaudiGeek.NET
Hossam is a Senior Database Architect who is using SQL Server since version 7.0. He is a Microsoft Certified Trainer (MCT) who earned MCTS SQL Server 2005/2008 and MCITP SQL Server 2008 for Database Developer and Administrator certificates. He works as a freelancer Technical Consultant specialized in Database Systems and Performance Tuning. Moreover, he is writing and speaking about Cloud Computing since 2009. He co-founded SQLServerPath.org | Blog: www.SaudiGeek.NET | Follow him @SaudiGeekNET
The following is a list of sponsors that helped fund the event.