{"id":7522,"date":"2015-05-13T22:50:15","date_gmt":"2015-05-13T22:50:15","guid":{"rendered":"http:\/\/craftydba.com\/?p=7522"},"modified":"2016-04-19T20:04:55","modified_gmt":"2016-04-19T20:04:55","slug":"albany-sql-saturday-383","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=7522","title":{"rendered":"Rochester \u2013 SQL Saturday #383"},"content":{"rendered":"

Time to travel to the Flour City<\/a> to present at SQL Saturday #383<\/a> in Rochester, NY. It will be a good time to meet old friends, make new ones and learn something new.<\/p>\n

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! <\/p>\n

I will be talking in both the morning and afternoon sessions on the following topics in order.<\/p>\n

Morning Topic:<\/span><\/p>\n

Azure SQL Database \u2013 Software As A Service<\/p>\n

Abstract:<\/span><\/p>\n

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.<\/p>\n

Depending upon your companies philosophy, it might be great for development,
\ntesting, and possibly production environments.<\/p>\n

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.<\/p>\n

Coverage:<\/span><\/p>\n

1 \u2013 Create Azure Account
\n2 \u2013 Create Database Server
\n3 \u2013 Adding IP Rules for client access
\n4 \u2013 Capturing the connection string
\n5 \u2013 Using SSMS, SSDT or SQLCMD
\n6 \u2013 Creating a database from TSQL
\n7 \u2013 Sample database with common objects
\n8 \u2013 Good, bad and ugly truths
\n9 \u2013 Exciting new features in Azure SQL DB
\n10 \u2013 Various Migration patterns<\/p>\n

Details:<\/p>\n

presentation bundle<\/a><\/p>\n

 <\/p>\n

Afternoon Topic:<\/span><\/p>\n

Basic Database Design<\/p>\n

Abstract:<\/span><\/p>\n

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.<\/p>\n

This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.<\/p>\n

Topics are focused on data storage structures, security, and integrity.
\nAfter this presentation, will be ready to meet that clients need.<\/p>\n

Coverage:<\/span><\/p>\n

1 \u2013 Files & File Groups
\n2 \u2013 Logins & Users
\n3 \u2013 Security using schemas
\n4 \u2013 Database roles for access.
\n5 \u2013 Table design via SSMS or TSQL.
\n6 \u2013 Default, Check, and NULL constraints
\n7 \u2013 Handling table relationships (PK vs FK).
\n8 \u2013 To index or not to index?
\n9 \u2013 Testing database integrity using DML.<\/p>\n

Details:<\/p>\n

presentation bundle<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 \u2013 Software As A Service Abstract: Are you tired…<\/p>\n","protected":false},"author":1,"featured_media":2527,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1085],"class_list":["post-7522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--sql-saturday--sql-sat-383--rochester"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7522"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7522\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/2527"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}