{"id":20455,"date":"2017-05-16T09:30:00","date_gmt":"2017-05-16T16:30:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=20455"},"modified":"2024-01-22T22:50:58","modified_gmt":"2024-01-23T06:50:58","slug":"keeping-freight-moving-in-denmark-with-sql-server-2016","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/05\/16\/keeping-freight-moving-in-denmark-with-sql-server-2016\/","title":{"rendered":"Keeping freight moving in Denmark with SQL Server 2016"},"content":{"rendered":"
<\/a><\/p>\n Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country\u2019s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40,000 consignments each day throughout Denmark, and businesses from small mom-and-pop operations to factories rely on its services.<\/p>\n The firm handles logistics in a central location, where 200 dispatchers keep an eye on the movement of thousands of trucks and their cargo. Both drivers and dispatchers need the latest information to operate efficiently, so they rely on a data platform based on SQL Server 2016. The storage system includes 160 terabytes of flash memory for fast I\/O and high uptimes. Throughout the day, drivers continually scan transactions with PDAs and send shipping information including GPS coordinates to the data platform. Fast access to information is essential. Ulf Preisler, chief information officer at Danske Fragtmaend, says, \u201cWhen it comes to short-term logistics, you’ve got to think like an air traffic controller more than a traditional radio dispatcher.\u201d<\/p>\n Because the data changes rapidly, asynchronous replication between geographically disparate datacenters was inadequate. Instead, Danske Fragtmaend runs SQL Server on Windows 2016. Windows Server 2016 introduces a new disaster recovery and preparedness feature, Storage Replica, which enables storage-agnostic, synchronous replication of data across geographically diverse datacenters. Even if disaster strikes one location, all the data exists elsewhere, so there is no possibility of loss.<\/p>\n <\/a><\/p>\n Best of all, companies that combine flash storage with the latest versions of SQL Server and Windows Server can achieve a multiplying effect on performance. Danske Fragmaend\u2019s lead software developer, Morten Vinther, ran several tests to compare the old storage stack with the new one. \u201cAfter combining the new all-flash infrastructure and the features from SQL Server 2016 on Windows Server 2016, one of our BI queries ran 9,521 times faster than on the prior infrastructure. That is much more than we expected.\u201d<\/p>\n To find out more about Danske Fragtmaend\u2019s SQL Server 2016 implementation, read the customer story.<\/a><\/p>\n Customer Name: <\/b>Danske Fragtmaend<\/b> Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country\u2019s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40,000 consignments each day throughout Denmark, and businesses from small mom-and-pop operations to factories rely on its services. The firm handles<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2424],"topic":[2469],"coauthors":[2487],"class_list":["post-20455","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-best-practices","topic-high-performance-database"],"yoast_head":"\n
\nIndustry: <\/b>Transportation and logistics<\/b>
\nCountry or Region: <\/b>Denmark<\/b>
\nCustomer Website: <\/b>www.fragt.dk<\/b><\/a><\/b>
\nEmployee Size: <\/b>900<\/p>\n","protected":false},"excerpt":{"rendered":"