SQLSaturday #59 - New York City 2010

Event Date: 11/20/2010 00:00:00

Event Location:

Microsoft Offices Midtown Manhattan
1290 Avenue of the Americas
New York City, New York

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: DMV’s as a Shortcut to Procedure Tuning

Abstract: Dynamic Management Views (DMV) expose a wealth of information to the database administrator. However, they also expose information that is vital to the database developer. More often than not people gather performance metrics through server side traces. This session will show how to gather information from the DMVs for currently executing, and recently executed queries. The session will demonstrate combining this information with other DMVs to get more intersting information such as the query plan and query text. I’ll show where you can get aggregate information for the queries in cache to determine which queries are being frequently accessed or using the most resources. Indexes used, fragmentation and more.

Speaker(s):

Grant Fritchey

Track and Room: Track 2 - N/A

Title: I/O I/O It’s Why My Server’s Slow - Waits Queues

Abstract: Based on the popular cover-story article appearing in SQL Server Magazine, Robert Pearl expands on ways to measure SQL Server’s performance and present the information in a readable and useful format. He will bring us useful tips for getting and analyzing I/O information, and troubleshoot performance bottlenecks.

In addition, Robert will scratch the surface and introduce performance tuning using a methodology called Waits and Queues, with respect to I/O. By using this methodology one can identify the best opportunities to improve performance, the so called “biggest bang for the buck”. These performance improvements are likely to have a significant return on the performance tuning time investment.

Speaker(s):

Robert Pearl

Track and Room: Track 2 - N/A

Title: Transactional Replication Fundamentals

Abstract: Transactional Replication is a popular method for distributing data in SQL Server. It is most frequently used to offload reporting from an OLTP server to a reporting/OLAP Server. In this session SQL Server MVP Hilary Cotter shows you how to get up to speed quickly in deploying transactional replication solutions, as well as to how to squeeze optimal performance out of your transactional replication topology. Also covered is how to achieve DR using transactional replication, bi-directional transactional replication, how to integrate your replication solution with your DR solution. Also covered is peer to peer replication, a form or replication which keeps multiple geographically dispersed nodes to keep synchronized.

Speaker(s):

Hilary Cotter

Track and Room: Track 6 - N/A

Title: Get your database under version control

Abstract: It’s a given that the source code to your project’s ETL, Cubes, User Interfaces, WCF services, etc are kept under tight version control. But many developers turn a blind eye to source code in their database - the critical views, stored procedures, and user defined functions.

With a few concepts and tools build into every version of SQL Server I’ll show how to build simple and free version control for your project.

Speaker(s):

Scott Weinstein

Track and Room: Track 4 - N/A

Title: Notes on Linked Servers

Abstract: Did you know that permission can have a profound impact on performance? Did you know that sometimes it’s better to move data to the logic and other times it’s better to move the logic to data? Did you know that it can make a huge performance difference whether you push data or pull data across the servers? The common thread among these questions is linked servers. Because of the convenience they provide in moving data around on the server side, linked servers are used in almost all the SQL Server environments, and are often abused in many. This session focuses on a series of linked server cases–primarily performance related cases–encountered in in the real world to help reveal traps and highlight best practices.

Speaker(s):

Linchi Shea

Track and Room: Track 5 - N/A

Title: Data Vault and the Data Warehouse

Abstract: Data vaults are new constructs for the Data Warehouse. This session will

1) Introduce and discuss the data vault design technique 2) Discussion data movement from a data vault to a dimensional model and 3) Provide high performance ETL to implement them within SQL Server.

Speaker(s):

Chuck Kelley

Track and Room: Track 5 - N/A

Title: SQL Server Development Tips and Tricks

Abstract: This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment.

Speaker(s):

Roman Rehak

Track and Room: Track 4 - N/A

Title: Performance Tuning Made Easy

Abstract: Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

Speaker(s):

Thomas LaRock

Track and Room: Track 1 - N/A

Title: Cool Reporting Features in SSRS 2008R2

Abstract: In this presentation, I’ll show about a half-dozen different report examples in SSRS 2008R2. Each report demonstrates different features in SSRS 2008R2 that are sure to please different business users. These new features include sales heat maps, sparklines, performance gauges, better page control, uses for the Tablix control, better charting, and new features for SharePoint 2010 integration.

Speaker(s):

Kevin Goff

Track and Room: Track 1 - N/A

Title: High Performance SSIS Dimensional Datamart Loads

Abstract: Performance-driven SSIS ETL solutions require a mix of both SQL and SSIS developer optimizations. In this session attendees will learn SQL code and SSIS data flow optimizations, tips and best practices that are specifically geared to obtain the best performance from your enterprise ETL solution. This session is specific to Datamart ETL, but much of the information presented can be applied to any SSIS solution.

Speaker(s):

Michael Coles

Track and Room: Track 6 - N/A

Title: Three cool packages in SSIS 2008

Abstract: If you know the basics of SSIS, and/or you simply want to see some intermediate-advanced examples, this session is for you. I’ll spend about 20 minutes walking through 3 different SSIS packages that show tricks for using the data flow pipeline, scripting, multicast, aggregations, merge joins, package configurations, FTP, dynamic expressions, and even the dreaded Excel destination component. These packages are based on a 2-part article of mine that was published in CoDe magazine this year.

Speaker(s):

Kevin Goff

Track and Room: Track 1 - N/A

Title: Failover Clustering with Windows Server 2008 R2

Abstract: Forget a good portion of everything you know about clustering - Windows Server 2008 changes the game. Come see how the changes and improvements affect clustered SQL Server deployments. In addition to Windows, both SQL Server 2005 and SQL Server 2008 will also be discussed. The focus will be on SQL Server 2008 and how its changes to the setup, upgrade, and patching processes (among other things) impact the configuration and administration of a clustered SQL Server 2008 instance. Live demos will be shown, and one copy of Allan’s latest book, Pro SQL Server 2008 Failover Clustering, will be given away.

Speaker(s):

Allan Hirt

Track and Room: Track 4 - N/A

Title: Keeping your SQL Code DRY

Abstract: Don’t Repeat Yourself - it’s the golden rule of good code, and with Common Table Expressions, Table Values Functions, and the APPLY operator, we’ll show how well structured code can be created without stored procedures.

Speaker(s):

Scott Weinstein

Track and Room: Track 5 - N/A

Title: SSRS Interactive Reports

Abstract: I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports.

Speaker(s):

Matt Van Horn

Track and Room: Track 1 - N/A

Title: PowerPivot for Excel and SharePoint 2010

Abstract: In this session, I will cover PowerPivot - a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine, I will interactively explore and perform calculations on very large data sets. This session gives the user the freedom to learn the many uses of PowerPivot from importing, modeling, analyzing and pivoting millions of records to publishing to SharePoint. I will show how IT staff can track and monitor user generated PowerPivot workbooks in SharePoint and explore PowerPivot Management Dashboard.

Speaker(s):

Ayad Shammout

Track and Room: Track 3 - N/A

Title: Database Design Contentious Issues

Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Implementing Party/party role * Natural vs. Surrogate keys * Today’s vs. Tomorrow’s Requirements * SOAs, Ontologies, ESBs, New TLAs and Shoe Strings * What is Logical? What is Physical? Why Do We Care? * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.

Speaker(s):

Karen Lopez

Track and Room: Track 2 - N/A

Title: MDW-What’s going on in my server?

Abstract: A deep dive into the configuration and utilization of the Management Data Warehouse feature in SQL Server 2008. This session will discuss how MDW is configured, managed and utilized. Also, how to generate reports and to customize data collection for your environment.

Speaker(s):

Joseph D’Antoni

Track and Room: Track 5 - N/A

Title: Partitioning in SQL Server 2005/2008

Abstract: Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple, efficient. Manageability and performance come part and parcel.

Speaker(s):

Jana Sattainathan

Track and Room: Track 3 - N/A

Title: The Modern Resume: Building Your Brand

Abstract: Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job.

Speaker(s):

Steve Jones

Track and Room: Track 4 - N/A

Title: So Many High Availability Options, So Little Time

Abstract: Are you confused by the various SQL Server high availability technologies? Do you understand what each one does and where each one may or may not benefit you? Do you know the basics of what you need to implement highly available SQL Server instances and databases? If these burning questions speak to you, so will this session. Whether you are an accidental DBA, new to SQL Server, or looking to brush up your skills, this session will cover the different methods of making SQL Server available, compare and contrast them, as well as and cover the top things you need to do to ensure uptime. Where appropriate, demos will be shown.

Speaker(s):

Allan Hirt

Track and Room: Track 2 - N/A

Title: Attribute Discretization in Analysis Services

Abstract: Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.

Speaker(s):

William E Pearson III

Track and Room: Track 3 - N/A

Title: Getting Started with MDX

Abstract: In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

Speaker(s):

William E Pearson III

Track and Room: Track 3 - N/A

Title: The Benefits of SQL Azure

Abstract: This talk will focus on the benefits, features, and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure. Real world topics and use cases will be covered including data sync and staying vendor independent while hosting your data in the cloud.

Speaker(s):

Aaron King

Track and Room: Track 6 - N/A

Title: Handling data anomalies with Data Profiling Tasks

Abstract: Within the realm of the financial world, data is often sourced from a plethora of financial systems that more often than not have different formats and business rules. This poses many challenges to the integration of the data into corporate data warehouses. Metrics and tools to detect data anomalies (prior to insertion into the corporate data warehouses) were often difficult to create and often overlooked. This hands-on presentation will show the attendee how we have been able to revamp and revise our preload data validations, often removing many of our ‘early warning’ queries and replacing these with SSIS 2008 Data Profiling Tasks.

Speaker(s):

Steve Simon

Track and Room: Track 4 - N/A

Title: 12 ways to write POORLY performing MDX queries

Abstract: OLAP cubes have become an important means of delivering valuable information from complex data within the Corporate Data Warehouse. Adequate information helps the corporate decision makers take the necessary steps to ensure that the enterprise is heading in the correct direction, especially in the tough and turbulent economic times. This beginner’s to intermediate level hands-on presentation is aimed at showing the attendee some of the pitfalls of poorly designed and poorly performing MDX queries and how many of the queries may be optimized to ensure that they are both efficient and effective.

Speaker(s):

Steve Simon

Track and Room: Track 2 - N/A

Title: Deploying Data Tier Applications with SQL 2k8 R2

Abstract: Data Tier Applications (DAC Packs) are a new feature in SQL 2008 R2, that alllow developers to better simplify environmental management. In this demo, I will define the requirement surrounding DAC packs, then build and deploy a sample.

Speaker(s):

Joseph D’Antoni

Track and Room: Track 5 - N/A

Title: Building Business Contacts at IT Conferences

Abstract: Networking is challenging for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop, conversation expert and best-selling author Don Gabor will guide you through the networking process—including remembering names—and show you how to make professional connections that will pay off for years to come.

Speaker(s):

Don Gabor

Track and Room: Track 6 - N/A

Title: Building a High Availability SQL Server 2008 R2

Abstract: If you are new to SQL Server 2008 R2, you will learn how to utilize Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. In this session, I will show how we minimize downtime while migrating from SQL Server 2005 Cluster to SQL 2008 R2. This session includes real life deployment and upgrade scenarios to achieve high availability and disaster recovery, the lessons learned, and the best practices. Technologies covered include Failover Clustering on Windows Server 2008 R2 and SQL 2008 R2 Database Mirroring.

Speaker(s):

Ayad Shammout

Track and Room: Track 3 - N/A

Title: Light-up BI Dashboards with Cool Visualizations

Abstract: Discussion demos on techniques you can leverage to create cool dashboards with compelling visualizations for office-based users and mobile users. This session will be geared toward SQL Server professionals with .NET code samples that can be easily re-used in your SQL Server BI applications.

Speaker(s):

Mark Kromer

Track and Room: Track 1 - N/A

Title: OData For DBAs

Abstract: An introduction for DBAs to OData - A Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today.

Speaker(s):

Don Demsak

Track and Room: Track 6 - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Chuck Kelley

Chuck Kelley is an internationally known expert in database technology. He has over 30 years of experience in the design and implementation of operational/production systems, operational data stores and data warehouses/data marts. Chuck has been an architect, project manager, data modeler (normalized, data vault, and dimensional modeling), database administrator, metadata designer and/or ETL developer on over 50 data warehouses. He has collaborated on 4 books on Data Warehousing.

Don Gabor

Twitter: - https://twitter.com/DonGabor

LinkedIn: Don Gabor

Contact: http://dongabor.blogspot.com/

Don Gabor is a networking expert, communications trainer, and the author of the best-seller, “How to Start a Conversation and Make Friends,” plus 10 books and audio programs on networking, conversation, and public speaking. His books have been translated into more than 25 languages.

Don was a media spokesperson for Grand Marnier, Frito-Lay, and Sprint and is a frequent media guest. His books have been featured in hundreds of media interviews, including on “60 Minutes” with Andy Rooney.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Ayad Shammout

Twitter: - @aashammout

LinkedIn: Ayad Shammout

Contact: http://ayadshammout.com/

Ayad Shammout is a Database amp; BI Specialist and Microsoft MVP. He has more than 25 years deep experience in Database technologies and specializing in SQL Server, SharePoint, Windows OS. Shammout is working in OLTP design and development, Data Warehousing, Business Intelligence and Big Data, with extensive experience in data management and analysis. Ayad has been involved in many SQL Server Enterprise implementations for High-Availability, DR, Business Intelligence, Data Mining and Big Data.

Matt Van Horn

Contact: http://www.anythingtheycando.com/blog/index.php

Matt, a seasoned developer with proficiencies in a wide-array of programming languages and platforms, focuses on creating flexible and dynamic code tailored to the specific needs of customers. Matt is an experienced presenter, regularly speaking at Usergroup meetings and Code Camps.

Aaron King

Twitter: - trendoid

LinkedIn: Aaron King

Contact: http://www.aaronstanleyking.com

Aaron King is a application architect specializing in enterprise web applications and very large databases.

Thomas LaRock

Twitter: - @SQLRockstar

LinkedIn: Thomas LaRock

Contact: http://thomaslarock.com

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Steve Simon

Contact: http://www.infogoldusa.com

Steve Simon is an AVP with State Street Corporation Boston. He has been involved with database design and analysis for over 23 years. He has presented papers at eight PASS Summits and PASS Europe 2009 2010. He is the chairman of the PASS SQL Server / Oracle Virtual Chapter in addition to being a PASS Regional Mentor. He is also a regular presenter at SQLSaturdays and regional Code Camps.

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

Scott Weinstein

Scott Weinstein is a practice head at Lab49, manages the New York .Net Meetup, and is a frequent speaker on SQL, .Net, WPF, and reactive programming at SqlSaturday, CodeCamp, and the Alt.Net meetups in NYC

Steve Simon

Contact: http://www.infogoldusa.com

Michael Coles

Contact: http://sqlblog.com/blogs/michael_coles/default.aspx

Michael Coles is an independent consultant with 15+ years’ SQL Server experience. He has architected several high-performance enterprise ETL solutions for Fortune 500 clients, and has authored or coauthored several books on SQL topics including “Pro T-SQL 2008 Programmer’s Guide”, “Pro SQL Server 2008 XML”, and “SQL Server MVP Deep Dives”. Michael is a Microsoft MVP (SQL).

Jana Sattainathan

Twitter: - www.twitter.com/SQLJana

LinkedIn: Jana Sattainathan

Contact: http://www.sqljana.wordpress.com

Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.

Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Scott Weinstein

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Hilary Cotter

Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker.

Hilary is also an author, or contributor on a number of books on SQL Server.

Linchi Shea

Twitter: - @linchi_shea

Contact: http://sqlblog.com/blogs/linchi_shea/

Mark Kromer

Twitter: - @kromerbigdata

LinkedIn: Mark Kromer

Contact: http://www.kromerbigdata.com

Mark Kromer is a Microsoft Cloud Data Solution Architect with 20 years of experience in database applications, data warehouses, big data and business intelligence.

Robert Pearl

Twitter: - @PearlKnows

LinkedIn: Robert Pearl

Contact: http://www.sqlservercentral.com/blogs/pearlknows/

Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.

Don Demsak

Contact: http://www.donxml.com

Don Demsak is the Chief Technical Officer at Tellago, Inc. Don specializes in building enterprise service oriented applications with .Net. He has a popular blog at www.donxml.com, is a Microsoft MVP, and a member of the INETA Speakers Bureau.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Ayad Shammout

Twitter: - @aashammout

LinkedIn: Ayad Shammout

Contact: http://ayadshammout.com/

Roman Rehak

LinkedIn: Roman Rehak

Contact: http://sqlblog.com/blogs/roman_rehak/

Roman Rehak is a Principal Database Architect at MyWebGrocer.com in Burlington, VT. He specializes in SQL Server development and database architecture. He writes articles for Visual Studio Magazine, SQL Server Magazine, SearchSqlServer.com and other technical publications. Roman presents at user groups and conferences in US and Canada. He has served as the Tech Chair for the SQL Server track at DevTeach and PASS conferences, and is the president of the Vermont SQL Server User Group.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

SQLSaturday #59 - New York City 2010

Sessions

Title: DMV’s as a Shortcut to Procedure Tuning

Title: I/O I/O It’s Why My Server’s Slow - Waits Queues

Title: Transactional Replication Fundamentals

Title: Get your database under version control

Title: Notes on Linked Servers

Title: Data Vault and the Data Warehouse

Title: SQL Server Development Tips and Tricks

Title: Performance Tuning Made Easy

Title: Cool Reporting Features in SSRS 2008R2

Title: High Performance SSIS Dimensional Datamart Loads

Title: Three cool packages in SSIS 2008

Title: Failover Clustering with Windows Server 2008 R2

Title: Keeping your SQL Code DRY

Title: SSRS Interactive Reports

Title: PowerPivot for Excel and SharePoint 2010

Title: Database Design Contentious Issues

Title: MDW-What’s going on in my server?

Title: Partitioning in SQL Server 2005/2008

Title: The Modern Resume: Building Your Brand

Title: So Many High Availability Options, So Little Time

Title: Attribute Discretization in Analysis Services

Title: Getting Started with MDX

Title: The Benefits of SQL Azure

Title: Handling data anomalies with Data Profiling Tasks

Title: 12 ways to write POORLY performing MDX queries

Title: Deploying Data Tier Applications with SQL 2k8 R2

Title: Building Business Contacts at IT Conferences

Title: Building a High Availability SQL Server 2008 R2

Title: Light-up BI Dashboards with Cool Visualizations

Title: OData For DBAs

Speakers

Sponsors