Nr: 670
SQLSaturday #670 - Banja Luka 2017
SessionID: 65534
The All Flash DBA
Event Date: 09-09-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Christopher Adkin
Title: The All Flash DBA
Abstract:
We are at a major turning point in the world of storage; the transition from spinning disk to flash and as we move into this new world a lot of conventional wisdom will be turned on its head. Things such as the use of compression, putting different database components on different volumes, the desire to chase large readaheads for sequential scan workloads, how well mixed workloads are handled, the multi threaded log writer and delayed durability, besides this, the session will also cover nand flash fundamentals at 300 level.
SessionID: 66367
Introduction to Azure SQL Data Warehouse
Event Date: 09-09-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Speaker: Dejan Pervulov
Title: Introduction to Azure SQL Data Warehouse
Abstract:
Azure SQL Data Warehouse is a SQL-based fully managed, petabyte-scale cloud data warehouse. It is highly elastic, enabling you to provision in minutes and scale capacity in seconds. You can scale compute and storage independently, allowing you to burst compute for complex analytical workloads or scale down your warehouse for archival scenarios, and pay based off what you're using instead of being locked into predefined cluster configurations - helping you derive even more cost efficiency versus traditional data warehouse solutions.
SessionID: 65533
Problem Solving With The In-Memory Engine
Event Date: 09-09-2017 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Christopher Adkin
Title: Problem Solving With The In-Memory Engine
Abstract:
- Staging data as fast as possible
- Turbo charging scalar aggregate functions
- Implementing a scalable sequence
- Overcoming the performance limitations of temporary tables
- Making the critical path in your code base run faster
SessionID: 68831
SQL Server 2016 and R Engine-powerful duo
Event Date: 09-09-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Tomaž Kaštrun
Title: SQL Server 2016 and R Engine-powerful duo
Abstract:
With SQL Server 2016 R Language for statistical programming is now supported with native T-SQL. With this extension we can now integrate powerful R Language with transactional data directly using SSMS. With this feature data stewards and data analysts can now run from simple uni-variate to multi-variate statistics in SSMS. Implementation of R in SQL Server 2016 is one of major parts of BI Landscape.
In this session we will go through:
- Installation needed (R and MRO by Revolution Analytics (now Microsoft)
- Exploring the usage of RRO Engine (multi-threated usage and parallel multi-core usage of CPU,...)
- Using T-SQL for Data analysis with importing and exporting data to SQL Tables
- Demos with using R in Reporting services (SSRS) and Power BI
- Using R Engine for enhancing your daily work as DBA or BI Analyst
- Exploring prediction engine on datasets in your daily business work
- Use cases how and where can powerful duo make your daily business easier
Session is useful for
SessionID: 66241
Parameter Sniffing Problem with Stored Procedures
Event Date: 09-09-2017 - Session time: 11:00:00 - Track: Application Database Development
Speaker: Miloš Radivojević
Title: Parameter Sniffing Problem with Stored Procedures
Abstract:
Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and why parameter sniffing is a problem in SQL Server stored procedures. Of course, several solutions will be presented and it will be discussed which solution is applicable in which scenario.
SessionID: 68849
SQL Server on Linux
Event Date: 09-09-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jasmin Azemović
Title: SQL Server on Linux
Abstract:
Ono što je do jučer bilo nezamislivo sada je postala realnost. Sigurno nikada niste niti pomislili da će Microsoft krenuti sa open source inicijativom, a da ne govorimo o podršci za Linux. SQL Server je dobio svoju verziju za Linux, tačnije rečeno nekoliko trenutno najpopularnijih distribucija (Ubuntu, SUSE i Red Hat). Da li se radi o istom SQL Server okruženju i mogućnostima? Šta je brže, bolje i kvalitetnije i da li ima uopšte smisla da razmišljate o ovome? Saznajte na ovom predavanju.
SessionID: 66292
Query Store and Query Optimization
Event Date: 09-09-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Dean Savović
Title: Query Store and Query Optimization
Abstract:
I will talk about advantages of Query Store, features, configuration and query optimization using Query Store. How we can monitor query perfomance, how the Query Store collects data and which are the best practices in using Query Store. During the presentation I will show various demos.
SessionID: 66365
Get your data and your model ready for the Cloud using Power BI Desktop
Event Date: 09-09-2017 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Dejan Pervulov
Title: Get your data and your model ready for the Cloud using Power BI Desktop
Abstract:
SessionID: 66906
Power Bi for beginner IoT developer
Event Date: 09-09-2017 - Session time: 14:15:00 - Track: Application Database Development
Speaker: Catalin Gheorghiu
Title: Power Bi for beginner IoT developer
Abstract:
You have IoT solutions, and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast. You would also love to have these data is available on mobile devices.
Solutions to this problem is the Power BI these especially if you are already using Azure or Office 365.
In this presentation I will try to introduce you to Power BI with at least enough information to know where to start.
All with the demo, from hardware, to the cloud, to Power BI.
SessionID: 68833
Azure Data Lake Analytics
Event Date: 09-09-2017 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
Speaker: Tomaž Kaštrun
Title: Azure Data Lake Analytics
Abstract:
Besides scaling and faster deployment, it is affordable and cost effective and easy to integrate into your existing IT environment.
For the demo, we will look at the image recognition and emotion detection.
SessionID: 66243
Event Date: 09-09-2017 - Session time: 15:30:00 - Track: Application Database Development
Speaker: Miloš Radivojević
Abstract:
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.
SessionID: 66291
Cardinality Estimator with SQL Server 2014 and 2016
Event Date: 09-09-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Dean Savović
Title: Cardinality Estimator with SQL Server 2014 and 2016
Abstract:
Cardinality Estimator had a major upgrade in SQL Server 2014 version and 2016. After a few introductory words, I will speak about model assumptions of Cardinality Estimator, calculation direction, model selection of Cardinality Estimator and improvements in SQL Server versions 2014 and 2016. I will also have a few demos where I will demonstrate how to optimally use the new features.