Meetings
 










 

Meeting 90:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Dynamic SQL (Michael Zilberstein / DBArt)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 T-SQL Tips & Tricks (Itzik Ben-Gan / Solid Quality Mentors)

Program, Presentations and Scripts
 

3/August/2009 17:30

Meeting 89:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 A comparative analysis of auditing solutions in SQL Server or how the hell can I tell who's messing with my data (Shy Engelberg / Valinor)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Change Data Capture in SQL Server 2008 (Yossi Mihailovici / Madeira)

Program, Presentations and Scripts
 

7/July/2009 17:30

Meeting 88:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 SQL Server Encryption (Adi Cohn / SRL)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Qure for SQL Server (Ami Levin)

Program, Presentations and Scripts
 

1/June/2009 17:30

Meeting 87:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Advanced SQL Server tracing (Yaniv Etrogi)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 iFTS 2008 - Hebrew fulltext in the real world (Shy Engelberg / Valinor)

Program, Presentations and Scripts
 

4/May/2009 17:30

Meeting 86:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 All about Dynamic Management Objects (Guy Glantser / Madeira)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 SQL Server and XML – Part II (Adi Cohn / SRL)

Program, Presentations and Scripts
 

2/March/2009 17:30

Meeting 85:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Database monitoring using Extended Events (Michael Zilberstein / DBArt)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 SQL Server and XML – Part I (Adi Cohn / SRL)

Program, Presentations and Scripts
 

2/February/2009 17:30

Meeting 84:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Stay tuned with Precise (Rafi Balbirsky/Precise)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Gaps and Islands (Itzik Ben-Gan/Solid Quality Mentors)

Program, Presentations and Scripts
 

5/January/2009 17:30

Meeting 83:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 SQL Server 2008 Data Compression (Kobi Chohen and Eitan Bar)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Term Management (Yonathon Storm)

Program, Presentations and Scripts
 

1/December/2008 17:30

Meeting 82:
 

Program, Presentations and Scripts
 

3/November/2008 17:30

Meeting 81:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Using Indexes to Bypass Locks (Tal Olier/HP)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:15 Filtered Indexes and Statistics (Ami Levin)

Program, Presentations and Scripts
 

1/September/2008 17:30

Meeting 80:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 When statistics simply aren't enough (based on a session by Steve Kass) / Ami Levin

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 New Microsoft BI Features (Eldad Hertz/GlassHouse Technologies)

Program, Presentations and Scripts
 

4/August/2008 17:30

Meeting 79:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Introduction to BizTalk – how it helps us in a Server Oriented Architecture (SOA) world (Pinhas Kolsky/SRL)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 The new HIERARCHYID datatype in SQL Server 2008 (Itzik Ben-Gan/Solid Quality Mentors)

Program, Presentations and Scripts
 

7/July/2008 17:30

Meeting 78:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 SQL Server Storage Internals - What do data and indexes really (and we mean really) look like? (Saggi Neumann)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Native Partitioning Challenges (Maria Zakourdaev)

Program, Presentations and Scripts
 

2/June/2008 17:30

Meeting 77:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Managing a consolidated environment on SQL Server 2008 (Shy Engelberg/Valinor)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 On canines, felines and databases (Ami Levin)

Program, Presentations and Scripts
 

5/May/2008 17:30

Meeting 76:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:30 SQL Server 2008 for Developers - Part II - Beyond Relational, Pervasive Insight (Yoni Okun)

  • 18:30 - 19:00 Q&A

  • 19:00 - 19:15 Break

  • 19:15 - 20:15 Statistics in SQL Server: usage, pits and falls (Michael Zilberstein)

Program, Presentations and Scripts
 

3/March/2008 17:30

Meeting 75:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 How to implement a 30TB project with SQL Server (Guy Twena / Valinor)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Multi View, Dashboards, Scorecards and Balanced Score Card (Yoram Levin)

Program, Presentations and Scripts
 

4/February/2008 17:30

Meeting 74:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 SQL Server 2008 for Developers (Yoni Okun)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Data Visualization and Analysis (Yoram Levin)

Program, Presentations and Scripts
 

7/January/2008 17:30

Meeting 73:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 On databases, canines and felines (Ami Levin)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Performance-oriented TSQL Programming (Michael Zilberstein)

Program, Presentations and Scripts
 

3/December/2007 17:30

Meeting 72:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Service Broker Part II (Ami Levin)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Advanced Reporting Services (Yossi Elkayam/Microsoft):
    - 1. Enterprise Reporting
    - 2. Advanced data sources
    - 3. Report Builder & Models
    - 4. Reporting Services Enhancements
    - 5. Deep diving & SDK

Program, Presentations and Scripts
 

5/November/2007 17:30

Meeting 71:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 19:45 Service Broker (Ami Levin)

  • 19:45 - 20:00 Break

  • 20:00 - 20:30 Q&A

Program, Presentations and Scripts
 

3/September/2007 17:30

Meeting 70:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Extreme Optimization Episode 2 (Ami Levin)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 SSIS-Why-When-How (Yossi Elkayam / Microsoft)

Program, Presentations and Scripts
 

6/August/2007 17:30

Meeting 69:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Microsoft Data Protection Manager 2007 for SQL Server (Saggi Neumann / Valinor)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Grouping Sets in SQL Server 2008 (Itzik Ben-Gan)

Program, Presentations and Scripts
 

2/July/2007 17:30

Meeting 68:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 SQL Server 2005 Analysis Services – Service Pack 2 (Ofer Derech / Opisoft Ltd)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Extreme optimizing part 1 (Ami Levin)

Program, Presentations and Scripts
 

4/June/2007 17:30

Meeting 67:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 SQL Certification and Index Maintenance (Assaf Fraenkel / Microsoft Consulting Services)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 Temporary Tables, Table Variables and Table Expressions (Itzik Ben-Gan / Solid Quality Learning)

Program, Presentations and Scripts
 

7/May/2007 17:30

Meeting 66:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 19:00 Datetime Calculations and Temporal Queries (Itzik Ben-Gan)

  • 19:00 - 19:15 Break

  • 19:15 - 19:45 Q&A

  • 19:45 - 20:15 SQL Server 2005 Service Pack 2 (Ami Levin)

Program, Presentations and Scripts
 

5/March/2007 17:30

Meeting 65:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 888DWH Project (7TB Data Warehouse) / Itamar Ben Hamo / Random Logic

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 SQL Server 2005: Cube from Multiple Data Sources / Osnat Israeli, Bynet / Osnat Israeli, Bynet

Program, Presentations and Scripts
 

5/February/2007 17:30

Meeting 64:
 

  • 17:30 - 17:45 Gathering

  • 17:45 - 18:45 Index Scans and Consistency Problems with NOLOCK (Itzik Ben-Gan)

  • 18:45 - 19:15 Q&A

  • 19:15 - 19:30 Break

  • 19:30 - 20:30 When Statistics Betray Us (Ami Levin)

Program, Presentations and Scripts
 

1/January/2007 17:30

Meeting 63:
 

  • 17:30 - 18:00 Gathering

  • 18:00 - 19:20 T-SQL Enhancements

  • 19:20 - 19:30 Break

  • 19:30 - 20:00 New XML Data Type

  • 20:00 - 20:10 Break

  • 20:10 - 21:00 .Net Integration

Program, Presentations and Scripts
 

4/December/2006 17:30