Daily Archives: October 12, 2014

Document, then Install

I saw someone post a note that they had installed a new SQL Server and wanted to document the install. Did anyone have a good script or process for doing this? I’ve done this myself, but lately it seems to … Continue reading

Posted in Editorial | Tagged ,

Intermediate T-SQL: Window Functions

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

Intermediate T-SQL: PIVOT, UNPIVOT, and APPLY

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

Intermediate T-SQL: Writing Cleaner Code

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