| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 00:00:00 | Eitan Lipovetskey | 1.Enterprise Database Administration Development | Spatial data type and its implementation |
| 00:00:00 | Guy Glantser | 1.Enterprise Database Administration Development | Advanced Query Tuning Techniques |
| 00:00:00 | Ido Friedman | 1.Enterprise Database Administration Development | Delayed Durability - SQL Server goes wild |
| 00:00:00 | Leonard Lobel | 1.Enterprise Database Administration Development | Native File Streaming with SQL Server |
| 00:00:00 | Lior Cohen Amikam | 2.BI Platform Architecture | Managing a BI Project Successfuly |
| 00:00:00 | Matan Yungman | 2.BI Platform Architecture | The Data Loading Performance Presentation |
| 00:00:00 | Niv Feldman | 2.BI Platform Architecture | How to use MS SQL 2014 Pyramid Analytics to Deliver the best Governed Self-service solution |
| 00:00:00 | Peter Larsson | 1.Enterprise Database Administration Development | Rethink Your Data Model and Make It Super Fast |
| 00:00:00 | Saggi Neumann | 2.BI Platform Architecture | Big Data: Become a data engineer or kick the bucket! |
| 00:00:00 | Steve Simon | 2.BI Platform Architecture | SQL Server Reporting Services Best Practices |
| 00:00:00 | amihay gonen | 2.BI Platform Architecture | harnessing the GPU power for Big Data Analytic |
| 00:00:00 | Ronen Ariely | 1.Enterprise Database Administration Development | SQL CLR from 2005 to 20015, Not how, but why and when |
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 1.Enterprise Database Administration Development
An interesting implementation developed by the speaker combining SSRS and cellular technologies will be presented.
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 1.Enterprise Database Administration Development
In this session we will analyze common use cases of poorly performing queries, such as improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. By the end of this session, you'll have a list of tips and techniques to apply on your environment.
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 1.Enterprise Database Administration Development
See why delayed durability is one of the most important features in years and the one that can make SQL Server a valid competitor for high throw put No-SQL systems
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 1.Enterprise Database Administration Development
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 2.BI Platform Architecture
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 2.BI Platform Architecture
The problem is that it's long and full of small details, and we're too lazy to read it.
On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.
Among other topics, we will talk about:
• Minimal Logging • Transaction Management • Bulk Loading Methods • Indexing Techniques for High Performance Data Loading • Properly Leveraging Parallelism and Partitioning • SQL Server 2014 Delayed Durability
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 2.BI Platform Architecture
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 1.Enterprise Database Administration Development
After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.
There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 2.BI Platform Architecture
In this talk I'll discuss the rapid technological changes in the Big Data and NoSQL world and the implications to a business adopting these technologies.
One outcome of adopting big data technology is that it's not easily accessible to people who touch data on a daily basis, which may quickly become a bottleneck in the organization. Turning into a full-fledged Data Engineer can be challenging, but it is possible. I'll discuss the skills DBAs and BI people need to learn and unlearn in order to work under new data paradigms. I will also review various new and emerging tools as well as integration with older platforms that allow for smoother migration into the new world.
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 2.BI Platform Architecture
In this hands on presentation, we shall be discussing some best practices that one should follow during the project life cycle from development to the production and implementation phases. We shall be discussing the pros and cons of utilizing shared datasets, the pluses and pitfalls of utilizing embedded reports, report utilization logging, utilization of graphics and the portability of solutions from one server to another.
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 2.BI Platform Architecture
In this lecture I will represent the principles of developing for applications for GPU and I'll discuses the advantages and the limitation of using the GPU (graphic process unit) on big databases . I'll presents some interesting benchmarks we've done on a GPU database vs RDBMS and columanr database and we'll try to predict the future in the area.
Event Date: 19-01-2015 - Session time: 00:00:00 - Track: 1.Enterprise Database Administration Development
In this session we are going to focus on the questions WHY to use SQLCLR, and not less important WHEN to use it over transact-SQL. We are not going to talk about HOW to use it. We are going to demonstrate the SQLCLR abilities in practice (all code will be publish latter), we are going to compare different solutions, explain why you have to use it, and show that in practice we all using SQLCLR, yet most DBAs do not write their own code. As part of the demonstrations, we will show how to implement new features from SQL server 2012 / 2014 on older versions.