Israeli SQL Server User Group

 

 

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:

            Microsoft

         PASS

            

            

Next Meeting

Next Meeting

Sunday,

June

22

June 2014 Israel PASS Chapter Meeting

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

  1. Database Lifecycle Development on Gears (Daniel Maxic, Pontis)

In today’s world, more and more applications are dependent on databases. As a developer\ALM\architect\DBA you may encounter the difficulties of maintaining an appropriate development lifecycle. In this session we will review the SSDT database services, a set of tools, provided by Microsoft, enabling us to enjoy the same known ALM covering tools, to provide full ALM services for databases, such as source code management, building services, deployment services, code analysis and more. We will see a brief review of the current challenges of modern applications and how we can provide DevOps tools to better support our applications and databases.

Daniel Maxic is a data infrastructure engineer at Pontis. He is a Microsoft Certified Master (MCM) for SQL Server and a Microsoft Certified Trainer (MCT).

Daniel Maxic

 

  1. Big Data Inside: Columnstore Indexes in SQL Server 2014 (Michael Zilberstein)

One of the most interesting new features in SQL Server 2014 is the updateable columnstore index (clustered and non-clustered). Actually, it is a major breakthrough that brings core SQL Server to the league of products like Vertica, Sybase IQ, etc. - those capable of analyzing hundreds of gigabytes of data in real-time. But like any powerful tool, it should be treated with caution. In this session we will start with an overview of columnstore index architecture in general and then dive into clustered columnstore index internals: how it works, how it is updated, how to use it efficiently and how to avoid performance issues when a columnstore index isn't used in a proper way.

Michael Zilberstein (Blog), database consultant and architect, 13 years of experience with SQL Server. Specializing in data-intensive applications in the broadest way - architecture, design and performance - both hardware and software. Besides SQL Server, Michael is passionate about hiking, chess and history.

Michael Zilberstein

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