SQLSaturday 947

Israel

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on May 07 2020 at Megamot College, Derekh Em Hamoshavot 94, Petah Tikva, HaMerkaz, 49527, Israel

Register Now

Session Glimpse

Event schedule is not published yet.

      

SQL Saturday Israel is a great FREE day of learning,  a chance to network with other Microsoft Data Platform and OpenSource Platforms users, learn about new trends in the Data and Analytics world, eat tasty stuff and enjoy a beer party in the afternoon where you might even win a few prizes!

Call For Speakers IS OPEN! Submit us a lightning talk ( 15 min) or full session (45 min)  and help to build an amazing agenda. 

We are also arranging an additional pre-conferrence day, on May 6th to help overseas speakers cover their travel costs (150$ for full day session).  This year we have 3 different sessions, chose one and enjoy full day of quality training. Register through one of the below links:

Benjamin Nevarez, MVP from Los Angeles: 

Niko Neugebauer , MVP from Portugal: 

Guy Glantser, MVP from Israel: 

 

SQL Server Query Tuning & Optimization 

https://www.eventbrite.com/e/sql-server-query-tuning-optimization-tickets-90579235933 

Columnstore Indexes – Practical Solutions & Techniques 

https://www.eventbrite.com/e/columnstore-indexes-practical-solutions-techniques-tickets-90579932015 

Modernizing Your Data Platform 

https://www.eventbrite.com/e/modernizing-your-data-platform-tickets-87658722599 

– Understand how the query optimizer works 
– Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector and other tools 
– Work with query operators for data access, joins, aggregations, parallelism and updates 
– Speed up queries and dramatically improve application performance by creating the right indexes 
– Understand statistics and how to detect and fix cardinality estimation errors 
– Maximize OLTP query performance using In-Memory OLTP (Hekaton) features, including memory-optimized tables and natively compiled stored procedures 
– Monitor and promote plan caching and reuse to improve application performance 
– Improve the performance of data warehouse queries using columnstore indexes 
– Handle query processor limitations with hints and other methods 

Learn practical Columnstore Indexes tips and tricks, such as which type to use, how and when to use Disk-Based vs. In-Memory or Clustered vs. Nonclustered, how to load data into Columnstore in the most efficient way, and how to get the best performance possible out of the Batch Execution Mode. 

With a nod to each of the available SQL Server versions (2012, 2014, 2016, 2017, 2019 and the Azure SQLDB), this full day session focuses on practical solutions and applications of Columnstore Indexes and the Batch Execution Mode. We also review the limitations of both and learn how to solve some of those limitations. 

Covering all available relational engines supporting Columnstore Indexes (including parts of the SQL DataWarehouse), this pre-conference will give you insight on why and when to use Columnstore Indexes, and when to take a step back and use a different type of technology. 

Since November 2016 (and more specifically since Service Pack 1 for SQL Server 2016), Columnstore Indexes have been available for every Edition of SQL Server (including Express and Local editions). Join this workshop and become a part of the columnar revolution that is positively affecting database platforms around the world. 

In this full-day session, we will learn about a structured approach for such a modernization project: 

1. Set Clear Objectives – what is considered a successful project and how do we measure it? 

2. Identify the Target Data Platform: 

  • On-Prem or Cloud? 
  • Infrastructure or Platform (as a Service)? 
  • Physical or Virtual? 
  • Performance Specifications 
  • Opportunity for Consolidation 
  • Licensing Considerations 

3. Plan the Project: 

  • Online or Offline Migration? 
  • Risk Analysis 
  • Rollback Plan 
  • Monitoring 
  • Detailed Schedule and Documentation 

4. Development and Testing 

5. Deployment 

6. The Next Steps 

 


We'll see you soon at Megamot college

Maria Zakourdaev & Itai Binyamin

 

Event Location

Event news

No Event News entered. Please come back later and check again

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids