sqlsathistory

Nr: 321

Back to Main list

SQLSaturday #321 - Cairo 2014

Start Time (24h) Speaker Track Title
00:00:00 Hisham Mortada BI New Hybrid Cloud Scenarios with SQL Server 2014
00:00:00 Shehab El-Najjar SQL 2014 T-SQL Performance Guidelines for better DB stress powers
00:00:00 Shehab El-Najjar SQL 2014 Performance dreams wait for you at SQL Server 2014
00:00:00 Islam Elshafie BI BI on the cloud: Office 365 Power BI
00:00:00 Mohamad Tantawy, MBA, PMP, MCT BI Develop your data Standards with SQL Data Quality Services
00:00:00 Sherif Talaat SQL 2014 Automating SQL Server with Windows PowerShell
00:00:00 Wagdy Ishac BI From 0 to 100 Big data Solution End-To-End
00:00:00 Ahmed ElSangary SQL 2014 A Promise of better performance for your database

SessionID: 14993

New Hybrid Cloud Scenarios with SQL Server 2014

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: BI

Speaker: Hisham Mortada

Title: New Hybrid Cloud Scenarios with SQL Server 2014

Abstract:

In this session we will take a closer look at new hybrid cloud scenarios SQL Server 2014 can enable for your on-premises database applications

SessionID: 15262

T-SQL Performance Guidelines for better DB stress powers

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: SQL 2014

Speaker: Shehab El-Najjar

Title: T-SQL Performance Guidelines for better DB stress powers

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 or adequate volume of data 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: 15263

Performance dreams wait for you at SQL Server 2014

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: SQL 2014

Speaker: Shehab El-Najjar

Title: Performance dreams wait for you at SQL Server 2014

Abstract:

Performance dreams wait for you at SQL Server 2014 , it is just like this because you will that unbelievable performance reads and substantial improvement that you will not give up at all those new SQL Server 2014 features , come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 regarding performance particularly like Microsoft project “Hekaton” for In-memory built for OLTP , In-Memory columnstore index ,Resource Governor for IO consumption,lock management and also Single partition online index rebuild technologies ,you will get much hands-on experience for all definitions , architecture design , values and benefits ,caveats and recommendations related to each one of them and in addition I will add a practical flavor for this session by conducting multiple stress tests on most of these technologies to be more close to these performance dreams and explorer concretely these outstanding performance improvements of SQL Server 2014

SessionID: 15439

BI on the cloud: Office 365 Power BI

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: BI

Speaker: Islam Elshafie

Title: BI on the cloud: Office 365 Power BI

Abstract:

The need for a self-service business intelligence platform that can help users to turn data into decision-ready insights increases everyday; as does the need to gradually move on premise investments to a more scalable and manageable cloud platform.

. As part of its cloud offerings, Microsoft released Power BI for Office 365. Power BI is a collection of new features and services that, together, enable users to visualize data, share discoveries, and collaborate in intuitive new ways. In this session, I will be explaining Power BI in deep, its techniques, features and its pros cons. I'll be showing a live demo for a Power BI deployment on Office 365.

SessionID: 21158

Develop your data Standards with SQL Data Quality Services

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: BI

Speaker: Mohamad Tantawy, MBA, PMP, MCT

Title: Develop your data Standards with SQL Data Quality Services

Abstract:

SessionID: 24414

Automating SQL Server with Windows PowerShell

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: SQL 2014

Speaker: Sherif Talaat

Title: Automating SQL Server with Windows PowerShell

Abstract:

In this session, the audiences will learn about Windows PowerShell and how it can be used for automating most of SQL Server tasks.

SessionID: 27610

From 0 to 100 Big data Solution End-To-End

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: BI

Speaker: Wagdy Ishac

Title: From 0 to 100 Big data Solution End-To-End

Abstract:

Maybe you've heard about the term Big data, or maybe you've seen a presentation or a demo. in this session i want to make a full deep dive in big data and to present a Demo and a solution from Zero to 100 from a flat file till the reporting side. making a concept of how organization can utilize big data

SessionID: 9912

A Promise of better performance for your database

Back to calendar

Event Date: 17-06-2014 - Session time: 00:00:00 - Track: SQL 2014

Speaker: Ahmed ElSangary

Title: A Promise of better performance for your database

Abstract:

A Guaranteed Promise of much better performance for your database platform. Exploring performance tuning basics with Microsoft SQL Server 2014 new features to enable organizations to scale.

This site is open source. Improve this page.