SQLSaturday #208 - Riyadh 2013
Event Date: 05/23/2013 00:00:00
Event Location:
- Holiday Inn (AlQasr), Olaya.
- King Fahd Road
- Riyadh, Saudi Arabia
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: T-SQL Performance Guidelines for better DB stress
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
Track and Room: Track 2 - N/A
Title: SQL Server Data platform upgrade Techniques, best practices notes from the field
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
Track and Room: Track 2 - N/A
Title: SQL Server 2012 Parallel Data Warehouse Appliance
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
Track and Room: Track 2 - N/A
Title: Elements of Storage Performance
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
Track and Room: Track 2 - N/A
Title: A Tour in The Indexing World!
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
Track and Room: Track 1 - N/A
Title: Analyzing Twitter Data
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
Track and Room: Track 1 - N/A
Title: Inheriting a database for Developers, version 2
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
Track and Room: Track 1 - N/A
Title: SQL Performance on Powerful Hardware
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
Track and Room: Track 1 - N/A
Title: .NET and WCF Transactions for SQL Resource Manager
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
Track and Room: Track 2 - N/A
Title: NoSQL, an Introduction
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
Track and Room: Track 1 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Shehab El-Najjar
Twitter: - https://twitter.com/MSQLPerformance
LinkedIn: Shehab El-Najjar
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
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
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
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.
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
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
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
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.
Joe Chang
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
Mohamad Halabi
https://mvp.support.microsoft.com/profile/Mohamad.Halabi
Nabeel Derhem
Twitter: - https://twitter.com/NabeelDerhem
LinkedIn: Nabeel Derhem
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.
Joe Chang
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
Hossam Alfraih
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
Sponsors
The following is a list of sponsors that helped fund the event: