Category Archives: Presentations

Avoiding a DBA’s Worst Days with Monitoring

Posted on October 24, 2014 by way0utwest

SQL in the City Abstract: When things go wrong with a database, it can be the start of the worst day of a DBA’s life. Join Steve Jones as he examines the problems uncovered by The DBA Team and how … Continue reading →

Posted in Presentations | Tagged , | 1 Comment

Intermediate T-SQL: Window Functions

Posted on October 12, 2014 by way0utwest

This is the third hour of a three hour set of presentations on intermediate T-SQL techniques and features. This presentation covers the window functions that are available in SQL Server. Some of these functions were introduced in SQL Server 2005 … Continue reading →

Posted in Presentations | Tagged | Comments Off on Intermediate T-SQL: Window Functions

Intermediate T-SQL: PIVOT, UNPIVOT, and APPLY

Posted on October 12, 2014 by way0utwest

This is the second of a series of talks I put together on intermediate T-SQL topics that many database developers might not understand. In this talk, we cover the other join-type operators that exist in the FROM clause, outside of … Continue reading →

Posted in Presentations | Tagged | Comments Off on Intermediate T-SQL: PIVOT, UNPIVOT, and APPLY

Intermediate T-SQL: Writing Cleaner Code

Posted on October 12, 2014 by way0utwest

This session is an intermediate T-SQL session that helps users learn how to write better T-SQL code by covering a few items that many database developers might not be aware of. In an hour, users will lean how to: write … Continue reading →

Posted in Presentations | Tagged | Comments Off on Intermediate T-SQL: Writing Cleaner Code