Time to travel to the Flour City to present at SQL Saturday #723 in Rochester, NY. It will be a good time to meet old friends, make new ones and learn something new.
I am really glad that my daughter Josie decided to go on the road trip with me. It is really boring driving 350+ miles by yourself!
I hope you have time to attend this awesome free event on March 24, 2018. Here are the details behind the two presentations that I am giving that day.
First 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.
Details:
Second Presentation
Topic:
How to audit and prevent unwanted user actions.
Abstract:
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.
Details:
