{"id":1269,"date":"2013-12-15T08:21:05","date_gmt":"2013-12-15T08:21:05","guid":{"rendered":"http:\/\/ruirib.net\/blog\/?p=1269"},"modified":"2013-12-16T23:52:34","modified_gmt":"2013-12-16T23:52:34","slug":"my-links-of-the-week-december-15-2013","status":"publish","type":"post","link":"https:\/\/ruirib.net\/index.php\/2013\/12\/my-links-of-the-week-december-15-2013\/","title":{"rendered":"My links of the week &#8211; December 15, 2013"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p style=\"text-align: left;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1299\" alt=\"500px-Relational_Model.svg\" src=\"http:\/\/ruirib.net\/wp-content\/uploads\/2013\/12\/500px-Relational_Model.svg_-300x298.png\" width=\"300\" height=\"298\" srcset=\"https:\/\/ruirib.net\/wp-content\/uploads\/2013\/12\/500px-Relational_Model.svg_-300x298.png 300w, https:\/\/ruirib.net\/wp-content\/uploads\/2013\/12\/500px-Relational_Model.svg_-150x150.png 150w, https:\/\/ruirib.net\/wp-content\/uploads\/2013\/12\/500px-Relational_Model.svg_.png 500w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>Here is my selection of the links from the past week.<\/p>\r\n<ul>\r\n<li>SQL Server:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Last week was T-SQL Tuesday week, Waits being this month&#8217;s subject. Robert L. Davis was the host, and several interesting posts are included in his roundup: <a href=\"http:\/\/www.sqlsoldier.com\/wp\/sqlserver\/tsqltuesday49waitforitroundup\">T-SQL Tuesday #49: Wait For It Roundup<\/a>.<\/li>\r\n<li class=\"betterSpacedBullets\">Basit Farooq&#8217;s <a href=\"http:\/\/www.sql-server-performance.com\/2013\/sql-server-query-optimization-part-3\/\">Understanding SQL Server Query Optimization \u2013 Part 3<\/a>\u00a0is the third of a series of four articles on query optimization. The previous 2 articles can be found <a href=\"http:\/\/www.sql-server-performance.com\/2013\/sql-server-query-optimization-part-1\/\">here<\/a> and <a href=\"http:\/\/www.sql-server-performance.com\/2013\/understanding-sql-server-query-optimization-part-2\/\">here<\/a>.<\/li>\r\n<li class=\"betterSpacedBullets\">Jeremiah Peschka&#8217;s <a href=\"http:\/\/www.brentozar.com\/archive\/2013\/12\/keep-it-constrained\/\">Keep it Constrained<\/a>\u00a0addresses unique, primary key and check constraints in SQL Server, including a smart way to deal with NULLs in unique constraints.<\/li>\r\n<li class=\"betterSpacedBullets\">John Sterrett&#8217;s\u00a0<a href=\"http:\/\/johnsterrett.com\/2013\/12\/12\/throwback-thursday-3-sql-server-disks\/\">Throwback Thursday #3: SQL Server &amp; Disks<\/a>\u00a0presents \u00a0several very interesting articles on disks,storage systems and SQL Server.<\/li>\r\n<li class=\"betterSpacedBullets\">Tracy McKibben&#8217;s <a href=\"http:\/\/realsqlguy.com\/dont-get-slimed-bad-parameter-sniffing\/\">Don\u2019t Get Slimed By Bad Parameter Sniffing<\/a>\u00a0addresses parameter sniffing, explaining what it is, how it can create performance problems what can be done to overcome such problems.<\/li>\r\n<li class=\"betterSpacedBullets\">Kenneth Fisher&#8217;s <a href=\"A better way to find missing indexes\">A better way to find missing indexes<\/a>\u00a0presents an interesting script to find missing indexes and present them alongside the queries where their absence can make a difference.<\/li>\r\n<li class=\"betterSpacedBullets\">Jonathan Allen&#8217;s<a href=\"https:\/\/www.simple-talk.coms\/2013\/12\/12\/i-thought-everyone-did-it-like-that-ssms-templates\/\"> I Thought Everyone Did It Like That \u2013 SSMS Templates<\/a>\u00a0is an interesting article that covers SQL Server Management Studio Templates, showing how they can be useful, how they can be customized through the use of parameters, and how new templates can be added.<\/li>\r\n<li class=\"betterSpacedBullets\">Microsoft&#8217;s SQL Server Team <a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/12\/10\/sql-server-2014-hybrid-cloud-scenarios-migrating-on-premises-sql-server-to-windows-azure-virtual-machines.aspx\">SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines<\/a>\u00a0presents one of the new wizards in SQL Server 2014 SSMS,that assists in the deployment of a database to a Windows Azure VM and gives a step by step description of the deployment process, using the wizard.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Web Design and Development:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Sara Souiedan&#8217;s <a href=\"http:\/\/sarasoueidan.com\/css-shapes\/index.html\">Creating Non-Rectangular Layouts with CSS Shapes<\/a>\u00a0is a very detailed and interesting article on CSS Shapes, a current W3C Draft meant to allow inline content to wrap around floats of shape other than the regular floats&#8217; bounding box.\u00a0<\/li>\r\n<li class=\"betterSpacedBullets\">Sorin Pintilie&#8217;s <a href=\"http:\/\/uxdesign.smashingmagazine.com\/2013\/12\/11\/the-line-of-least-resistance\/\">The Line Of Least Resistance<\/a>\u00a0is an excellent article that addresses the importance of context in designing an enjoyable experiences for users.\u00a0<\/li>\r\n<li class=\"betterSpacedBullets\">John Tabita&#8217;s <a href=\"http:\/\/www.sitepoint.com\/keep-web-projects-moving-forward-part-1\/\">How to Keep Web Projects Moving Forward, Part 1<\/a> and <a href=\"http:\/\/www.sitepoint.com\/keep-web-projects-moving-forward-part-2\/\">How to Keep Web Projects Moving Forward, Part 2<\/a>\u00a0addresses common difficulties in web projects and provides advice on how to overcome those difficulties.<\/li>\r\n<li class=\"betterSpacedBullets\">Andi Smith&#8217;s <a href=\"http:\/\/www.creativebloq.com\/netmag\/make-better-websites-browser-developer-tools-121310101\">Make better websites with browser developer tools<\/a>\u00a0provides a set of interesting tips and tricks to help developing better websites, using a varied assortment of tools.\u00a0<\/li>\r\n<li class=\"betterSpacedBullets\">David Paquette&#8217;s <a href=\"http:\/s.msdn.com\/b\/cdndevs\/archive\/2013\/12\/09\/browser-link-tracking-unused-css.aspx\">Browser Link\u2013Tracking Unused CSS<\/a>\u00a0shows how Browser Link, a new feature of Visual Studio 2013, can be used to identify unused CSS in a website.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Software Development:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Monjurul Habib&#8217;s <a href=\"http:\/\/www.codeproject.com\/Articles\/604417\/Agile-software-development-methodologies-and-how-t\">Agile software development methodologies and how to apply them<\/a>\u00a0provides an introduction and overview of development methodologies based on Agile.<\/li>\r\n<li class=\"betterSpacedBullets\">Damien Guard&#8217;s\u00a0<a href=\"http:\/\/damieng.com\/2013\/12\/09\/probable-c-6-0-features-illustrated\">Probable C# 6.0 features illustrated<\/a>\u00a0presents some of the probable new features for the 6.0 version of C#.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Big Data \/ BI :\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Doug Turnbull&#8217;s <a href=\"http:\/\/www.opensourceconnections.com\/2013\/12\/11\/codds-relational-vision-has-nosql-come-full-circle\/\">Codd\u2019s Relational Vision \u2013 Has NoSQL Come Full Circle?<\/a> is a very interesting article that goes back to the original Codd&#8217;s work on relational databases, analyzing Codd&#8217;s criticism of the database systems that existed at the time, to raise the question of whether we have come full circle. Codd&#8217;s original arguments that lead to his proposal ofthe relational database model, are used to warn about the risks of denormalization, while taking advantage of that very denormalization in NoSQL databases.<\/li>\r\n<li class=\"betterSpacedBullets\"><a href=\"http:\/\/www.se-radio.net\/2013\/12\/episode-199-michael-stonebraker\/\">Software Engineering Radio&#8217;s Episode 199<\/a> is a podcast, featuring Michael Stonebraker, a leading MIT database reasearcher. The podcast covers multiple database related subjects of great interest, including &#8220;NewSQL&#8221; databases.<\/li>\r\n<li>Andrew Burst&#8217;s <a href=\"http:\/\/www.zdnet.com\/predicting-big-datas-2014-7000024189\/\">Predicting Big Data&#8217;s 2014<\/a>\u00a0presents a few predictions about what 2014 can bring to Big Data, from a set of companies working in the field.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>That&#8217;s it for this week. Thanks for reading.<\/p>","protected":false},"excerpt":{"rendered":"Here is my selection of the links from the past week. SQL Server: Last week was T-SQL Tuesday week, Waits being this month&#8217;s subject. Robert L. Davis was the host, and several interesting posts are included in his roundup: T-SQL Tuesday #49: Wait For It Roundup. Basit Farooq&#8217;s Understanding SQL Server Query Optimization \u2013 Part&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,45,2,77],"tags":[97,61,184,182,124,183,181,179,118,253,180],"class_list":["post-1269","post","type-post","status-publish","format-standard","hentry","category-links-of-the-week","category-software-engineering","category-sql-server","category-web-development","tag-agile","tag-azure-sql-vm","tag-browser-link","tag-constraints","tag-css","tag-css-shapes","tag-parameter-sniffing","tag-query-optimization","tag-rdbms","tag-sql-server","tag-storage"],"_links":{"self":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/1269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/comments?post=1269"}],"version-history":[{"count":27,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/1269\/revisions"}],"predecessor-version":[{"id":1304,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/1269\/revisions\/1304"}],"wp:attachment":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/media?parent=1269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/categories?post=1269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/tags?post=1269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}