{"id":8357,"date":"2016-12-10T00:00:32","date_gmt":"2016-12-10T00:00:32","guid":{"rendered":"http:\/\/craftydba.com\/?p=8357"},"modified":"2017-10-15T18:05:09","modified_gmt":"2017-10-15T18:05:09","slug":"sql","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=8357","title":{"rendered":"Providence \u2013 SQL Saturday #575"},"content":{"rendered":"

I traveling thru America\u2019s Renaissance City<\/a> to present at SQL Saturday #575 in Smithfield, RI. It will be a good time to meet old friends, make new ones and learn something new. I would like the opportunity to thank Bryant University for allowing the two Rhode Island user groups to use their fine campus.<\/p>\n

Here are the details behind the first presentation<\/a> that I gave that day.<\/p>\n

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

Public Preview of SQL on Linux<\/p>\n

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

There was a lot of excitement at the Connect() developer conference in November 2016. Two major announcements were made at the conference.<\/p>\n

First, visual studio code now runs on Windows, Linux and Mac. Second, SQL Server v.Next is coming to Linux. This means a developer can<\/p>\n

develop code against SQL Server in a Window less environment. If you are really passionate about Linux, join the hundreds downloading and testing this preview release.<\/p>\n

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

1 – Core code deployed for multiple environments.<\/p>\n

2 – Installs on Red Hat and Ubuntu flavors of linux. <\/p>\n

3 – Generate ssh key.<\/p>\n

4 – Deploy standard Red Hat image.<\/p>\n

5 – Install core engine and tools on linux.<\/p>\n

6 – Connect to engine via sqlcmd.<\/p>\n

7 – Open firewall for external access.<\/p>\n

8 – Create database on Linux via SSMS in windows.<\/p>\n

9 – Load data into table via bcp.<\/p>\n

10 – Supports docker (container) images.<\/p>\n

11 – Current limitations.<\/p>\n

12 – Future road map.<\/p>\n

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

 <\/p>\n

Here are the details behind the second presentation<\/a> I gave that day.<\/p>\n

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

Effective Data Warehouse Storage Patterns<\/p>\n

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

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

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

How do you reduce the size of your data mart and speed up data retrieval?<\/span><\/p>\n

This presentation will review the following techniques to fix your woes.<\/p>\n

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

1 – What is horizontal partitioning?
\n2 – Database sharding for daily information.
\n3 – Working with files and file groups.
\n3 – Partitioned views for performance.
\n4 – Table and Index partitions.
\n5 – Row Data Compression.
\n6 – Page Data Compression.
\n7 – Programming a sliding window.
\n8 – What are Federations in Azure SQL?<\/p>\n

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

I traveling thru America\u2019s Renaissance City to present at SQL Saturday #575 in Smithfield, RI. It will be a good time to meet old friends, make new ones and learn something new. I would like the opportunity to thank Bryant University for allowing the two Rhode Island user groups to use their fine campus. Here are the details behind the first presentation that I gave that day. Topic: Public Preview of SQL on Linux Abstract: There was a lot of excitement at the Connect() developer conference in November 2016. Two…<\/p>\n","protected":false},"author":1,"featured_media":8359,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1100],"class_list":["post-8357","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--rhode-island--sql-saturday--linux--public-preview--data-ware-house--storage-patterns"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8357","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=8357"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8357\/revisions"}],"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=8357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}