Nr: 451
SQLSaturday #451 - Istanbul 2015
SessionID: 40382
SQL Server Partitioning from A to Z
Event Date: 12-12-2015 - Session time: 10:00:00 - Track: Jupiter 2
Speaker: Kevin Boles
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.
SessionID: 40679
Event Date: 12-12-2015 - Session time: 10:00:00 - Track: Adara
Speaker: Koray Kocabas
Abstract:
SessionID: 41672
SQL Server 2016 High Availability and Disaster Recovery Solutions
Event Date: 12-12-2015 - Session time: 10:00:00 - Track: Jupiter 1
Speaker: Levent Oktar
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.
SessionID: 38192
Troubleshooting AlwaysOn Availability Groups in SQL Server 2012/2014/2016
Event Date: 12-12-2015 - Session time: 11:15:00 - Track: Jupiter 1
Speaker: Yigit Aktan
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.
SessionID: 40492
Deep dive to SQL Server configuration for SharePoint Server
Event Date: 12-12-2015 - Session time: 11:15:00 - Track: Jupiter 2
Speaker: Gokan Ozcifci
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.
SessionID: 41767
Real-Time Click Stream Analysis with Microsoft Azure Stream Analytics
Event Date: 12-12-2015 - Session time: 11:15:00 - Track: Adara
Speaker: Abdullah ALTINTAŞ
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
SessionID: 38326
Execution Plans Detail From Zero to Hero
Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Jupiter 2
Speaker: Ismail Adar
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.
SessionID: 41038
Querying SQL Server Data with Power BI Desktop
Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Jupiter 2
Speaker: Erdem Avni SELÇUK
Title: Querying SQL Server Data with Power BI Desktop
Abstract:
SessionID: 38329
SQL Server Query Design and Optimization Recommendations For Developers
Event Date: 12-12-2015 - Session time: 14:30:00 - Track: Jupiter 2
Speaker: Ismail Adar
Title: SQL Server Query Design and Optimization Recommendations For Developers
Abstract:
SessionID: 40383
Indexing Deep Dive
Event Date: 12-12-2015 - Session time: 14:30:00 - Track: Jupiter 1
Speaker: Kevin Boles
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.
SessionID: 41454
Think Connected – Modern IoT Solutions with Microsoft Azure
Event Date: 12-12-2015 - Session time: 14:30:00 - Track: Adara
Speaker: Mihail Mateev
Title: Think Connected – Modern IoT Solutions with Microsoft Azure
Abstract:
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.
SessionID: 40680
New Generation Data Warehouse in Azure
Event Date: 12-12-2015 - Session time: 15:45:00 - Track: Adara
Speaker: Koray Kocabas
Title: New Generation Data Warehouse in Azure
Abstract:
SessionID: 41673
Event Date: 12-12-2015 - Session time: 15:45:00 - Track: Jupiter 1
Speaker: Levent Oktar
Abstract: