{"id":4993,"date":"2013-03-19T02:35:15","date_gmt":"2013-03-19T02:35:15","guid":{"rendered":"http:\/\/craftydba.com\/?p=4993"},"modified":"2013-03-21T16:03:11","modified_gmt":"2013-03-21T16:03:11","slug":"rhode-island-bi-user-group","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=4993","title":{"rendered":"Rhode Island BI User Group"},"content":{"rendered":"<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2013\/03\/RI-BI-User-Group.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2013\/03\/RI-BI-User-Group.gif\" alt=\"\" title=\"RI-BI-User-Group\" width=\"146\" height=\"180\" class=\"alignleft size-full wp-image-4995\" \/><\/a><\/p>\n<p>I am delighted about the opportunity to present at the Rhode Island Business Intelligence User Group on March 20, 2013.  <\/p>\n<p>I have not been to Bryant University in a long time.  It will be great to see what is new since I last visited.<\/p>\n<p>I will be posting an updated version of the presentation with TSQL code before the end of the week.   <\/p>\n<p><span style=\"color: #008000;\">Topic:<\/span><\/p>\n<p>Effective Data Warehouse Storage Patterns<\/p>\n<p><span style=\"color: #008000;\">Abstract:<\/span><\/p>\n<p>Many companies start off with a simple data mart for reporting.  As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).<\/p>\n<p>Unexpected information growth in your data mart may lead to a performance impacted reporting system.  In short, your users will be lining up at your cube for their daily reports.<\/p>\n<p><span style=\"color: #FF0000;\">How do you reduce the size of your data mart and speed up data retrieval?<\/span><\/p>\n<p>This presentation will review the following techniques to fix your woes.<\/p>\n<p><span style=\"color: #008000;\">Coverage:<\/span><\/p>\n<p>1 &#8211; What is horizontal partitioning?<br \/>\n2 &#8211; Database sharding for daily information.<br \/>\n3 &#8211; Working with files and file groups.<br \/>\n3 &#8211; Partitioned views for performance.<br \/>\n4 &#8211; Table and Index partitions.<br \/>\n5 &#8211; Row Data Compression.<br \/>\n6 &#8211; Page Data Compression.<br \/>\n7 &#8211; Programming a sliding window.<br \/>\n8 &#8211; What are Federations in Azure SQL?<\/p>\n<p><a href='https:\/\/craftydba.com\/wp-content\/uploads\/2013\/03\/sql-pass-miner-effective-data-warehouse-storage-patterns.zip'>presentation bundle<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am delighted about the opportunity to present at the Rhode Island Business Intelligence User Group on March 20, 2013. I have not been to Bryant University in a long time. It will be great to see what is new since I last visited. I will be posting an updated version of the presentation with TSQL code before the end of the week. Topic: Effective Data Warehouse Storage Patterns Abstract: Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[797,15,508,509,796,798],"class_list":["post-4993","post","type-post","status-publish","format-standard","hentry","category-pres","tag-business-intelligence","tag-john-f-miner-iii","tag-pass","tag-presentation","tag-rhode-island","tag-user-group"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/4993","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=4993"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/4993\/revisions"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}