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.
Azure SQL Database – Software As A Service
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.
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
Basic Database Design
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.
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.