SQLSaturday #360 - Israel 2015
Event Date: 01/19/2015 00:00:00
Event Location:
- Microsoft - Herzliya RD Center
- Arieh Shenkar St 13
- Herzliya, Israel
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: SQL CLR from 2005 to 20015, Not how, but why and when
Abstract: 2005, Big buzz…. Microsoft added a NEW FEATURE to the SQL Server, which allow users to extend the Server abilities, by importing external CLR libraries. Hundreds of articles and discussions were held around the same time, asking: is Transact-SQL dead? Today we are celebrating Tenth Birthday to CLR feature, and it is best time to open the discussion and get some insights regarding this OLD FEATURE.
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.
Speaker(s):
- Ronen Ariely
Track and Room: 1.Enterprise Database Administration Development - N/A
Title: Big Data: Become a data engineer or kick the bucket!
Abstract: As a long time database consultant, and the current CTO of Xplenty, I’ve seen many organizations taking in new data technologies and handling the changes with various degrees of success, as well as how these changes affected the data team within the organization.
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.
Speaker(s):
- Saggi Neumann
Track and Room: 2.BI Platform Architecture - N/A
Title: SQL Server Reporting Services Best Practices
Abstract: SQL Server Reporting Services is a phenomenal tool to get the ‘good word’ out to management. Working with Reporting Services can be challenging at times (to say the least) and one learns to work with its subtleties and nuances. 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.
Speaker(s):
- Steve Simon
Track and Room: 2.BI Platform Architecture - N/A
Title: Managing a BI Project Successfuly
Abstract: How do we measure the success of a BI Project?How can we assure the customer is pleased with the project result?BI Projects pose a considerable challenge and successful management has always been an elusive part of the BI Development life cycle.In this session we will review these concepts and receive tips and guidelines. we will be reviewing real life scenarios.Audience participation is encouraged!
Speaker(s):
- Lior Cohen Amikam
Track and Room: 2.BI Platform Architecture - N/A
Title: Advanced Query Tuning Techniques
Abstract: You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what? 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.
Speaker(s):
- Guy Glantser
Track and Room: 1.Enterprise Database Administration Development - N/A
Title: Spatial data type and its implementation
Abstract: An introduction to the Spatial data type and the functions related to it. An interesting implementation developed by the speaker combining SSRS and cellular technologies will be presented.
Speaker(s):
- Eitan Lipovetskey
Track and Room: 1.Enterprise Database Administration Development - N/A
Title: The Data Loading Performance Presentation
Abstract: Microsoft has a famous whitepaper called “The Data Loading Performance Guide”. 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
Speaker(s):
- Matan Yungman
Track and Room: 2.BI Platform Architecture - N/A
Title: Delayed Durability - SQL Server goes wild
Abstract: The first time SQL Server brakes the ACID model, this is the biggest change in the engine in a long time.
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
Speaker(s):
- Ido Friedman
Track and Room: 1.Enterprise Database Administration Development - N/A
Title: Rethink Your Data Model and Make It Super Fast
Abstract: Sometimes you really need an EAV model. In most cases they are ugly and slow. 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.
Speaker(s):
- Peter Larsson
Track and Room: 1.Enterprise Database Administration Development - N/A
Title: How to use MS SQL 2014 Pyramid Analytics to Deliver the best Governed Self-service solution
Abstract: How to use MS SQL 2014 Pyramid Analytics to Deliver the best Governed Self-service solution for your organization – a live demo
Speaker(s):
- Niv Feldman
Track and Room: 2.BI Platform Architecture - N/A
Title: harnessing the GPU power for Big Data Analytic
Abstract: Today modern graphics cards have a lot of computing power for example the Nvida flagship card Tesla K40 has 2880 cores and is able to peform 4.29 T operations per second !!. 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.
Speaker(s):
- amihay gonen
Track and Room: 2.BI Platform Architecture - N/A
Title: Native File Streaming with SQL Server
Abstract: In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.
Speaker(s):
- Leonard Lobel
Track and Room: 1.Enterprise Database Administration Development - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Ido Friedman
Data engineer and architect
Niv Feldman
Contact: http://www.pyramidanalytics.com
.
Matan Yungman
Twitter: - MatanYungman
LinkedIn: Matan Yungman
Matan Yungman is a Data Engineering Team Lead at Taboola
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Guy Glantser
Twitter: - guy_glantser
LinkedIn: Guy Glantser
Contact: https://www.madeiradata.com/blog
Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS Local Group, as well as the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant, or a speaker. His main area of expertise is SQL Server development and optimization. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQLSaturdays, and user groups around the world. He also co-hosts the SQL Server Radio podcast.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
Saggi Neumann
Contact: http://www.xplenty.com
Founder and CTO of Xplenty, a leading cloud big data startup, in the last 3 years, former CTO of Valinor, a database professional services company, data expert and a family guy.
Lior Cohen Amikam
BI Group Manager at Naya Technologies.Prior positions include CTO at Eternity-it, BI Team Leader and Developer at Elad Systems, Walla, Nuconomy, Metacafe and Hotbar..comNotable clients include Banks, Insurance companies, Internet companies, Online Trading Companies and Startups.
amihay gonen
Contact: http://www.pythiasystems.com/
Amichai has more than 20 years of experience in Databases infrastructure. A Database manager at Ectel and a Oracle VLDB (very large database) consultant, Amichai has vast experience developing and working hands on in the field as well as implementing large scale, on site, databases. Amichai served for many years in the Intelligence corps of the IDF dealing with DS and SW development.
Eitan Lipovetskey
Eitan worked as a senior programmer in the air force for 2 years, and in PNM Software for 6.5 years. He has been working in Naya for 3 years as a DBA in eToro.
Peter Larsson
Twitter: - SwePeso
Contact: http://www.sqltopia.com
Peter Larsson is a key player for performance written code. He can turn a 10 hour query into a 3 minute piece of code. Peter is also a SQL Server MVP since 2009. He often hangs out at SQLTeam.com (27k+ posts) and other various sites where he helps all people understand SQL Server.
Ronen Ariely
Twitter: - https://twitter.com/pitoach
LinkedIn: Ronen Ariely
Contact: http://ariely.info/Blog/tabid/83
Ronen Ariely is a senior consultant, an applications data architect. He has more than 15 years’ experience in variety programming languages and technologies, leading development teams and software companies in enterprise level solutions in the fields of Data Platforms, BI, and developing. Ronen is active in communities (aka pituach) in the fields of Microsoft Azure, SQL Server, T-SQL, and Dot.Net programming. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities’ leaders. Ronen writes technical blogs, TechNet articles and blogs, he is co-admin of Microsoft’s blogs “TechNet WIki” and “MSDN Forum”, and has been awarded as Microsoft Most Valuable Professional.
Sponsors
The following is a list of sponsors that helped fund the event: