PDF of Schedule
SQL CLR from 2005 to 20015, Not how, but why and when
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.
Big Data: Become a data engineer or kick the bucket!
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.
SQL Server Reporting Services Best Practices
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.
Managing a BI Project Successfuly
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!
Lior Cohen Amikam,
Advanced Query Tuning Techniques
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.
Spatial data type and its implementation
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.
The Data Loading Performance Presentation
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
Delayed Durability - SQL Server goes wild
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
Rethink Your Data Model and Make It Super Fast
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.
How to use MS SQL 2014 Pyramid Analytics to Deliver the best Governed Self-service solution
How to use MS SQL 2014 Pyramid Analytics to Deliver the best Governed Self-service solution for your organization – a live demo
harnessing the GPU power for Big Data Analytic
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.
Native File Streaming with SQL Server
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.
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Data engineer and architect
Matan Yungman is a Data Engineering Team Lead at Taboola
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, 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 (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.
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.
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 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 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 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.