Israeli SQL Server User Group

 

 

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:

            Microsoft

         PASS

            

            

Next Meeting

Next Meeting

Sunday,

May

11

May Israel PASS Chapter Meeting

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 17:30 - 20:30 Jerusalem Daylight Time
  • Language: Hebrew

  1. Troubleshooting Shared Storage for DBAs (Brent Ozar) - 17:30-18:30

Your SQL Server's data lives on the SAN, and you're not happy about that. All the Perfmon metrics you gather seem to point to a storage problem, but the SAN admin says the storage is sitting around bored, so it must be a SQL Server problem. Brent Ozar feels your pain - years ago, he was a DBA in the same position, so when his SAN admin quit, Brent took the job. In just 90 minutes, he'll teach you what's inside the SAN, why multipathing is so important, how to test storage throughput, and why TempDB should be on local SSDs.

This session is going to be presented on screen through the Global Hebrew virtual chapter. People in the audience will be able to ask Brent questions throughout the session.

Brent Ozar (Blog|Twitter)is aMicrosoft Certified Master of SQL Server, MVP, published author and consultant.

Brent Ozar

 

  1. In-Memory OLTP – Diving Deep and Getting Practical (Shy Engelberg, Hynt) - 18:30-19:30

The In-Memory OLTP is a fantastic new feature that has proven ability for improving throughput by x30. In this session I will take the theory and bring it into the practical world. I will answer the following questions, among others:
- In what scenarios should we expect to get x30 boost?
- What are the steps of migrating an existing application?
- How to manage the storage and memory?
- What types of indexes exist? When should I create each of them?
- How can I migrate my stored procedures and code?

Shy Engelberg (Blog) is a senior SQL Server DBA and consultant at HYNT. For the past 9 years he has been designing, maintaining, tuning, developing and supporting mission critical databases of all scales, both as a DBA and as a team leader.

Shy Engelberg

 

  1. The Power of Powershell for the DBA (Lior King, SuperDerivatives) - 19:45-20:45

Powershell enables the DBA to automate complex tasks easily and efficiently. In this session we will learn about the principles of Powershell. We will suggest ways in which Powershell can be used to automate complex tasks and make it a useful tool in the DBA's toolbox.

Lior King (Blog)is living and breathing the IT world for more than 20 years as a developer, as a DBA and as an instructor. He is passionate about information technologies andhas beeninvolved in many complex data projects.

Lior King

 

Supplementary Materials

The following event attachments are available to you:

 

 

Israel Blogging Community:

Guy Glantser Dubi Lebel Matan Yungman Meir Dudai Geri Reshef Maria Zakourdaev Noam Brezis Eitan Blumin Asaf Aviv Michael Zilbershtein Itai Binyamin Ronen Ariely Pini Krisher

 

 

SQL Joke of the month:

DBAs make the best husbands. They understand relationships and know how to commit

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