Search
Sunday, May 19, 2013 ..:: Meetings » Past Meetings » Past Meetings - 2011 ::.. Register  Login
 November 17, 2011
Minimize
 

 

 

 

Delivering Database High Availability
Introduction to SQL Server Routing
 
Abstract:
SQL Database routers constitute a major paradigm shift by replacing the traditional active-passive network with an active-active network. This enables a low cost, plug & play appliance to perform load balancing, dramatically improves read performance, increases persistence, simplifies failover and re-synchronization. Nerras President, Doug Chan, will describe the implementation and technology necessary to achieve this type of performance improvements.
Presenter's Bio:
Doug Chan is founder and President with Nerras Systems. In this role, Doug leads a team providing SQL Server high availability appliances, including load balancing and server failover. A big believer in ease of use, Doug supports the concept of plug and play appliances to simplify technical challenges like high availability.
Before starting Nerras Systems, Doug worked for over 20 years for a diverse range of organizations, including HP, Alteon Websystems, Ingres Data Systems and other small business startups. Doug held various roles including member of technical staff, and corporate executive. Doug’s varied background in database and networking provided the perfect foundation for Nerras Systems. Passionate about Nerras and its possibilities, Doug aims to provide features that help SQL Server avoid downtime and enhance SQL performance.

 

  
 September 15, 2011
Minimize

 

 

 

Benjamin Nevarez
 
Inside the SQL Server Query Optimizer
 
Abstract:
The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. I'll show you how the Query Optimizer generates possible alternative execution plans, how these plans are stored for the duration of the optimization process, how heuristics are used to limit the number of alternative plans considered, how each candidate plan is also costed, and finally how the best alternative is chosen based on those costs. I will also cover why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are still being addressed today.
Bio:
Benjamin Nevarez is a database professional based in Los Angeles, California and author of "Inside the SQL Server Query Optimizer", published by Red Gate books. He has more than 15 years of experience with relational databases, and has been working with SQL Server since version 6.5. Benjamin has also been the technical editor of the two latest books by Kalen Delaney including "SQL Server 2008 Internals". He holds a Master's Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Summit. Benjamin's blog is at http://www.benjaminnevarez.com and can be reached by e-mail at admin@benjaminnevarez.com.

 

  
 July 21, 2011
Minimize

Microsoft Parallel Data Warehouse (PDW)

 
 
Speaker's Bio:
 
Ted Tasker joined Microsoft in 2008 as a Technology Solution Professional and is now focused on SQL Parallel Data Warehouse. Ted has over 17 years of experience with SQL Server going back to version 4.2.1. Prior to joining Microsoft, he spent 10 years leading DW and BI groups in financial and Internet entertainment companies. In his current role, Ted provides technical guidance and support in evaluation and implementation planning of very large SQL Server Data Warehouses for customers in the U.S.
In the last 6 months Ted has personally worked on 5 PDW proof of concepts and can speak directly to the capabilities of the product.

 
  
 May 19, 2011
Minimize

 

 
Taking Your Application Design to the Next Level with Analysis Services Data Mining
 
Speaker: Peter Myers
 
PowerPoint slides from this presentation have been posted on our website. Click Here
 
  
 March 17, 2011
Minimize
Managing Test Data and Stress Testing Your SQL Applications
 
Speaker: Joel Champagne
This talk will take a quick look at some of the available functionality for SQL developers who have access to Visual Studio 2010.
With Visual Studio 2010 Premium (and Professional to a degree) delivering similar capabilities to what was available in VS 2008 Database Pro Edition, the ability to generate a mass amount of sample data for your database has only gotten more accessible with time.
Realizing that other tools exist in this space and not all SQL developers use Visual Studio, we’ll also take a look at the third party data generation facility available in SQL-Hero, seeing how we can create thousands (or millions!) of records very quickly using a powerful rules engine, plus automate this process to support continuous integration strategies.
For example, we’ll take an existing production database with sensitive data, run a simple script that obfuscates the sensitive data, and publishes it as an updated development environment. Joel will also discuss how he’s used these tools to uncover possible performance problems prior to release of large applications.
 

 

  
 January 20, 2011
Minimize

 
Allen Berezovsky
File Stream in SQL Server
Presentation Abstract:
 
Allen will discuss different ways we as developers handle BLOBS. In particular, Allen will show a real application where he has to store and retrieve thousands of Images, and the pros and cons of using SQL Server 2008's new FILESTREAM data type as a solution. He will also show two different methods of working with SQL Filestream from ASP.NET, including using LINQ to SQL.
 
BIO:
Allen Berezovsky is an MCITP Database Developer, and a senior database engineer with HarborObjects, LLC. Allen has over 12 years of hands-on experience developing data-driven web applications. Allen helps run the SQL Server Users group in Orange County - that is when it doesn't conflict with his Thursday night basketball league. Afterhours, Allen is a professional photographer, an amateur musician, and an out-of shape basketball player.
 
Benjamin Nevarez
Top 10 Query Optimizer Topics for Better Performance
 

Abstract:

This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. The SQL Server Query Optimizer is a cost-based optimizer whose job it is to analyze the possible execution plans for a query, estimate the cost of these plans and select the one with the lowest cost. So a better knowledge of how the Query Optimizer works can help both database developers and administrators to get better performance from their databases. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.

Bio:

Benjamin Nevarez is a database professional based in Los Angeles, California. He is the author of “Inside the SQL Server Query Optimizer” to be published by Red Gate Books this January. Benjamin has more than 15 years of experience with relational databases, and has been working with SQL Server since version 6.5. He holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Summit. Benjamin’s blog is at http://www.benjaminnevarez.com, and he can be reached at reached at admin@benjaminnevarez.com.

  
Copyright 2004-2013 by Los Angeles SQL Server Professionals Group, Inc.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2013 by DotNetNuke Corporation