Data Platform & BI Keynote
Speaker: Franck Sidi & Ori Weinroth | Technology : SQL Server
Ori Weinroth and Franck Sidi will present the Data Platform and BI Joint Keynote.
In the first part of the Keynote, they will focus on customer mission critical testimonies
and cloud solutions (SQL Azure). They will introduce and demo Microsoft Parallel
Data Warehouse Solution and the new SQL 11 Data Platform Capabilities.
View
|
|
Microsoft SQL Server Data Compression: Experience and Changes
Speaker: Sunil Agarwal | Technology: SQL Server
Data Compression has been one of the most popular features of SQL Server 2008. In
this presentation we look into the common customer questions regarding usage scenarios
and performance. We then examine changes to Data Compression (i.e., Unicode Compression)
available in SQL Server 2008 R2. Attendees should already be familiar with the basics
of ROW and PAGE compression features introduced in SQL Server 2008.
View
|
|
New High Availability Solution in SQL Server “Denali”
Speaker: Justin Erickson & Oren Bouni (Microsoft Israel)| Technology: SQL Server
Come to this session to learn about the new High Availability Solution coming in
the next release of SQL Server codename "Denali". We will introduce you to the features
which will be available in CTP1 including multi-database failover unit, integration
with Windows Server Failover Clustering, and readable secondaries.
View
|
|
Mission Critical: Improving High Availability and Reliability
Speaker: Assaf Fraenkel | Technology: SQL Server
In this session we will present best practices from the field for achieving high
availability and strong reliability for Mission Critical applications. We will explain
how to choose the right solution from the menu of HA options provided by SQL Server.
We will also discuss architecture, monitoring, and establishing an SLA.
View
|
|
Designing High Performance I/O System with SQL Server
Speaker: Dubi Lebel | Technology: SQL Server
In this session we will try to provide the “full story” about I/O. We will start
at the hardware level working our way up the stack through Windows and into the
SQL Server storage engine (including Analysis Services). We aim to provide in depth
information about all aspects related to high performance storage design for SQL
Server and best practices on this naturally complex subject. We will also present
real-life feedback on a very challenging workload.
View
|
|
Strategies to get maximum concurrency for your workload in SQL Server
Speaker: Meir Dudai | Technology: SQL Server
עם התקדמות הטכנולוגיה, יותר ויותר ארגונים מעלים את רף הדרישות לרמת הביצועים והזמינות
של בסיסי הנתונים שלהם. מערכות מבוססות SQL Server של עשרות טרה בייט ואלפי שאילתות
לשניה הן כבר מראה שכיח. בהרצאה זו נסקור את הדרכים והטכנולוגיות ליישום מערכות הדורשות
Concurrency גבוה על SQL Server. אנחנו נעבור על נושאים פחות מוכרים ל-DBA הממוצע ונראה
איך ניתן לנצל יכולות חדשות בגירסאות האחרונות של SQL Server כדי להשיג מקסימום Concurrency.
בין היכולות שנסקור:
- RCSI & Bulk Loading
- שיפורים ב-Lock Escalation
- ביזור פעילות מול בסיסי הנתונים על ידי יכולות חדשות בגירסאות 2008, 2008 R2 ו-Denali
בהרצאה יהיה לי את הכבוד לארח את מר Sunil Agarwal ממיקרוסופט. Sunil הוא Senior Program
Manager בקבוצת המוצר, והוא ידבר על אחד הנושאים הפנימיים והפחות מוכרים בעולם הנעילות:
האויב השקט אך המסוכן של ה-Concurrency.
View
|
|
Migrating to SQL Server from Other Databases: Lessons Learned and Best Practices
Speaker: Dmitry Balin & Lior Ribalov | Technology: SQL Server
Migrating a solution from a specific RDBMS to another (from Oracle or DB2 to SQL
Server in this case) can be a very complex task. You’ll be successful only using
a combined approach of supporting tools (like SQL Server Migration Assistant for
Oracle), best practices and proven conversion patterns. Oracle PL/SQL feature set
is powerful and, historically speaking, Java, C++ and also .NET developers used
it extensively in enterprise-class applications, together with several data access
techniques (JDBC, OLE DB, ADO.NET and other libraries). In this session DBBest Team
will share their experience working on several big and critical migration projects
with a particular focus on performance issues and successful approaches. We will
also present the successful Case Study from an Israeli customer who did migrate
from DB2 to SQL Server.
View
|
|
Microsoft SQL Server Execution Plans: From Compilation, to Caching, to Reuse
Speaker: Ami Levin | Technology: SQL Server
Execution plan reuse is one of the most important aspects of building well-performing
and scalable SQL Server solutions. But it's also the one that is often overlooked
during the design phase and becomes very difficult to troubleshoot later. In this
session we discuss in detail the following aspects of SQL Server execution plans:
compilation, re-compilation, parameterization, caching, reuse, and aging. You will
leave this session with full understanding of how to improve your server's performance
by increasing execution plan reuse (and how to avoid reuse in case this is necessary)
View
|
|
Troubleshoot Like a Pro with the Microsoft SQL Server 2008 Tools
Speaker: Guy Glantser | Technology: SQL Server
In this session, learn how to use tools like Performance Monitor, DMVs, Resource
Governor, Performance Data Collector and Extended Events to detect and troubleshooting
performance problems with SQL Server 2008/2008R2. This session will be demo-intensive.
View
|
|
