Next Meeting

Thursday,

October

30

October 2014 Israel PASS Chapter Meeting

  1. Working with Very Large Tables Like a Pro in SQL Server 2014 (Guy Glantser, Madeira)
  2. A common use case in many databases is a very large table, which serves as some kind of activity log, with an ever increasing date/time column. This table is usually partitioned, and it suffers from heavy load of reads and writes. Such a table presents a challenge in terms of maintenance and performance. Activities such as loading data into the table, querying the table, rebuilding indexes or updating statistics become quite challenging.

    SQL Server 2014 offers several new features that can make all these challenges go away. In this session we will analyze a use case involving such a large table. We will examine features such as Incremental Statistics, New Cardinality Estimation and Delayed Durability, and we will apply them on our challenging table and see what happens...

    Guy Glantser (Blog|Twitter) is the leader of the Israeli PASS chapter and also the CEO of Madeira SQL Server Services. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, PASS Summit and user groups around the world. He also co-hosts the SQL Server radio show.

    Guy Glantser

     

  3. Remote session: SQL Server Internals and Architecture (Kevin Kline, SQL Sentry)

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

-What are the various areas of memory inside of SQL Server?
-How are queries handled behind the scenes?
-What does SQL Server do with procedural code, like functions, procedures and triggers?
-What happens during checkpoints? Lazywrites?
-How are IOs handled with regards to transaction logs and databases?
-What happens when transaction logs and databases grow or shrink?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

Kevin Kline (Blog|Twitter) is an expert and author on topics like SQL, data management, big data, IT leadership, enterprise architecture and building technical communities. Author of "SQL in a Nutshell", popular conference speaker, blogger, magazine columnist and world traveler.

Kevin Kline

 

 

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