What we're about

This meetup is all about data. From small to big, SQL to NoSQL, BI, reports, development, design and more. If you're a developer, DBA, BI expert, data analyst or data scientist, this is a great place to meet and learn.

Upcoming events (3)

Azure Data Explorer and Always Encrypted

Microsoft office

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-19:15 - First Session (The Database that Took Microsoft by Storm – Getting to Know Azure Data Explorer) • 19:15-19:30 - Break (More Networking) • 19:30-20:15 - Second Session (SQL Server Always Encrypted) Sessions: 1. The Database that Took Microsoft by Storm – Getting to Know Azure Data Explorer – Matan Yungman (60 Minutes) Azure Data Explorer (project name Kusto) is a new cutting-edge big data technology by Microsoft. In this session, we'll talk about what it can do, how it works, use cases for using it, how to start working with it, and learn some KQL, its brilliant query language. 2. SQL Server Always Encrypted – Elad Luvka (45 Minutes) In this session we'll talk about Always Encrypted, a new security feature since SQL Server 2016. Always Encrypted allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Always Encrypted is available in all editions since SQL Server 2016 SP1. You'll learn the difference between existing encryption features that have been available in previous versions of SQL Server and Always Encrypted. You'll learn how Always Encrypted works. Also, there will be a demo of how to implement Always Encrypted with SSMS and PowerShell. Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Thank you!

Top Performance Killers and Killer Scripts to Find Them

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-19:15 - First Session (Top 10 SQL Server Performance Killers) • 19:15-19:30 - Break (More Networking) • 19:30-20:30 - Second Session (4 Killer Scripts that will Pinpoint any Real-Time Performance Issue in Your Database) Sessions: 1. Top 10 SQL Server Performance Killers – Vitaly Bruk (60 Minutes) There are so many tips and best practices out there for boosting the performance of your SQL Server instance. With so many tips and resources, it’s difficult to decide which are correct and where to start. Vitaly Bruk is going to share his experience and present his list of top 10 performance killers in SQL Server. These are the things you should avoid. Some of these performance killers are quite common, and there is a good chance that you have them in your SQL Server instances. Here are some examples: Default vs. Best Practice Instance Configurations (Min/Max Memory, Max DOP, Cost Threshold for Parallelism, etc.), Statistics Maintenance, Wrong Data Types. Join this session to learn why these performance killers are so bad for your system and what you should do in order to avoid them. 2. 4 Killer Scripts that will Pinpoint any Real-Time Performance Issue in Your Database – Michael Zilberstein (60 Minutes) Does any of these sound familiar? • Database is stuck, CPU is skyrocketing, but you don't see anything particularly heavy running on the system. • Everything looks heavy and stuck. • Server looks idle, but database operations fail with timeout. In this session we will demonstrate a set of useful scripts that will assist you in pinpointing the troublemaker in any given scenario: single heavy stuck query, blocking locks, or lots of small queries that drive CPU crazy. Your DBA life will be much easier with those scripts in your toolkit. Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Registration will be closed two days before the event, on 01/06. Thank you!

SQL Internals & Database DevOps

Microsoft office

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-19:15 - First Session (SQL Internals – Physical Table Structure Under the Hood and Implementation on Real Case Scenarios) • 19:15-19:30 - Break (More Networking) • 19:30-20:30 - Second Session (Database DevOps) Sessions: 1. SQL Internals – Physical Table Structure Under the Hood and Implementation on Real Case Scenarios – Ronen Ariely (90 Minutes) Understanding what we have under the hood is not only done for the sake of learning a theory, but it is directly impacts our daily work, and it can help us to improve performance and reduce resources dramatically. During this session we will go over the structure of tables behind the scenes. We will see the changes behind the scenes related to actions which we execute on the table. Using this information, we will demonstrate several real case scenarios, and the dramatic impact of understanding the internals on choosing our solution. Is order of columns important? Is dropping a column the right solution? Questions like these are very common in the forums, and usually do not get the right answer. This session is a live demo. 2. Database DevOps – Elie Muyal (30 Minutes) DevOps on databases presents particular challenges due to the very nature of databases. In this session, we will discuss how to overcome those challenges and to obtain the right balance between conflicting goals in a Database DevOps environment: • Security versus Freedom • Collaboration versus Personalization Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Thank you!

Past events (34)

Data Services - AWS and Azure

Investing.com

Photos (88)

Find us also at