{"id":2586,"date":"2014-02-09T11:38:47","date_gmt":"2014-02-09T11:38:47","guid":{"rendered":"http:\/\/ruirib.net\/blog\/?p=2586"},"modified":"2014-02-16T12:28:07","modified_gmt":"2014-02-16T12:28:07","slug":"my-links-of-the-week-february-9-2014","status":"publish","type":"post","link":"https:\/\/ruirib.net\/index.php\/2014\/02\/my-links-of-the-week-february-9-2014\/","title":{"rendered":"My links of the week &#8211; February 9, 2014"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p>Here is my choice of links for the past week.<\/p>\r\n<ul>\r\n<li>SQL Server:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Paul Randal&#8217;s <a href=\"http:\/\/www.sqlperformance.com\/2014\/02\/sql-performance\/knee-jerk-performance-troubleshooting\">Avoiding Knee-Jerk Performance Troubleshooting<\/a>&nbsp;warns against superficial analysis of performance problems and offers examples of situations where that can happen, related to wait statistics.<\/li>\r\n<li class=\"betterSpacedBullets\">Kendra Little&#8217;s <a href=\"http:\/\/www.brentozar.com\/archive\/2014\/02\/statistics-matter-on-temp-tables-too\/\">Statistics Matter on Temp Tables, Too<\/a>&nbsp;shows that statistics are relevant in temp tables too and suggests a way to change the threshold for statistics to update automatically.<\/li>\r\n<li class=\"betterSpacedBullets\">Alex Grinberg&#8217;s <a href=\"http:\/\/www.sqlservercentral.com\/articles\/T-SQL\/106298\/\">Sending a Variable Number of Elements in a Parameter<\/a>&nbsp;presents three ways to send multiple rows of values, as parameters to stored procedures.<\/li>\r\n<li class=\"betterSpacedBullets\">Jeremiah Peschka&#8217;s <a href=\"http:\/\/www.brentozar.com\/archive\/2014\/02\/using-sql-servers-table-valued-parameters\/\">Using SQL Server\u2019s Table Valued Parameters&nbsp;<\/a>goes a bit deeper with tabled value parameters than the previous article from Alex Grinberg, showing how they can be used from C# and addressing some of the gotchas of using them.<\/li>\r\n<li class=\"betterSpacedBullets\">Joe Celko&#8217;s <a href=\"https:\/\/www.simple-talk.com\/sql\/learn-sql-server\/sql-server-sequence-basics\/\">SQL Server SEQUENCE Basics<\/a>&nbsp;explains how Sequences can be used in SQL Server 2012. It also provides a historical justification for the use of IDENTITY columns and explains why they shouldn&#8217;t be used for primary keys, while sequences should.<\/li>\r\n<li class=\"betterSpacedBullets\">Tibor Nagy&#8217;s <a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3159\/sql-server-security-checklist\/\">SQL Server Security Checklist<\/a>&nbsp;provides advice on the security configuration of a SQL Server production server.<\/li>\r\n<li class=\"betterSpacedBullets\">Sanjay Mishra&#8217;s <a href=\"http:\/s.msdn.com\/b\/sqlcat\/archive\/2014\/02\/04\/alwayson-availability-groups-comparing-on-premises-deployments-and-azure-vm-deployments.aspx\">AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments<\/a>&nbsp;explains the differences in deploying AlwayOn Availability Groups between on-premises and Azure VMs.<\/li>\r\n<li class=\"betterSpacedBullets\">Francesco Diaz&#8217;s <a href=\"http:\/s.technet.com\/b\/francesco_diaz\/archive\/2014\/02\/05\/configuring-database-mirroring-across-two-windows-azure-datacenters.aspx\">Configuring SQL Server Database Mirroring across two Windows Azure datacenters<\/a>&nbsp;shows how database mirroring accross Windows Azure datacenters can be setup.<\/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\">Jeremy Likness&#8217;s <a href=\"http:\/\/www.codeproject.com\/Articles\/718046\/10-Reasons-Web-Developers-Should-Learn-Angular\">10 Reasons Web Developers Should Learn Angular<\/a>&nbsp;offers 10 reasons for web developers to adopt Angular.JS, from&nbsp; data-binding, to dependency injection, filtering of output, and advanced templating.<\/li>\r\n<li class=\"betterSpacedBullets\">Lara Swanson&#8217;s <a href=\"http:\/\/programming.oreilly.com\/2014\/02\/responsive-web-design-performance.html\">Responsive Web Design Performance<\/a>&nbsp;argues for a mobile (and performance) design first approach and offers good reasons for that.<\/li>\r\n<li class=\"betterSpacedBullets\">Scott Hanselman&#8217;s&nbsp;<a href=\"http:\/\/www.hanselman.com\/ChecklistWhatNOTToDoInASPNET.aspx\">Checklist: What NOT to do in ASP.NET<\/a>&nbsp;offers advice on anti-patterns to avoid in ASP.NET development, with an interesting set of links to further reading (and viewing) on the subject.<\/li>\r\n<li class=\"betterSpacedBullets\">Gavyn McKenzie&#8217;s <a href=\"http:\/\/mobile.smashingmagazine.com\/2014\/02\/03\/one-solution-to-responsive-images\/\">One Solution To Responsive Images<\/a>&nbsp;presents an interesting solution for the responsive images problem.<\/li>\r\n<li class=\"betterSpacedBullets\">Jimmy Bogard&#8217;s <a href=\"http:\/\/lostechies.com\/jimmybogard\/2014\/02\/04\/rendering-asp-net-content-as-pdf\/\">Rendering ASP.NET content as PDF<\/a>&nbsp;shows a quick way of obtaining a PDF printout, from ASP.NET MVC pages, but the approach can be extended to other scenarios.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Big Data:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">James Kinley&#8217;s <a href=\"http:\/\/jameskinley.tumblr.com\/post\/37398560534\/the-lambda-architecture-principles-for-architecting\">The Lambda architecture: principles for architecting realtime Big Data systems<\/a>&nbsp;presents the principles of the Lambda architecture, proposed by Nathan Marz and James Warren in their <a href=\"http:\/\/www.manning.com\/marz\/\">Big Data<\/a> book.<\/li>\r\n<li class=\"betterSpacedBullets\">Soren Riise&#8217;s <a href=\"http:\/\/smartdatacollective.com\/soren-riise\/181471\/nosql-versus-rdbms-interactive-analytics-leveraging-right-and-left-brain-data\">NoSQL Vs. RDBMS for Interactive Analytics: Leveraging the Right and Left Brain of Data<\/a>&nbsp;provides some interesting advice on NoSQL vs. RDBMS choices.<\/li>\r\n<li class=\"betterSpacedBullets\">Alex Giamas&#8217;s <a href=\"http:\/\/www.infoq.com\/news\/2014\/02\/SQL-Apache-Hadoop-Impala-Hive\">Interactive SQL in Apache Hadoop with Impala and Hive<\/a>&nbsp;compares some aspects of current interactive SQL choices for Hadoop installations.<\/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\">Yaniv Yehuda&#8217;s <a href=\"http:\/\/www.infoq.com\/articles\/Database-Change-Deployment-Automation\">The Secrets of Database Change Deployment Automation<\/a>&nbsp;presents the difficulties associated with database change deployment and argues for a better solution to the problem of database change deployment than the traditional versioning or compare and sync tools.<\/li>\r\n<li class=\"betterSpacedBullets\">Scott Ambler&#8217;s&nbsp;<a href=\"http:\/\/www.infoq.com\/presentations\/daily-architecture-design\">Architecture and Design Are So Important<\/a>&nbsp;is a presentation on the importance of architecture and design and how they are integrated in a daily agile approach.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>That&#8217;s it for this week. Thank you for reading.<\/p>\r\n<p>&nbsp;<\/p>\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"Here is my choice of links for the past week. SQL Server: Paul Randal&#8217;s Avoiding Knee-Jerk Performance Troubleshooting&nbsp;warns against superficial analysis of performance problems and offers examples of situations where that can happen, related to wait statistics. Kendra Little&#8217;s Statistics Matter on Temp Tables, Too&nbsp;shows that statistics are relevant in temp tables too and suggests&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,2,77],"tags":[231,210,78,154,234,48,233,75,232,229,228,253,230,226,227,225,189],"class_list":["post-2586","post","type-post","status-publish","format-standard","hentry","category-links-of-the-week","category-sql-server","category-web-development","tag-always-on-availability-groups","tag-asp-net","tag-hadoop","tag-hive","tag-impala","tag-nosql","tag-pdf-printout","tag-responsive-design","tag-responsive-images","tag-security-configuration","tag-sequences","tag-sql-server","tag-sql-server-mirroring","tag-stored-procedure-parameters","tag-table-valued-parameter","tag-temp-tables","tag-wait-statistics"],"_links":{"self":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2586","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=2586"}],"version-history":[{"count":25,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2586\/revisions"}],"predecessor-version":[{"id":2787,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2586\/revisions\/2787"}],"wp:attachment":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/media?parent=2586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/categories?post=2586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/tags?post=2586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}