SQLSaturday #451 - Istanbul 2015
Event Date: 12/12/2015 00:00:00
Event Location:
- Microsoft Turkey
- Bellevue Residences, Levent Mahallesi, Aydin Sokak, No7, Levent, Istanbul
- Istanbul, Istanbul, Turkey
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: Think Connected – Modern IoT Solutions with Microsoft Azure
Abstract:
The Internet of Things is becoming reality at a rapid pace. Many objects in the real world can be connected to the Internet. Cloud computing is the best option for the IoT backend. Microsoft Azure offers the best set of services, required for the Internet of Things solutions, including a wide set of storages, websites, cloud services, Azure Service Bus / Event Hubs, Mobile Services, AD authentication and many data platform and BI related products like Azure SQL Database, DocumentDB, Azure Storage, Azure Stream Analytics, Machine Learning, Power BI and more..
This talk is about the main business cases and main architectural challenges, related to the actual and new IoT systems and particularly predictive services, based on Microsoft Azure.
Speaker(s):
- Mihail Mateev
Track and Room: Adara - Adara
Title: Deep dive to SQL Server configuration for SharePoint Server
Abstract: If you’re using SQL Server 2012 or SQL Server 2014 as the database server for SharePoint 2013, you must perform particular set of steps to install SQL Server and then configure it specifically to host your SharePoint 2013 farm. In this session, we’ll walk through the installation process for SQL Server. I’ll explain the post-installation configuration changes that are foreseen to SharePoint 2013. We’ll also have a look on how to configure SQL as SharePoint backups – all via PowerShell - for sure! As last point bottlenecks for HA/DR environments will be explained in a few steps.
After this session you will serve admirably the database back end to your SharePoint 2013 farm.
Speaker(s):
- Gokan Ozcifci
Track and Room: Jupiter 2 - Jupiter 2
Title: Social Media Analytics using Azure Technologies
Abstract: Social media are computer-mediated tools that allow people to create, share or exchange information, ideas, and pictures/videos in virtual communities and networks. To sum up Social Media is everything for your customers and Your company need to listen them to understand, make a custom offer or improve loyalty etc. Azure Stream Analytics and HDInsight platforms can solve this problem for you. We’ll focus on how to get Twitter data using Stream Analytics and how to make data enrichment and storing using HDInsight and What is the problem about sentiment analytics using Azure Machine Learning.
Speaker(s):
- Koray Kocabas
Track and Room: Adara - Adara
Title: SQL 2016 : Obtaining High Performance with In-Memory Columnstore Indexes
Abstract: Columnstore indexes uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage. It also makes you gain up to 10x data compression over the uncompressed data size. Beginning with SQL Server 2016 columnstore indexes enable operational analytics, the ability to run performant real-time analytics on a transactional workload. In this session we’ll see how columnstore indexes work and how we can get most benefits from them in practice.
Speaker(s):
- Levent Oktar
Track and Room: Jupiter 1 - Jupiter 1
Title: New Generation Data Warehouse in Azure
Abstract: A few weeks ago Microsoft’s Azure SQL Data Warehouse launched in limited public preview. Data is growing exponentially and companies have problems like storing, scaling, or analyzing etc. We will talk about new generation data warehouse that is an elastic data warehouse-as-a-service in Azure Platforms and compare similar technologies.
Speaker(s):
- Koray Kocabas
Track and Room: Adara - Adara
Title: SQL Server Query Design and Optimization Recommendations For Developers
Abstract: Query Optimization is one of the most interesting and most challenging aspects of working with SQL Server. In this session, we will cover Query Design and Optimization for best performance. Firstly we will gather data for analysis, then we will identify bottlenecks, and finally we will optimize specific queries. All this will be done with small changes on our queries.
Speaker(s):
- Ismail Adar
Track and Room: Jupiter 2 - Jupiter 2
Title: Indexing Deep Dive
Abstract: Another in TheSQLGuru’s very popular “Deep Dive” series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker(s):
- Kevin Boles
Track and Room: Jupiter 1 - Jupiter 1
Title: Querying SQL Server Data with Power BI Desktop
Abstract: In this session, make queries with SQL Server BI Power Desktop application on SharePoint and will give information about subtleties.
Speaker(s):
- Erdem Avni SELÇUK
Track and Room: Jupiter 2 - Adara
Title: Execution Plans Detail From Zero to Hero
Abstract:
At the end of this session attendees are be able to read and understand the execution plans. This simple thing can enhance our productivity because it will help us to detect and potentially solve performance problems.
Speaker(s):
- Ismail Adar
Track and Room: Jupiter 2 - Jupiter 2
Title: SQL Server Partitioning from A to Z
Abstract: We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.
Speaker(s):
- Kevin Boles
Track and Room: Jupiter 2 - Jupiter 2
Title: SQL Server 2016 High Availability and Disaster Recovery Solutions
Abstract: Today almost all the business applications/databases need High Availability and Disaster Recovery solutions for uninterrupted service continuity. In this session we’ll have a look at High Availability and Disaster Recovery (HA/DR) Solutions of SQL Server and what is newly coming with SQL Server 2016.
Speaker(s):
- Levent Oktar
Track and Room: Jupiter 1 - Jupiter 1
Title: Real-Time Click Stream Analysis with Microsoft Azure Stream Analytics
Abstract: With Microsoft Azure Stream Analytics and Event Hubs services, it will be more effective and usable to get IOT data and analyse this data. Content management has a important position in real world, such as websites and other interactive systems. So, with Stream Analytics service, analyse this click stream data is really getting easy. Additionally, it is possible to report this click stream data using PowerBI on Microsoft Azure.
In this session, we will be talking about;
- What’s IOT?
- Microsoft Azure Stream Analytics
- Microsoft Azure Event Hubs
- Microsoft PowerBI
Speaker(s):
- Abdullah ALTINTAŞ
Track and Room: Adara - Adara
Title: Troubleshooting AlwaysOn Availability Groups in SQL Server 2012/2014/2016
Abstract: In this demo-packed session, you will learn how/what to monitor to have confidence that AlwaysOn Availability Groups are working properly. We will also cover where to look for problems - Harden, REDO, DMVs, xEvent Logs, SQL error logs, cluster logs, etc.
Speaker(s):
- Yigit Aktan
Track and Room: Jupiter 1 - Jupiter 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Pelin Atici
LinkedIn: Pelin Atici
https://tr.linkedin.com/in/pelin-atıcı-1b965253
Koray Kocabas
Contact: http://www.data-dynamic.com
After I graduated Technical University (Statistics programme), I worked at Fujitsu Siemens Computers, Mavi, Project House HAVAS that i developed Business Intelligence Projects. Now I#39;m working at yemeksepeti.com that is a one of the biggest e-commerce company in Turkey as Senior Business Intelligence Developer.By the way I#39;m a periodical teacher at Bahcesehir University (MIS Master Programme) about Business Intelligence using Microsoft SQL Server. I awarded as SQL Server MVP in 2014,2015
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Gokan Ozcifci
Contact: http://gokan.ms
Gokan Ozcifci, consultant principal et fondateur de la soci#233;t#233; Neoxy. Gokan est membre ex#233;cutif la communaut#233; francophone sur le TechNet Wiki, r#233;dacteur de blogs et mod#233;rateur sur forums SharePoint depuis plus de 4 ans. Il a #233;galement particip#233; avec les membres communautaires de Microsoft US pour la cr#233;ation de l#39;#233;quipe TAT. Gokan est #233;galement un MVP SharePoint, reconnu
pour ses blogs SharePoint, scripts et repr#233;sentation de SharePoint au Conseil de TechNet Wiki.
Koray Kocabas
Contact: http://www.data-dynamic.com
After I graduated Technical University (Statistics programme), I worked at Fujitsu Siemens Computers, Mavi, Project House HAVAS that i developed Business Intelligence Projects. Now I#39;m working at yemeksepeti.com that is a one of the biggest e-commerce company in Turkey as Senior Business Intelligence Developer.By the way I#39;m a periodical teacher at Bahcesehir University (MIS Master Programme) about Business Intelligence using Microsoft SQL Server. I awarded as SQL Server MVP in 2014,2015
Abdullah ALTINTAŞ
LinkedIn: Abdullah ALTINTAŞ
Contact: http://www.abdullahaltintas.com/
Abdullah Altıntaş currently works at Bilge Adam Corporate Solutions as Solution Architect and he is Team Leader of “Data Management and Productivity Solutions”.
Altıntaş shares about recent technological developments and his corporate experiences by trainings, seminars, and technical articles. He has MCT, MCSE (DPamp;BI) certificates.
Yigit Aktan
Twitter: - @ygtaktn
LinkedIn: Yigit Aktan
Contact: http://www.yigitaktan.com
Yigit Aktan is a founder and principal consultant of DataDynamic and he has been working in the IT industry since 2000. He specializes in HA amp; DR solutions, performance tuning and optimization of database systems with a focus on scalable, performing and secure deployments. He has been using SQL Server since version 2000. He is president of the PASS Turkey and a SQLSaturday organizer. He has been awarded as SQL Server MVP since 2012. He is a regular speaker at the SQL Server related events.
Ismail Adar
Contact: http://ismailadar.com
Ismail Adar, Computer Engineer, Microsoft Certified Trainer, MCSE and MCSA. Focused on the SQL Server relational engine at performance troubleshooting, OLTP scalability and defining and implementing reliable high availability environments. Also Author of quot;SQL Server 2012 Programming and Administrationquot; and quot;Data Warehouse Desing with SQL Server Interation Servicequot;
Levent Oktar
Before Microsoft Levent has worked for several Microsoft Partners and Government Offices as Database Administrator and Systems Engineer. He has worked on Database Migration Projects, SQL Server Database Systems Design and Architecture and HA/DR Projects for Government Offices. He#39;s been working at Microsoft Customer Services and Support Team as Support Engineer and Senior Premier Field Engineer since 2010.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Erdem Avni SELÇUK
Twitter: - @eravse
LinkedIn: Erdem Avni SELÇUK
Contact: http://www.eravse.com
Since 1999, I have been working in software and IT sector with the effort of being as efficient and valuable in production and designing the necessity and need collaboration of time and management of the ordering and offering.
I am continuing giving briefs, sharing data and establishing and working as a key speaker at Universities and local groups on SharePoint and software.
Abdullah Kise
LinkedIn: Abdullah Kise
Contact: http://abdullahkise.blogspot.com.tr/
Abdullah Kise currently works at Bilge Adam Corporate Solutions as Solution Architect and he is Assistant Unit Manager of “Data Management and Productivity Solutions”.
Kise shares about recent technological developments and his corporate experiences by trainings, seminars, and technical articles. He has MCT, MCSE (DPamp;BI) certificates.
Levent Oktar
Before Microsoft Levent has worked for several Microsoft Partners and Government Offices as Database Administrator and Systems Engineer. He has worked on Database Migration Projects, SQL Server Database Systems Design and Architecture and HA/DR Projects for Government Offices. He#39;s been working at Microsoft Customer Services and Support Team as Support Engineer and Senior Premier Field Engineer since 2010.
Ismail Adar
Contact: http://ismailadar.com
Ismail Adar, Computer Engineer, Microsoft Certified Trainer, MCSE and MCSA. Focused on the SQL Server relational engine at performance troubleshooting, OLTP scalability and defining and implementing reliable high availability environments. Also Author of quot;SQL Server 2012 Programming and Administrationquot; and quot;Data Warehouse Desing with SQL Server Interation Servicequot;
Sponsors
The following is a list of sponsors that helped fund the event: