{"id":7960,"date":"2016-04-01T20:30:11","date_gmt":"2016-04-01T20:30:11","guid":{"rendered":"http:\/\/craftydba.com\/?p=7960"},"modified":"2016-04-28T20:54:28","modified_gmt":"2016-04-28T20:54:28","slug":"sg","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=7960","title":{"rendered":"Rhode Island \u2013 BI User Group \u2013 April 2016"},"content":{"rendered":"

 <\/p>\n

 <\/p>\n

I am delighted about the opportunity to present at the Rhode Island Business Intelligence User Group on April 27, 2016. <\/p>\n

I look forward to seeing old friends and meeting new ones. I will presenting the following topic that night.<\/p>\n

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

Best Practices\u000bfor SQL Server on an Azure VM<\/p>\n

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

This presentation goes over key concepts that relate to both on the on premise and in cloud deployments.<\/p>\n

Database processing involves CPU, RAM and DISK. I will go over engine settings and architectural choices that will help you get the most out of your Virtual Machine.<\/p>\n

Even if you VM is configured to run extremely well, bad coding by the developers can cause performance issues. I will talk about using standard alerting for such identifying such conditions. <\/p>\n

In the past, the DBA or SYSADMIN was responsible for patching and maintenance. New services in Azure allow you to automate some of these tasks.<\/p>\n

Regardless of where your SQL Server database lives, this talk has something thing for everyone.<\/p>\n

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

    \n
  1. Design virtual machine<\/li>\n
  2. Access virtual machine<\/li>\n
  3. Configure windows settings<\/li>\n
  4. Setup database engine<\/li>\n
  5. Install database mail<\/li>\n
  6. Enable basic alerting<\/li>\n
  7. Provide maintenance plans<\/li>\n
  8. Take system baseline<\/li>\n<\/ol>\n

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

        I am delighted about the opportunity to present at the Rhode Island Business Intelligence User Group on April 27, 2016. I look forward to seeing old friends and meeting new ones. I will presenting the following topic that night. Topic: Best Practices\u000bfor SQL Server on an Azure VM Abstract: This presentation goes over key concepts that relate to both on the on premise and in cloud deployments. Database processing involves CPU, RAM and DISK. I will go over engine settings and architectural choices that will help you get…<\/p>\n","protected":false},"author":1,"featured_media":4995,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1098],"class_list":["post-7960","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-sql-pass-events--business-intelligence--john-f-miner-iii--pass--presentation--rhode-island--user-group--sql-server--azure-vm"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7960","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=7960"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7960\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/4995"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}