Israeli SQL Server User Group

 

 

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:

            Microsoft

         PASS

            

            

Next Meeting

Next Meeting

Monday,

March

03

March Israel PASS Chapter Meeting

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 17:30 - 20:30 (UTC+02:00) Jerusalem
  • Language: Hebrew

Noam Binyamini     Matan Yungman

Featured Presentation:

Windows Azure SQL Database (WASD) Troubleshooting

Noam Binyamini , Senior support engineer Israel CTS group

In this session we will learn the key differences between Windows Azure SQL Database (PaaS) to SQL Server on Windows Azure VM (IaaS). We will go through different methods to troubleshoot issues such as Connectivity and Performance, and supply some practical advice and tips.

About Noam:
Noam Binyamini is a senior support engineer at Israel CTS group specializing is SQL Server, BI and web development. Blog: http://blogs.microsoft.co.il/blogs/noambi/ Twitter: https://twitter.com/NoamBinyamini

Query Progress Tracking in SQL Server

Matan Yungman, SQL Server DBA Microsoft

It's 18:00 o'clock on Thursday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. You start cursing yourself for not waiting to Sunday, take off your bag and start searching for the problem. What should you do now? In this hands-on session, we will go over the ways SQL Server gives us for tracking progress of processes and queries, and identifying bottlenecks in real-time. Among other topics, we will talk about the percent_complete column, how can CXPacket wait type help us, to Rollback or not to Rollback, and how can the new sys.dm_exec_query_profiles DMV help us.

About Matan:
Matan Yungman is a SQL Server DBA at the Microsoft Protection Services operations team. He has 10 years of experience working with SQL Server, focusing mainly on performance tuning, database development, high availability and database design. Over the last few years he has taken part in various challenging projects around SQL Server. He is passionate about SQL Server and technology in general.

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