sqlsathistory

Nr: 208

SQLSaturday #208 - Riyadh 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Shehab El-Najjar	Track 2	T-SQL Performance Guidelines for better DB stress
00:00:00	Niko Neugebauer	Track 1	Analyzing Twitter Data
00:00:00	Niko Neugebauer	Track 1	Inheriting a database for Developers, version 2
00:00:00	Joe Chang	Track 1	SQL Performance on Powerful Hardware
00:00:00	Joe Chang	Track 2	Elements of Storage Performance
00:00:00	Mohamad Halabi	Track 2	.NET and WCF Transactions for SQL Resource Manager
00:00:00	Nabeel Derhem	Track 1	NoSQL, an Introduction
00:00:00	Hossam Alfraih	Track 1	A Tour in The Indexing World!
00:00:00	Satya Jayanty	Track 2	SQL Server Data platform upgrade Techniques, best practices notes from the field
00:00:00	Umit Tiric	Track 2	SQL Server 2012 Parallel Data Warehouse Appliance

SessionID: 15200

T-SQL Performance Guidelines for better DB stress

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Shehab El-Najjar

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)

SessionID: 15385

Analyzing Twitter Data

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Niko Neugebauer

Title: Analyzing Twitter Data

Abstract:

SessionID: 15386

Inheriting a database for Developers, version 2

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Niko Neugebauer

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.

SessionID: 16089

SQL Performance on Powerful Hardware

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Joe Chang

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.

SessionID: 16090

Elements of Storage Performance

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Joe Chang

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.

SessionID: 20998

.NET and WCF Transactions for SQL Resource Manager

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Mohamad Halabi

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.

SessionID: 21288

NoSQL, an Introduction

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Nabeel Derhem

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

SessionID: 23997

A Tour in The Indexing World!

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Hossam Alfraih

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.

SessionID: 24994

SQL Server Data platform upgrade Techniques, best practices notes from the field

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Satya Jayanty

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.

SessionID: 27174

SQL Server 2012 Parallel Data Warehouse Appliance

Back to calendar

Event Date: 23-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Umit Tiric

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.

This site is open source. Improve this page.