I am hitting the highway to visit the Cradle of the Union. I am delighted to have the opportunity to present at SQL Saturday #302 in Albany, NY at the same time.
It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on July 26th, 2014! It only costs $10 if you want a lunch.
Below are the details for my morning presentation.
Topic:
Basic Database Programming
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice. This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects. After this presentation, will be ready to meet that clients need.
This presentation will review the following topics to get you ready to code.
Coverage:
1 – How is a view better than ad-hoc SQL?
2 – Abstracting underlying tables via a view.
3 – Avoiding DML updates to views.
4 – Using triggers to enforce business rules.
5 – Using triggers to prevent data modifications.
6 – What are the different types of functions?
7 – Simple use of each type.
8 – Using stored procedures as an application interface.
9 – Batch programming using stored procedures.
10 – How to schedule batch jobs.
Below are the details for my afternoon presentation.
Topic:
Effective use of temporary tables
Abstract:
Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.
I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.
Coverage:
1 – Derived tables.
2 – Local temporary tables.
3 – Global temporary tables.
4 – Table variables.
5 – Common Table Expressions (CTE).
6 – User databases in [tempdb].
7 – Trace Flag 1118.
Here is a previous slide deck on this topic.
