Time to travel to the Flour City to present at SQL Saturday #383 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 friend Matt decided to go on the road trip with me. It is really boring driving 350+ miles by yourself!
I will be talking in both the morning and afternoon sessions on the following topics in order.
Morning Topic:
Azure SQL Database – Software As A Service
Abstract:
Are you tired of installing, configuring and patching Microsoft SQL Server? Azure SQL database maybe a way to move some of your existing infrastructure to the cloud.
Depending upon your companies philosophy, it might be great for development,
testing, and possibly production environments.
The exciting thing about this service is that new features will be released on this platform first before trickling down to the on-premise editions.
Coverage:
1 – Create Azure Account
2 – Create Database Server
3 – Adding IP Rules for client access
4 – Capturing the connection string
5 – Using SSMS, SSDT or SQLCMD
6 – Creating a database from TSQL
7 – Sample database with common objects
8 – Good, bad and ugly truths
9 – Exciting new features in Azure SQL DB
10 – Various Migration patterns
Details:
Afternoon Topic:
Basic Database Design
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, your existing DBA has given two weeks notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.
Topics are focused on data storage structures, security, and integrity.
After this presentation, will be ready to meet that clients need.
Coverage:
1 – Files & File Groups
2 – Logins & Users
3 – Security using schemas
4 – Database roles for access.
5 – Table design via SSMS or TSQL.
6 – Default, Check, and NULL constraints
7 – Handling table relationships (PK vs FK).
8 – To index or not to index?
9 – Testing database integrity using DML.
Details:
