Bill Graziano has delivered these presenations at user groups and major conferences. Each presentation includes a download of the slides and all demo files.
Developers today face an onslaught of data storage applications. Various NoSQL offerings promise performance, scalability and easy development on commodity boxes. How does one get these benefits in SQL Server? What does a SQL Server application built today using the newest features and best practices look like? This session will discuss client applications, new SQL Server features and application architectures to support a modern, high-throughput transaction environments.
The fastest way to process large amounts of data in SQL Server is using set-based operations. That is if you can stand the blocking. This session walks through different ways to think about applications when transaction blocking becomes your biggest problem. It covers specific T-SQL suggestions to minimize the rows locked, application architectures to maximize concurrency and reporting solutions to reduce impact on the production database. And always lots of demos and spirited discussion.
This presentation walks through common steps a developer can take to write faster SQL statements and applications.
As a consultant, I visit many companies that are having performance of configuration problems with SQL Server. This session describes some of the most common problems I see from clients and explains how to avoid them. I cover reading query plans, SQL Profiler, indexing, correlated sub-queries, temporary tables, and user-defined functions, error handling and transactions and show how you can use them together to improve performance.
A "PowerPoint-less" presentation on SQL Server Administration for new DBAs and non-DBAs.
Covers the details of query plan usage.