Abstract In this session we will examine one of SQL Servers’ most fundamental yet most important functions – how does SQL Server store data on disk and how does it find it again when executing a query. Using a combination of demos, lecture and discussions we will begin with the structure of the data on more »
Abstract It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not more »
Abstract This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affects query concurrency and performance. Downloads Slides Other Resources Microsoft® SQL Server® 2008 Internals (Pro – Developer) SQL Server 2005 more »
SQL Server Performance Monitoring Basics Will my SQL Server keep up with the load of tomorrow? This class will give you tools that enable you to see performance trends and identify problems before they become problems. On the way to this goal we will stop at these stations: An introduction to the ACID properties with more »
follow: RSSBad Behavior has blocked 174 access attempts in the last 7 days.