{"id":8641,"date":"2018-05-19T16:46:04","date_gmt":"2018-05-19T16:46:04","guid":{"rendered":"http:\/\/craftydba.com\/?p=8641"},"modified":"2024-12-26T21:03:52","modified_gmt":"2024-12-26T21:03:52","slug":"new-york-city-sql-saturday-716","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=8641","title":{"rendered":"New York City – SQL SATURDAY #716"},"content":{"rendered":"

I am enthusiastic about presenting at SQL Saturday #716<\/a> New York City at the Microsoft office in New York City on May 19, 2018. Of course, I am looking forward to seeing new friends, making new acquaintances, and learning something new.<\/p>\n

The meeting venue is at the following address. <\/p>\n

Microsoft Technology Center
\n 11 Times Square
\n New York, NY 10036<\/p>\n

Details about the presentations are below.<\/p>\n

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

Standard and Custom Auditing of Azure SQL Database<\/p>\n

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

\nThe process of classifying a company into an industry segment has been around since the 1950\u2019s. Wikipedia has listed several popular taxonomies that are in current use. Some industries are more regulated and have stricter compliance regulations than others. As a database administrator, how can we provide an audit trail to a compliance officer when a security issue has occurred?\n<\/p>\n

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

1 \u2013 Azure Auditing using Blob Storage
\n2 – Table auditing using after triggers
\n3 – Using database triggers for object auditing
\n4 – Using custom stored procedures for fine grain audits<\/p>\n

Details:<\/p>\n

Presentation Bundle<\/a><\/p>\n

\n  \n<\/p>\n

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

Staging data for Azure SQL services<\/p>\n

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

Most companies are faced with the ever-growing big data problem.\u00a0 It is estimated that there will be 40 zettabytes of new data generated between 2012 to 2020.\u00a0 See the computer world\u00a0article<\/a>\u00a0for details.\u00a0<\/p>\n

\nMost of this data will be generated by sensors and machines.\u00a0\u00a0 However, only a small portion of the data is available for users.\u00a0 How can IT professionals help business lines gather and process data from various sources?\n<\/p>\n

\nThere have been two schools of thought<\/span> on how to solve this problem.\n<\/p>\n

\nSchema on write<\/span> is represented by the traditional relational database. Raw data is ingested by an extract, transform and load (ETL) process. The data is stored in tables that enforce integrity and allow for quick retrieval. Only a small portion<\/span> of the total data owned by the company resides in the database.\n<\/p>\n

\nSchema on read<\/span> is represented by technologies such as Hadoop or PolyBase. These technologies assumed that data integrity was applied during the generation of the text files. The actual definition of the table is applied during the read operation. All data<\/span> owned by the company can reside in simple storage.\n<\/p>\n

\nToday, we will learn how to stage data using Azure blob storage<\/span>. This staged data can be ingested by both techniques.\n<\/p>\n

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

\n1 – Grab some big data.
\n2 – Create blob storage account.
\n3 – Copy data to container.
\n4 – Azure SQL database plumbing.
\n5 – Loading data with BULK INSERT.
\n6 – Azure SQL data warehouse plumbing.
\n7 – Loading data with POLYBASE.
\n8 – Azure automation with RUNBOOKS.<\/p>\n

Details:<\/p>\n

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

I am enthusiastic about presenting at SQL Saturday #716 New York City at the Microsoft office in New York City on May 19, 2018. Of course, I am looking forward to seeing new friends, making new acquaintances, and learning something new. The meeting venue is at the following address. Microsoft Technology Center 11 Times Square New York, NY 10036 Details about the presentations are below. Topic: Standard and Custom Auditing of Azure SQL Database Abstract: The process of classifying a company into an industry segment has been around since the…<\/p>\n","protected":false},"author":1,"featured_media":8359,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1128],"class_list":["post-8641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--new-york-city--sql-saturday-716--azure-blob-storage--azure-sql-db--azure-sql-dw--azure-au"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8641","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=8641"}],"version-history":[{"count":1,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8641\/revisions"}],"predecessor-version":[{"id":10332,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8641\/revisions\/10332"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/8359"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}